mybatisplus实现学生信息增删改查业务

MyBatis Plus是一种基于MyBatis的增强工具，可以简化MyBatis的开发流程，并提供了一些方便的功能，如通用CRUD操作、分页查询、动态SQL等。下面是使用MyBatis Plus实现学生信息的增删改查业务的示例：

创建学生实体类

@Data
@TableName("student")
public class Student {
    @TableId(type = IdType.AUTO)
    private Long id;
    private String name;
    private Integer age;
    private String gender;
}

创建学生Mapper接口

public interface StudentMapper extends BaseMapper<Student> {
}

创建学生Service接口和实现类

public interface StudentService {
    Student getById(Long id);
    List<Student> getAll();
    void save(Student student);
    void update(Student student);
    void deleteById(Long id);
}

@Service
public class StudentServiceImpl implements StudentService {
    @Autowired
    private StudentMapper studentMapper;

    @Override
    public Student getById(Long id) {
        return studentMapper.selectById(id);
    }

    @Override
    public List<Student> getAll() {
        return studentMapper.selectList(null);
    }

    @Override
    public void save(Student student) {
        studentMapper.insert(student);
    }

    @Override
    public void update(Student student) {
        studentMapper.updateById(student);
    }

    @Override
    public void deleteById(Long id) {
        studentMapper.deleteById(id);
    }
}

创建学生Controller

@RestController
@RequestMapping("/students")
public class StudentController {
    @Autowired
    private StudentService studentService;

    @GetMapping("/{id}")
    public Student getById(@PathVariable Long id) {
        return studentService.getById(id);
    }

    @GetMapping("/")
    public List<Student> getAll() {
        return studentService.getAll();
    }

    @PostMapping("/")
    public void save(@RequestBody Student student) {
        studentService.save(student);
    }

    @PutMapping("/")
    public void update(@RequestBody Student student) {
        studentService.update(student);
    }

    @DeleteMapping("/{id}")
    public void deleteById(@PathVariable Long id) {
        studentService.deleteById(id);
    }
}

以上代码实现了基本的学生信息的增删改查业务。使用MyBatis Plus，我们可以通过继承BaseMapper接口来获得通用的CRUD操作，无需手动编写SQL语句。同时，MyBatis Plus还提供了丰富的查询条件构造器，可以更方便地进行条件查询和分页查询