https://github.com/spring-projects/spring-boot/issues/5400

一、使用mybatis-spring-boot-starter
1、添加依赖

org.mybatis.spring.boot
mybatis-spring-boot-starter
1.0.0

2、启动时导入指定的sql(application.properties)
spring.datasource.schema=import.sql
3、annotation形式
@springbootapplication
@mapperscan("sample.mybatis.mapper")
public class SampleMybatisApplication implements CommandLineRunner {

@Autowiredprivate CityMapper cityMapper;public static void main(String[] args) {    SpringApplication.run(SampleMybatisApplication.class, args);}@Overridepublic void run(String... args) throws Exception {    System.out.println(this.cityMapper.findByState("CA"));}

}
4、xml方式
mybatis-config.xml

application.properties

spring.datasource.schema=import.sql
mybatis.config=mybatis-config.xml
mapper

@component
public class CityMapper {

@Autowiredprivate SqlSessionTemplate sqlSessionTemplate;public City selectCityById(long id) {    return this.sqlSessionTemplate.selectOne("selectCityById", id);}

}
二、手工集成
1、annotation方式
@configuration
@mapperscan("com.xixicat.modules.dao")
@propertysources({ @propertysource(value = "http://www.mamicode.com/classpath:application.properties", ignoreResourceNotFound = true), @propertysource(value = "http://www.mamicode.com/file:./application.properties", ignoreResourceNotFound = true) })
public class MybatisConfig {

@Value("${name:}")private String name;@Value("${database.driverClassName}")private String driverClass;@Value("${database.url}")private String jdbcUrl;@Value("${database.username}")private String dbUser;@Value("${database.password}")private String dbPwd;@Value("${pool.minPoolSize}")private int minPoolSize;@Value("${pool.maxPoolSize}")private int maxPoolSize;@Beanpublic Filter characterEncodingFilter() {    CharacterEncodingFilter characterEncodingFilter = new CharacterEncodingFilter();    characterEncodingFilter.setEncoding("UTF-8");    characterEncodingFilter.setForceEncoding(true);    return characterEncodingFilter;}@Bean(destroyMethod = "close")public DataSource dataSource(){    HikariConfig hikariConfig = new HikariConfig();    hikariConfig.setDriverClassName(driverClass);    hikariConfig.setJdbcUrl(jdbcUrl);    hikariConfig.setUsername(dbUser);    hikariConfig.setPassword(dbPwd);    hikariConfig.setPoolName("springHikariCP");    hikariConfig.setAutoCommit(false);    hikariConfig.addDataSourceProperty("cachePrepStmts", "true");    hikariConfig.addDataSourceProperty("prepStmtCacheSize", "250");    hikariConfig.addDataSourceProperty("prepStmtCacheSqlLimit", "2048");    hikariConfig.addDataSourceProperty("useServerPrepStmts", "true");    hikariConfig.setMinimumIdle(minPoolSize);    hikariConfig.setMaximumPoolSize(maxPoolSize);    hikariConfig.setConnectionInitSql("SELECT 1");    HikariDataSource dataSource = new HikariDataSource(hikariConfig);    return dataSource;}@Beanpublic PlatformTransactionManager transactionManager() {    return new DataSourceTransactionManager(dataSource());}@Beanpublic SqlSessionFactory sqlSessionFactory() throws Exception {    SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean();    sessionFactory.setDataSource(dataSource());    sessionFactory.setFailFast(true);    sessionFactory.setConfigLocation(new ClassPathResource("mybatis-config.xml"));    return sessionFactory.getObject();}

}
点评

这种方式有点别扭，而且配置不了拦截式事务拦截，只能采用注解声明，有些冗余

2、xml方式
数据源

