Spring Boot集成MyBatis

// com.example.project.config.MyBatisConfig.java 这个类是MyBatis的配置类
@Configuration  // 不要忘记加配置注解
@EnableTransactionManagement  // 事务管理
public class MyBatisConfig implements TransactionManagementConfigurer {
    private static final Logger logger = LoggerFactory.getLogger(MyBatisConfig.class);

    @Resource
    DataSource dataSource;  // 这个数据源, Spring boot 会自动注入

    @Bean(name = "sqlSessionFactory")
    public SqlSessionFactory sqlSessionFactoryBean() {
        SqlSessionFactoryBean sqlSessionFactory = new SqlSessionFactoryBean();
        // 设置数据源
        sqlSessionFactory.setDataSource(dataSource);
        // 自动重命名
        sqlSessionFactory.setTypeAliasesPackage("com.example.project.entity");
        // 设置 typeHandler
        sqlSessionFactory.setTypeHandlersPackage("com.example.project.typeHandler");
        // 添加拦截器插件 (如果有的话, 分页插件, 分表插件等)
//        sqlSessionFactory.setPlugins(new Interceptor[]{pageHelper});
        // 设置 mapper 文件
        try {
            ResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();
            sqlSessionFactory.setMapperLocations(resolver.getResources("classpath:sqlmaps/*.xml"));
            return sqlSessionFactory.getObject();
        } catch (Exception e) {
            logger.error("初始化SqlSessionFactory失败", e);
            throw new RuntimeException(e);
        }
    }

    @Bean
    public SqlSessionTemplate sqlSessionTemplate(SqlSessionFactory sqlSessionFactory) {
        return new SqlSessionTemplate(sqlSessionFactory);
    }

    @Bean
    @Override
    public PlatformTransactionManager annotationDrivenTransactionManager() {
        return new DataSourceTransactionManager(dataSource);
    }
}

// com.example.project.config.MyBatisMapperScannerConfig.java 这个类用来设置自动扫描的路径
@Configuration
// MapperScannerConfigurer 执行的比较早, 所以要加下面这个注释, 不然其他 bean 还没初始化
@AutoConfigureAfter(MyBatisConfig.class)  // 确保在 MyBatisConfig 初始化之后初始化
public class MyBatisMapperScannerConfig {

    @Bean
    public MapperScannerConfigurer mapperScannerConfigurer() {
        MapperScannerConfigurer mapperScannerConfigurer = new MapperScannerConfigurer();
        // 设置自动扫描包, 该包下的Mapper(Dao)将会被mybatis自动注册, 不用写实现类
        mapperScannerConfigurer.setBasePackage("com.example.project.dao");
        mapperScannerConfigurer.setSqlSessionFactoryBeanName("sqlSessionFactory");
        return mapperScannerConfigurer;
    }
}

// com.example.project.entity.User.java
@Data
public class UserCreditRecord {
    private Long id;
    private String name;
    private String age;
}
// com.example.project.dao.UserDao.java
@Repository
public interface UserDao {

   @Select("select * from user where id = #{id}")
    User getById(@Param("id") Long id);
}