☁️快速开发（学生管理进阶完善篇）

@ApiOperation("列表")
@GetMapping("/list")
public Q<List<Student>> list(@RequestParam Map<String, Object> params) {
    return service.listPage(params, true);
}

package com.object.module.stu.controller;

import java.util.Arrays;
import java.util.List;
import java.util.Map;

import com.object.utils.Q;

import javax.annotation.Resource;

import io.swagger.annotations.ApiOperation;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiParam;
import org.springframework.web.bind.annotation.*;
import java.net.URLEncoder;
import com.alibaba.excel.EasyExcel;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import com.object.module.stu.service.StudentService;
import com.object.module.stu.bean.Student;


/**
 * 学生信息表
 *
 * @author Li~Qing
 **/
@RestController
@RequestMapping("/stu/Student")
@Api(tags = "学生信息表接口")
public class StudentController{
    @Resource
    private StudentService service;


    @ApiOperation("列表")
    @GetMapping("/list")
    public Q<List<Student>> list(@RequestParam Map<String, Object> params) {
        return service.listPage(params, true);
    }


    @ApiOperation("详情")
    @GetMapping("/info/{id}")
    public Q<Student> info(@PathVariable("id") String id) {
    Student bean = service.getById(id);
        return new Q<Student >().ok(bean);
    }


    @ApiOperation("保存")
    @PostMapping("/save")
    public Q<Boolean> save(@RequestBody Student bean) {
        return new Q<Boolean>().ok(service.save(bean));
    }

    @ApiOperation("修改根据id")
    @PostMapping("/update")
    public Q<Boolean> update(@RequestBody Student bean) {
        return new Q<Boolean>().ok(service.updateById(bean));
    }

    @ApiOperation("批量操作")
    @PostMapping("/batchWord")
    public Q<Boolean> update(@RequestBody List<Student> beans) {
        return new Q<Boolean>().ok(service.updateBatchById(beans));
    }

    @ApiOperation("删除根据id")
    @PostMapping("/delete")
    public Q<Boolean> delete(@RequestBody String[] ids) {
        return new Q<Boolean>().ok(service.removeByIds(Arrays.asList(ids)));
    }

    @ApiOperation("导出")
    @GetMapping("export")
    public void importExcel(@ApiParam(value = "导出条件", required = true) @RequestParam(required = false) Map<String, Object> params, HttpServletResponse response) throws IOException {
        Q<List<Student>> list = service.listPage(params, false);
        // 设置响应头
        response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet; charset=UTF-8");
        response.setCharacterEncoding("UTF-8");
        String fileName = URLEncoder.encode("学生信息表.xlsx", "UTF-8");
        response.setHeader("Content-Disposition", "attachment; filename=" + fileName);
        EasyExcel.write(response.getOutputStream(), Student.class).sheet("学生信息表").doWrite(list.getT());
    }

}

package com.object.module.stu.bean;

import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.AllArgsConstructor;
import lombok.EqualsAndHashCode;
import lombok.NoArgsConstructor;
import com.alibaba.excel.annotation.ExcelIgnoreUnannotated;
import com.alibaba.excel.annotation.ExcelProperty;
import com.baomidou.mybatisplus.annotation.TableName;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import com.alibaba.excel.annotation.ExcelProperty;
import com.baomidou.mybatisplus.annotation.IdType;

import java.time.LocalDate;

import com.baomidou.mybatisplus.annotation.TableId;

import java.time.LocalDateTime;
import java.io.Serializable;

import lombok.Data;
import com.baomidou.mybatisplus.annotation.TableName;

/**
 * <p>
 * 学生信息表
 * </p>
 *
 * @since 2025-12-05
 */
@TableName("student")
@ApiModel(value = "Student对象", description = "学生信息表")
@ExcelIgnoreUnannotated
@Data
public class Student implements Serializable {

    private static final long serialVersionUID = 1L;

    @ApiModelProperty(value = "主键ID")
    @ExcelProperty("主键ID")
    @TableId(value = "id", type = IdType.AUTO)
    private Long id;

    @ApiModelProperty(value = "学号，业务唯一标识，如 S20250001")
    @ExcelProperty("学号，业务唯一标识，如 S20250001")
    private String studentId;

    @ApiModelProperty(value = "学生姓名")
    @ExcelProperty("学生姓名")
    private String name;

    @ApiModelProperty(value = "性别：M-男, F-女, O-其他")
    @ExcelProperty("性别：M-男, F-女, O-其他")
    private String gender;

    @ApiModelProperty(value = "出生日期")
    @ExcelProperty("出生日期")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private LocalDate dateOfBirth;

    @ApiModelProperty(value = "电子邮箱")
    @ExcelProperty("电子邮箱")
    private String email;

    @ApiModelProperty(value = "手机号码")
    @ExcelProperty("手机号码")
    private String phone;

    @ApiModelProperty(value = "家庭住址")
    @ExcelProperty("家庭住址")
    private String address;

    @ApiModelProperty(value = "入学日期")
    @ExcelProperty("入学日期")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private LocalDate enrollmentDate;

    @ApiModelProperty(value = "年级，如 高一、大三、Grade 10")
    @ExcelProperty("年级，如 高一、大三、Grade 10")
    private String grade;

    @ApiModelProperty(value = "专业名称，如 计算机科学与技术")
    @ExcelProperty("专业名称，如 计算机科学与技术")
    private String major;

    @ApiModelProperty(value = "学籍状态：0-在读, 1-毕业, 2-休学, 3-退学")
    @ExcelProperty("学籍状态：0-在读, 1-毕业, 2-休学, 3-退学")
    private Integer status;

    @ApiModelProperty(value = "记录创建时间")
    @ExcelProperty("记录创建时间")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private LocalDateTime createdAt;

    @ApiModelProperty(value = "记录最后更新时间")
    @ExcelProperty("记录最后更新时间")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    private LocalDateTime updatedAt;


}

@ApiOperation("保存")
@PostMapping("/save")
public Q<Boolean> save(@RequestBody Student bean) {
    bean.setCreatedAt(LocalDateTime.now());
    bean.setUpdatedAt(LocalDateTime.now());
    bean.setStudentId(UUID.randomUUID().toString().replaceAll("-",""));
    return new Q<Boolean>().ok(service.save(bean));
}

@ApiOperation("修改根据id")
@PostMapping("/update")
public Q<Boolean> update(@RequestBody Student bean) {
    bean.setUpdatedAt(LocalDateTime.now());
    return new Q<Boolean>().ok(service.updateById(bean));
}