介绍
使用SpringBoot如何实现集成mybatis ?很多新手对此不是很清楚,为了帮助大家解决这个难题,下面小编将为大家详细讲解,有这方面需求的人可以来学习下,希望你能有所收获。
一、使用mybatis-spring-boot-starter
1,添加依赖
& lt; dependency> & lt; groupId> org.mybatis.spring.boot & lt; artifactId> mybatis-spring-boot-starter & lt; version> 1.0.0 & lt;/dependency>
2,启动时导入指定的sql(<代码> application.properties> 代码)
spring.datasource.schema=进口。sql
3,注解形式
@SpringBootApplication @MapperScan (“sample.mybatis.mapper") 公共类SampleMybatisApplication实现CommandLineRunner { @ autowired 私人CityMapper CityMapper; 公共静态void main (String [] args) { SpringApplication.run (SampleMybatisApplication.class, args); } @Override 公共空间运行(字符串…args)抛出异常{ System.out.println (this.cityMapper.findByState (“CA")); } }
4, xml方式
mybatis-config。xml
& lt;及# 63;xml version=?.0”;编码=癠TF-8",# 63;比; & lt; !DOCTYPE配置 公众“-//mybatis.org//DTD配置3.0//EN" “http://mybatis.org/dtd/mybatis-3-config.dtd"比; & lt; configuration> & lt; typeAliases> & lt;包名称=皊ample.mybatis.domain"/比; & lt;/typeAliases> & lt; mappers> & lt;资源映射器=把?mybatis/映射器/CityMapper.xml"/比; & lt;/mappers> & lt;/configuration>
应用程序。属性
spring.datasource.schema=import.sql mybatis.config=mybatis-config。xml
mapper
@ component 公开课CityMapper { @ autowired 私人SqlSessionTemplate SqlSessionTemplate; 公共城市selectCityById (id) { 返回this.sqlSessionTemplate.selectOne (“selectCityById"、身份证); } }
<强>二,手工集成强>
1,注释方式
@ configuration @MapperScan (“com.xixicat.modules.dao") @PropertySources ({@PropertySource (value=https://www.yisu.com/zixun/袄嗦肪?application.properties ignoreResourceNotFound=true), @PropertySource(值=" file:/应用程序。属性”,ignoreResourceNotFound=true)}) 公开课MybatisConfig { @ value(" ${名称:}") 私人字符串名称; @ value (" $ {database.driverClassName} ") 私人字符串driverClass; @ value (" $ {database.url} ") 私人字符串jdbcUrl; @ value (" $ {database.username} ") 私人字符串dbus; @ value (" $ {database.password} ") 私人字符串dbPwd; @ value (" $ {pool.minPoolSize} ") 私人int minPoolSize; @ value (" $ {pool.maxPoolSize} ") 私人int maxPoolSize; @ bean 公共过滤器characterEncodingFilter () { CharacterEncodingFilter CharacterEncodingFilter=new CharacterEncodingFilter (); characterEncodingFilter.setEncoding (“utf - 8”); characterEncodingFilter.setForceEncoding(真正的); 返回characterEncodingFilter; } @ bean (destroyMethod=肮乇铡? 公共数据源的数据源(){ HikariConfig HikariConfig=new HikariConfig (); hikariConfig.setDriverClassName (driverClass); hikariConfig.setJdbcUrl (jdbcUrl); hikariConfig.setUsername (dbus); hikariConfig.setPassword (dbPwd); hikariConfig.setPoolName (“springHikariCP”); hikariConfig.setAutoCommit(假); hikariConfig。addDataSourceProperty (“cachePrepStmts”,“真正的”); hikariConfig。addDataSourceProperty (“prepStmtCacheSize”、“250”); hikariConfig。addDataSourceProperty (“prepStmtCacheSqlLimit”、“2048”); hikariConfig。addDataSourceProperty (“useServerPrepStmts”,“真正的”); hikariConfig.setMinimumIdle (minPoolSize); hikariConfig.setMaximumPoolSize (maxPoolSize); hikariConfig。setConnectionInitSql(“选择1”); HikariDataSource数据源=new HikariDataSource (hikariConfig); 返回数据源; } @ bean 公共PlatformTransactionManager transactionManager () { 返回新DataSourceTransactionManager(数据源()); } @ bean 公共SqlSessionFactory SqlSessionFactory()抛出异常{ SqlSessionFactoryBean sessionFactory=new SqlSessionFactoryBean (); sessionFactory.setDataSource(数据源()); sessionFactory.setFailFast(真正的); sessionFactory。setConfigLocation(新ClassPathResource (“mybatis-config.xml”); 返回sessionFactory.getObject (); } }使用SpringBoot如何实现集成mybatis