1. Spring Boot与MyBatis整合的价值与场景在Java企业级应用开发中数据持久层框架的选择直接影响着开发效率和系统性能。Spring Boot作为当下最流行的Java应用框架其约定优于配置的理念大幅简化了项目搭建过程。而MyBatis作为半自动化的ORM框架在SQL灵活性和对象映射之间取得了完美平衡。两者的结合能够为开发者提供快速的数据库操作能力清晰的SQL管理方式灵活的动态SQL支持完善的事务管理机制我曾在多个电商和金融项目中采用这种技术组合特别是在需要复杂查询但又要保持SQL可读性的场景下MyBatis的表现尤为出色。相比JPA的完全面向对象MyBatis允许开发者直接编写和优化SQL这对性能敏感型应用至关重要。2. 环境准备与项目初始化2.1 创建Spring Boot项目使用Spring Initializrstart.spring.io或IDE内置工具创建项目时需要勾选以下依赖Spring Web如果涉及Web层MyBatis Framework对应数据库驱动如MySQL Driver对于Maven项目pom.xml中关键依赖如下dependencies dependency groupIdorg.mybatis.spring.boot/groupId artifactIdmybatis-spring-boot-starter/artifactId version3.0.3/version /dependency dependency groupIdcom.mysql/groupId artifactIdmysql-connector-j/artifactId scoperuntime/scope /dependency /dependencies注意mybatis-spring-boot-starter已经包含了MyBatis核心和Spring整合包无需单独引入2.2 数据库配置application.yml中配置数据源和MyBatis基本参数spring: datasource: url: jdbc:mysql://localhost:3306/demo?useSSLfalseserverTimezoneUTC username: root password: 123456 driver-class-name: com.mysql.cj.jdbc.Driver mybatis: mapper-locations: classpath:mapper/*.xml type-aliases-package: com.example.demo.entity配置项说明mapper-locations指定XML映射文件存放路径type-aliases-package实体类包路径可在XML中直接使用短类名3. MyBatis核心组件配置3.1 实体类与Mapper接口以用户管理为例先创建实体类public class User { private Long id; private String username; private String email; // 省略getter/setter }Mapper接口定义数据操作方法Mapper // 关键注解标记为MyBatis接口 public interface UserMapper { Select(SELECT * FROM user WHERE id #{id}) User findById(Long id); Insert(INSERT INTO user(username, email) VALUES(#{username}, #{email})) Options(useGeneratedKeys true, keyProperty id) int insert(User user); // 更多方法... }3.2 XML映射文件配置对于复杂SQL建议使用XML方式。在resources/mapper下创建UserMapper.xml?xml version1.0 encodingUTF-8? !DOCTYPE mapper PUBLIC -//mybatis.org//DTD Mapper 3.0//EN http://mybatis.org/dtd/mybatis-3-mapper.dtd mapper namespacecom.example.demo.mapper.UserMapper resultMap iduserMap typeUser id propertyid columnid/ result propertyusername columnusername/ result propertyemail columnemail/ /resultMap select idselectUsers resultMapuserMap SELECT * FROM user where if testusername ! null AND username LIKE CONCAT(%, #{username}, %) /if if testemail ! null AND email #{email} /if /where /select /mapper动态SQL技巧where标签会自动处理AND前缀if条件判断使查询更灵活LIKE查询使用CONCAT避免SQL注入4. 高级特性与最佳实践4.1 事务管理Spring Boot中只需在Service层添加Transactional注解Service public class UserService { private final UserMapper userMapper; public UserService(UserMapper userMapper) { this.userMapper userMapper; } Transactional public void createUser(User user) { userMapper.insert(user); // 其他数据库操作... } }事务传播行为REQUIRED默认当前有事务则加入没有则新建REQUIRES_NEW总是新建事务NESTED嵌套事务4.2 分页查询实现使用PageHelper插件简化分页添加依赖dependency groupIdcom.github.pagehelper/groupId artifactIdpagehelper-spring-boot-starter/artifactId version2.1.0/version /dependency在查询方法前调用public PageInfoUser getUsers(int pageNum, int pageSize) { PageHelper.startPage(pageNum, pageSize); ListUser users userMapper.selectUsers(); return new PageInfo(users); }4.3 安全注意事项针对SQL注入防护永远使用#{}而非${}热词中提到的安全漏洞XML中动态字段名处理select idselectByField resultTypeUser SELECT * FROM user ORDER BY choose when testorderBy usernameusername/when when testorderBy emailemail/when otherwiseid/otherwise /choose /select5. 常见问题排查5.1 映射文件未加载症状Invalid bound statement (not found)解决方案检查mybatis.mapper-locations路径是否正确确保XML文件在target/classes对应目录下Maven项目添加资源过滤build resources resource directorysrc/main/resources/directory filteringtrue/filtering /resource /resources /build5.2 一级缓存问题热词中提到的事务中查询不到数据问题通常是因为同一SqlSession内执行了更新操作解决方案手动清除缓存sqlSession.clearCache()使用Transactional(propagation Propagation.REQUIRES_NEW)5.3 类型处理器问题处理枚举类型时需注册类型处理器MappedTypes({UserStatus.class}) public class UserStatusHandler extends BaseTypeHandlerUserStatus { // 实现抽象方法... }在配置类中注册Configuration public class MyBatisConfig { Bean public ConfigurationCustomizer configurationCustomizer() { return configuration - { configuration.getTypeHandlerRegistry().register(UserStatusHandler.class); }; } }6. 性能优化建议批量操作使用foreach标签insert idbatchInsert INSERT INTO user(username, email) VALUES foreach collectionlist itemuser separator, (#{user.username}, #{user.email}) /foreach /insert复杂查询使用二级缓存cache evictionLRU flushInterval60000 size512 readOnlytrue/连接池配置以HikariCP为例spring: datasource: hikari: maximum-pool-size: 20 connection-timeout: 30000 idle-timeout: 600000 max-lifetime: 18000007. 测试策略7.1 单元测试配置SpringBootTest Transactional // 测试后自动回滚 class UserMapperTest { Autowired private UserMapper userMapper; Test void testInsert() { User user new User(); user.setUsername(test); assertEquals(1, userMapper.insert(user)); } }7.2 集成测试建议使用Testcontainers进行真实数据库测试针对不同数据库方言编写profile-specific配置测试SQL执行效率Autowired private SqlSessionFactory sqlSessionFactory; Test void testQueryPerformance() { try(SqlSession session sqlSessionFactory.openSession()) { UserMapper mapper session.getMapper(UserMapper.class); long start System.currentTimeMillis(); mapper.selectUsers(); System.out.println(耗时 (System.currentTimeMillis() - start)); } }8. 扩展与进阶8.1 MyBatis-Plus整合热词中提到的MyBatis Plus可以进一步简化CRUD操作添加依赖dependency groupIdcom.baomidou/groupId artifactIdmybatis-plus-boot-starter/artifactId version3.5.5/version /dependency继承BaseMapper获得通用方法public interface UserMapper extends BaseMapperUser { // 自定义方法... }8.2 多数据源配置对于需要连接多个数据库的场景主数据源配置Configuration MapperScan(basePackages com.example.mapper.primary, sqlSessionFactoryRef primarySqlSessionFactory) public class PrimaryDataSourceConfig { // 数据源、事务管理器等Bean定义 }次数据源配置Configuration MapperScan(basePackages com.example.mapper.secondary, sqlSessionFactoryRef secondarySqlSessionFactory) public class SecondaryDataSourceConfig { // 类似配置 }8.3 动态数据源路由基于AbstractRoutingDataSource实现public class DynamicDataSource extends AbstractRoutingDataSource { Override protected Object determineCurrentLookupKey() { return DatabaseContextHolder.get(); } }配合AOP在Service层切换数据源Around(annotation(dataSource)) public Object around(ProceedingJoinPoint pjp, DataSource dataSource) throws Throwable { DatabaseContextHolder.set(dataSource.value()); try { return pjp.proceed(); } finally { DatabaseContextHolder.clear(); } }9. 监控与调优9.1 SQL执行监控添加P6Spy依赖查看真实SQLdependency groupIdcom.github.gavlyukovskiy/groupId artifactIdp6spy-spring-boot-starter/artifactId version1.9.0/version /dependency配置application.ymlspring: datasource: driver-class-name: com.p6spy.engine.spy.P6SpyDriver url: jdbc:p6spy:mysql://localhost:3306/demo9.2 MyBatis指标暴露通过Spring Boot Actuator暴露MyBatis指标management: endpoints: web: exposure: include: health,info,metrics metrics: enable: mybatis: true访问/actuator/metrics/mybatis.*查看SQL执行统计10. 实际项目经验分享在最近的一个物流管理系统中我们遇到了几个典型问题及解决方案大表关联查询优化现象多表join查询超时方案改用单表查询内存关联利用MyBatis的ResultMap和Result注解批量插入性能问题现象万级数据插入耗时过长方案使用MyBatis的ExecutorType.BATCH模式Autowired private SqlSessionFactory sqlSessionFactory; public void batchInsert(ListUser users) { try(SqlSession session sqlSessionFactory.openSession(ExecutorType.BATCH)) { UserMapper mapper session.getMapper(UserMapper.class); for(User user : users) { mapper.insert(user); } session.commit(); } }动态表名处理需求按年份分表查询方案使用MyBatis的Provider注解SelectProvider(type UserSqlProvider.class, method findByYear) ListUser findByYear(Param(year) int year); public class UserSqlProvider { public String findByYear(int year) { return SELECT * FROM user_ year; } }敏感数据脱敏需求查询结果自动脱敏方案自定义TypeHandlerpublic class SensitiveTypeHandler extends BaseTypeHandlerString { Override public void setNonNullParameter(PreparedStatement ps, int i, String parameter, JdbcType jdbcType) { ps.setString(i, parameter); } Override public String getNullableResult(ResultSet rs, String columnName) { String value rs.getString(columnName); return value ! null ? mask(value) : null; } private String mask(String str) { // 实现脱敏逻辑 } }这些实战经验表明Spring Boot与MyBatis的组合既能保持开发效率又能应对各种复杂场景。关键在于深入理解两者的整合原理并灵活运用MyBatis的各种特性。