<context:property-placeholder ignore-unresolvable="true" /><bean id="hikariConfig" class="com.zaxxer.hikari.HikariConfig">    <property name="poolName" value="http://www.mamicode.com/springHikariCP" />    <property name="connectionTestQuery" value="http://www.mamicode.com/SELECT 1" />    <property name="dataSourceClassName" value="http://www.mamicode.com/${database.dataSourceClassName}" />    <property name="maximumPoolSize" value="http://www.mamicode.com/${pool.maxPoolSize}" />    <property name="idleTimeout" value="http://www.mamicode.com/${pool.idleTimeout}" />    <property name="dataSourceProperties">        <props>            <prop key="url">${database.url}</prop>            <prop key="user">${database.username}</prop>            <prop key="password">${database.password}</prop>        </props>    </property></bean><!-- HikariCP configuration --><bean id="dataSource" class="com.zaxxer.hikari.HikariDataSource" destroy-method="close">    <constructor-arg ref="hikariConfig" /></bean><bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">    <property name="dataSource" ref="dataSource"/>    <!-- 配置mybatis配置文件的位置 -->    <property name="configLocation" value="http://www.mamicode.com/classpath:mybatis-config.xml"/>    <property name="typeAliasesPackage" value="http://www.mamicode.com/com.xixicat.domain"/>    <!-- 配置扫描Mapper XML的位置 -->    <property name="mapperLocations" value="http://www.mamicode.com/classpath:com/xixicat/modules/dao/*.xml"/></bean><!-- 配置扫描Mapper接口的包路径 --><bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">    <property name="sqlSessionFactoryBeanName" value="http://www.mamicode.com/sqlSessionFactory"/>    <property name="basePackage" value="http://www.mamicode.com/com.xixicat.repository.mapper"/></bean><bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">    <constructor-arg ref="sqlSessionFactory"/></bean><bean id="transactionManager"      class="org.springframework.jdbc.datasource.DataSourceTransactionManager"      p:dataSource-ref="dataSource"/><aop:aspectj-autoproxy expose-proxy="true" proxy-target-class="true" /><tx:advice id="txAdvice" transaction-manager="transactionManager" >    <tx:attributes>        <tx:method name="start*" propagation="REQUIRED"/>        <tx:method name="submit*" propagation="REQUIRED"/>        <tx:method name="clear*" propagation="REQUIRED"/>        <tx:method name="create*" propagation="REQUIRED"/>        <tx:method name="activate*" propagation="REQUIRED"/>        <tx:method name="save*" propagation="REQUIRED"/>        <tx:method name="insert*" propagation="REQUIRED"/>        <tx:method name="add*" propagation="REQUIRED"/>        <tx:method name="update*" propagation="REQUIRED"/>        <tx:method name="delete*" propagation="REQUIRED"/>        <tx:method name="remove*" propagation="REQUIRED"/>        <tx:method name="execute*" propagation="REQUIRED"/>        <tx:method name="del*" propagation="REQUIRED"/>        <tx:method name="*" read-only="true"/>    </tx:attributes></tx:advice><aop:config proxy-target-class="true" expose-proxy="true">    <aop:pointcut id="pt" expression="execution(public * com.xixicat.service.*.*(..))" />    <aop:advisor order="200" pointcut-ref="pt" advice-ref="txAdvice"/></aop:config>

aop依赖

    <dependency>        <groupId>org.springframework.boot</groupId>        <artifactId>spring-boot-starter-aop</artifactId>    </dependency>

mybatis-spring等依赖

    <dependency>        <groupId>org.mybatis</groupId>        <artifactId>mybatis</artifactId>        <version>3.3.0</version>        <scope>compile</scope>    </dependency>    <dependency>        <groupId>org.mybatis</groupId>        <artifactId>mybatis-spring</artifactId>        <version>1.2.2</version>        <scope>compile</scope>    </dependency>    <dependency>        <groupId>mysql</groupId>        <artifactId>mysql-connector-java</artifactId>        <version>5.1.6</version>    </dependency>    <!--<dependency>-->        <!--<groupId>org.hsqldb</groupId>-->        <!--<artifactId>hsqldb</artifactId>-->        <!--<scope>runtime</scope>-->    <!--</dependency>-->    <dependency>        <groupId>com.zaxxer</groupId>        <artifactId>HikariCP-java6</artifactId>        <version>2.3.8</version>    </dependency>

指定xml配置文件

@configuration
@componentscan( basePackages = {"com.xixicat"} )
@importresource("classpath:applicationContext-mybatis.xml")
@enableautoconfiguration
public class AppMain {

// 用于处理编码问题@Beanpublic Filter characterEncodingFilter() {    CharacterEncodingFilter characterEncodingFilter = new CharacterEncodingFilter();    characterEncodingFilter.setEncoding("UTF-8");    characterEncodingFilter.setForceEncoding(true);    return characterEncodingFilter;}//文件下载@Beanpublic HttpMessageConverters restFileDownloadSupport() {    ByteArrayHttpMessageConverter arrayHttpMessageConverter = new ByteArrayHttpMessageConverter();    return new HttpMessageConverters(arrayHttpMessageConverter);}public static void main(String[] args) throws Exception {    SpringApplication.run(AppMain.class, args);}

}
点评

跟传统的方式集成最为直接，而且事务配置也比较容易上手

spring boot integrated mybatis three ways！--转