spring boot integrated mybatis three ways！--转

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 {

@Autowired private CityMapper cityMapper;public static void main(String[] args) {SpringApplication.run(SampleMybatisApplication.class, args); }@Override public 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 {

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

}
二、手工集成
1、annotation方式
@configuration
@mapperscan("com.xixicat.modules.dao")
@propertysources({ @propertysource(value = "classpath:application.properties", ignoreResourceNotFound = true), @propertysource(value = "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;@Bean public 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; }@Bean public PlatformTransactionManager transactionManager() {return new DataSourceTransactionManager(dataSource()); }@Bean public 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="springHikariCP" /><property name="connectionTestQuery" value="SELECT 1" /><property name="dataSourceClassName" value="${database.dataSourceClassName}" /><property name="maximumPoolSize" value="${pool.maxPoolSize}" /><property name="idleTimeout" value="${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="classpath:mybatis-config.xml"/><property name="typeAliasesPackage" value="com.xixicat.domain"/><!-- 配置扫描Mapper XML的位置 --><property name="mapperLocations" value="classpath:com/xixicat/modules/dao/*.xml"/></bean><!-- 配置扫描Mapper接口的包路径 --> <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"><property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/><property name="basePackage" value="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 {

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

}
点评

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

转载于:https://www.cnblogs.com/davidwang456/p/6973126.html

《新程序员》：云原生和全面数字化实践50位技术专家共同创作，文字、视频、音频交互阅读

总结

以上是生活随笔为你收集整理的spring boot integrated mybatis three ways！--转的全部内容，希望文章能够帮你解决所遇到的问题。

如果觉得生活随笔网站内容还不错，欢迎将生活随笔推荐给好友。