1. 项目概述Spring Boot 4.0.2与MyBatis-Plus 3.5.5的组合堪称Java后端开发的黄金搭档。作为一名长期奋战在CRUD战场的老兵我深知重复编码的痛苦——每次新项目都要重写那些几乎相同的增删改查代码既浪费时间又容易出错。直到遇见MyBatis-Plus这个基于MyBatis的增强工具包才真正让我从这种低效劳动中解放出来。这个组合特别适合需要快速开发的中小型项目团队中Java基础参差不齐的情况需要保证代码质量但时间紧迫的场景需要灵活应对需求变更的项目2. 环境搭建与配置2.1 项目初始化使用Spring Initializr创建项目时我推荐选择以下依赖Spring WebLombokMySQL DriverMyBatis-Pluspom.xml关键依赖配置dependency groupIdcom.baomidou/groupId artifactIdmybatis-plus-boot-starter/artifactId version3.5.5/version /dependency dependency groupIdorg.springframework.boot/groupId artifactIdspring-boot-starter-web/artifactId version4.0.2/version /dependency2.2 数据库配置application.yml配置示例spring: datasource: driver-class-name: com.mysql.cj.jdbc.Driver url: jdbc:mysql://localhost:3306/mp_demo?useSSLfalseserverTimezoneUTC username: root password: 123456 mybatis-plus: configuration: log-impl: org.apache.ibatis.logging.stdout.StdOutImpl # 开启SQL日志注意MySQL 8.0必须指定serverTimezone参数否则会报时区错误3. 核心功能实现3.1 实体类设计User.java示例Data TableName(sys_user) public class User { TableId(type IdType.AUTO) private Long id; TableField(user_name) private String username; private String password; private Integer age; private String email; TableField(fill FieldFill.INSERT) private LocalDateTime createTime; TableField(fill FieldFill.INSERT_UPDATE) private LocalDateTime updateTime; }关键注解说明TableName指定表名TableId主键策略TableField字段映射与自动填充3.2 Mapper接口UserMapper.java简单到不可思议Mapper public interface UserMapper extends BaseMapperUser { // 无需任何方法声明 }BaseMapper提供的CRUD方法插入int insert(T entity)删除int deleteById(Serializable id)更新int updateById(T entity)查询T selectById(Serializable id)3.3 Service层封装虽然可以直接使用Mapper但我建议添加Service层Service public class UserService { Autowired private UserMapper userMapper; public User getById(Long id) { return userMapper.selectById(id); } public boolean saveUser(User user) { return userMapper.insert(user) 0; } // 其他CRUD方法... }4. 高级特性应用4.1 条件构造器QueryWrapper使用示例QueryWrapperUser wrapper new QueryWrapper(); wrapper.like(user_name, 张) .between(age, 20, 30) .isNotNull(email); ListUser users userMapper.selectList(wrapper);Lambda写法更安全LambdaQueryWrapperUser lambdaWrapper Wrappers.lambdaQuery(); lambdaWrapper.like(User::getUsername, 张) .lt(User::getAge, 30);4.2 分页查询配置分页插件Configuration public class MybatisPlusConfig { Bean public MybatisPlusInterceptor mybatisPlusInterceptor() { MybatisPlusInterceptor interceptor new MybatisPlusInterceptor(); interceptor.addInnerInterceptor(new PaginationInnerInterceptor()); return interceptor; } }分页查询示例PageUser page new Page(1, 10); LambdaQueryWrapperUser wrapper Wrappers.lambdaQuery(); wrapper.orderByDesc(User::getCreateTime); IPageUser userPage userMapper.selectPage(page, wrapper);4.3 自动填充实现MetaObjectHandlerComponent public class MyMetaObjectHandler implements MetaObjectHandler { Override public void insertFill(MetaObject metaObject) { this.strictInsertFill(metaObject, createTime, LocalDateTime.class, LocalDateTime.now()); } Override public void updateFill(MetaObject metaObject) { this.strictUpdateFill(metaObject, updateTime, LocalDateTime.class, LocalDateTime.now()); } }5. 实战技巧与避坑指南5.1 性能优化建议批量操作ListUser userList new ArrayList(); // 添加数据... boolean success userService.saveBatch(userList, 1000); // 每批1000条逻辑删除配置mybatis-plus: global-config: db-config: logic-delete-field: deleted # 逻辑删除字段名 logic-delete-value: 1 # 逻辑已删除值 logic-not-delete-value: 0 # 逻辑未删除值5.2 常见问题解决字段映射问题数据库字段user_name实体字段username 解决方案TableField(user_name) private String username;主键ID回填User user new User(); userMapper.insert(user); // 插入后自动回填ID Long id user.getId();版本冲突解决 如果遇到MyBatis与MyBatis-Plus版本冲突可以排除MyBatis自带版本dependency groupIdorg.mybatis.spring.boot/groupId artifactIdmybatis-spring-boot-starter/artifactId exclusions exclusion groupIdorg.mybatis/groupId artifactIdmybatis/artifactId /exclusion /exclusions /dependency6. 项目实战演示6.1 RESTful接口实现UserController示例RestController RequestMapping(/users) public class UserController { Autowired private UserService userService; GetMapping(/{id}) public ResultUser getById(PathVariable Long id) { return Result.success(userService.getById(id)); } PostMapping public ResultBoolean save(RequestBody User user) { return Result.success(userService.save(user)); } GetMapping(/page) public ResultIPageUser page(RequestParam(defaultValue 1) int current, RequestParam(defaultValue 10) int size) { return Result.success(userService.page(new Page(current, size))); } }6.2 复杂查询示例多表联查解决方案Select(SELECT u.*, d.dept_name FROM sys_user u LEFT JOIN sys_dept d ON u.dept_id d.id) ListUserVO selectUserWithDept();提示复杂SQL建议仍使用XML或注解方式MyBatis-Plus主要简化单表操作7. 扩展与进阶7.1 代码生成器MyBatis-Plus提供了强大的代码生成器FastAutoGenerator.create(jdbc:mysql://localhost:3306/mp_demo, root, 123456) .globalConfig(builder - builder.author(dev).outputDir(D://code)) .packageConfig(builder - builder.parent(com.example.mp)) .strategyConfig(builder - builder.addInclude(sys_user)) .execute();7.2 多数据源配置使用dynamic-datasource-spring-boot-starterspring: datasource: dynamic: primary: master datasource: master: url: jdbc:mysql://localhost:3306/master username: root password: 123456 slave: url: jdbc:mysql://localhost:3306/slave username: root password: 123456使用DS注解切换数据源Service DS(slave) public class UserServiceImpl implements UserService { // 查询方法默认使用slave数据源 DS(master) public void addUser(User user) { // 此方法使用master数据源 } }在实际项目中我发现MyBatis-Plus最适合中小型项目的快速开发但当系统复杂度增加到需要大量复杂SQL和存储过程时可能需要回归原生MyBatis的灵活性。不过对于80%的常规CRUD操作这个组合确实能提升至少50%的开发效率。
Spring Boot与MyBatis-Plus高效开发实践
1. 项目概述Spring Boot 4.0.2与MyBatis-Plus 3.5.5的组合堪称Java后端开发的黄金搭档。作为一名长期奋战在CRUD战场的老兵我深知重复编码的痛苦——每次新项目都要重写那些几乎相同的增删改查代码既浪费时间又容易出错。直到遇见MyBatis-Plus这个基于MyBatis的增强工具包才真正让我从这种低效劳动中解放出来。这个组合特别适合需要快速开发的中小型项目团队中Java基础参差不齐的情况需要保证代码质量但时间紧迫的场景需要灵活应对需求变更的项目2. 环境搭建与配置2.1 项目初始化使用Spring Initializr创建项目时我推荐选择以下依赖Spring WebLombokMySQL DriverMyBatis-Pluspom.xml关键依赖配置dependency groupIdcom.baomidou/groupId artifactIdmybatis-plus-boot-starter/artifactId version3.5.5/version /dependency dependency groupIdorg.springframework.boot/groupId artifactIdspring-boot-starter-web/artifactId version4.0.2/version /dependency2.2 数据库配置application.yml配置示例spring: datasource: driver-class-name: com.mysql.cj.jdbc.Driver url: jdbc:mysql://localhost:3306/mp_demo?useSSLfalseserverTimezoneUTC username: root password: 123456 mybatis-plus: configuration: log-impl: org.apache.ibatis.logging.stdout.StdOutImpl # 开启SQL日志注意MySQL 8.0必须指定serverTimezone参数否则会报时区错误3. 核心功能实现3.1 实体类设计User.java示例Data TableName(sys_user) public class User { TableId(type IdType.AUTO) private Long id; TableField(user_name) private String username; private String password; private Integer age; private String email; TableField(fill FieldFill.INSERT) private LocalDateTime createTime; TableField(fill FieldFill.INSERT_UPDATE) private LocalDateTime updateTime; }关键注解说明TableName指定表名TableId主键策略TableField字段映射与自动填充3.2 Mapper接口UserMapper.java简单到不可思议Mapper public interface UserMapper extends BaseMapperUser { // 无需任何方法声明 }BaseMapper提供的CRUD方法插入int insert(T entity)删除int deleteById(Serializable id)更新int updateById(T entity)查询T selectById(Serializable id)3.3 Service层封装虽然可以直接使用Mapper但我建议添加Service层Service public class UserService { Autowired private UserMapper userMapper; public User getById(Long id) { return userMapper.selectById(id); } public boolean saveUser(User user) { return userMapper.insert(user) 0; } // 其他CRUD方法... }4. 高级特性应用4.1 条件构造器QueryWrapper使用示例QueryWrapperUser wrapper new QueryWrapper(); wrapper.like(user_name, 张) .between(age, 20, 30) .isNotNull(email); ListUser users userMapper.selectList(wrapper);Lambda写法更安全LambdaQueryWrapperUser lambdaWrapper Wrappers.lambdaQuery(); lambdaWrapper.like(User::getUsername, 张) .lt(User::getAge, 30);4.2 分页查询配置分页插件Configuration public class MybatisPlusConfig { Bean public MybatisPlusInterceptor mybatisPlusInterceptor() { MybatisPlusInterceptor interceptor new MybatisPlusInterceptor(); interceptor.addInnerInterceptor(new PaginationInnerInterceptor()); return interceptor; } }分页查询示例PageUser page new Page(1, 10); LambdaQueryWrapperUser wrapper Wrappers.lambdaQuery(); wrapper.orderByDesc(User::getCreateTime); IPageUser userPage userMapper.selectPage(page, wrapper);4.3 自动填充实现MetaObjectHandlerComponent public class MyMetaObjectHandler implements MetaObjectHandler { Override public void insertFill(MetaObject metaObject) { this.strictInsertFill(metaObject, createTime, LocalDateTime.class, LocalDateTime.now()); } Override public void updateFill(MetaObject metaObject) { this.strictUpdateFill(metaObject, updateTime, LocalDateTime.class, LocalDateTime.now()); } }5. 实战技巧与避坑指南5.1 性能优化建议批量操作ListUser userList new ArrayList(); // 添加数据... boolean success userService.saveBatch(userList, 1000); // 每批1000条逻辑删除配置mybatis-plus: global-config: db-config: logic-delete-field: deleted # 逻辑删除字段名 logic-delete-value: 1 # 逻辑已删除值 logic-not-delete-value: 0 # 逻辑未删除值5.2 常见问题解决字段映射问题数据库字段user_name实体字段username 解决方案TableField(user_name) private String username;主键ID回填User user new User(); userMapper.insert(user); // 插入后自动回填ID Long id user.getId();版本冲突解决 如果遇到MyBatis与MyBatis-Plus版本冲突可以排除MyBatis自带版本dependency groupIdorg.mybatis.spring.boot/groupId artifactIdmybatis-spring-boot-starter/artifactId exclusions exclusion groupIdorg.mybatis/groupId artifactIdmybatis/artifactId /exclusion /exclusions /dependency6. 项目实战演示6.1 RESTful接口实现UserController示例RestController RequestMapping(/users) public class UserController { Autowired private UserService userService; GetMapping(/{id}) public ResultUser getById(PathVariable Long id) { return Result.success(userService.getById(id)); } PostMapping public ResultBoolean save(RequestBody User user) { return Result.success(userService.save(user)); } GetMapping(/page) public ResultIPageUser page(RequestParam(defaultValue 1) int current, RequestParam(defaultValue 10) int size) { return Result.success(userService.page(new Page(current, size))); } }6.2 复杂查询示例多表联查解决方案Select(SELECT u.*, d.dept_name FROM sys_user u LEFT JOIN sys_dept d ON u.dept_id d.id) ListUserVO selectUserWithDept();提示复杂SQL建议仍使用XML或注解方式MyBatis-Plus主要简化单表操作7. 扩展与进阶7.1 代码生成器MyBatis-Plus提供了强大的代码生成器FastAutoGenerator.create(jdbc:mysql://localhost:3306/mp_demo, root, 123456) .globalConfig(builder - builder.author(dev).outputDir(D://code)) .packageConfig(builder - builder.parent(com.example.mp)) .strategyConfig(builder - builder.addInclude(sys_user)) .execute();7.2 多数据源配置使用dynamic-datasource-spring-boot-starterspring: datasource: dynamic: primary: master datasource: master: url: jdbc:mysql://localhost:3306/master username: root password: 123456 slave: url: jdbc:mysql://localhost:3306/slave username: root password: 123456使用DS注解切换数据源Service DS(slave) public class UserServiceImpl implements UserService { // 查询方法默认使用slave数据源 DS(master) public void addUser(User user) { // 此方法使用master数据源 } }在实际项目中我发现MyBatis-Plus最适合中小型项目的快速开发但当系统复杂度增加到需要大量复杂SQL和存储过程时可能需要回归原生MyBatis的灵活性。不过对于80%的常规CRUD操作这个组合确实能提升至少50%的开发效率。
