SpringBoot集成mybatis实例

2024-02-25 11:02:06 44

一、使用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")
publicclassSampleMybatisApplicationimplementsCommandLineRunner{

@Autowired
privateCityMappercityMapper;

publicstaticvoidmain(String[]args){
SpringApplication.run(SampleMybatisApplication.class,args);
}

@Override
publicvoidrun(String...args)throwsException{
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
publicclassCityMapper{

@Autowired
privateSqlSessionTemplatesqlSessionTemplate;

publicCityselectCityById(longid){
returnthis.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)})
publicclassMybatisConfig{

@Value("${name:}")
privateStringname;

@Value("${database.driverClassName}")
privateStringdriverClass;

@Value("${database.url}")
privateStringjdbcUrl;

@Value("${database.username}")
privateStringdbUser;

@Value("${database.password}")
privateStringdbPwd;

@Value("${pool.minPoolSize}")
privateintminPoolSize;

@Value("${pool.maxPoolSize}")
privateintmaxPoolSize;


@Bean
publicFiltercharacterEncodingFilter(){
CharacterEncodingFiltercharacterEncodingFilter=newCharacterEncodingFilter();
characterEncodingFilter.setEncoding("UTF-8");
characterEncodingFilter.setForceEncoding(true);
returncharacterEncodingFilter;
}

@Bean(destroyMethod="close")
publicDataSourcedataSource(){
HikariConfighikariConfig=newHikariConfig();
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("SELECT1");

HikariDataSourcedataSource=newHikariDataSource(hikariConfig);
returndataSource;
}

@Bean
publicPlatformTransactionManagertransactionManager(){
returnnewDataSourceTransactionManager(dataSource());
}

@Bean
publicSqlSessionFactorysqlSessionFactory()throwsException{
SqlSessionFactoryBeansessionFactory=newSqlSessionFactoryBean();
sessionFactory.setDataSource(dataSource());
sessionFactory.setFailFast(true);
sessionFactory.setConfigLocation(newClassPathResource("mybatis-config.xml"));
returnsessionFactory.getObject();
}
}

点评

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

2、xml方式

数据源















${database.url}
${database.username}
${database.password}

aop依赖


org.springframework.boot
spring-boot-starter-aop

mybatis-spring等依赖



org.mybatis
mybatis
3.3.0
compile


org.mybatis
mybatis-spring
1.2.2
compile



mysql
mysql-connector-java
5.1.6









com.zaxxer
HikariCP-java6
2.3.8

指定xml配置文件

@Configuration
@ComponentScan(basePackages={"com.xixicat"})
@ImportResource("classpath:applicationContext-mybatis.xml")
@EnableAutoConfiguration
publicclassAppMain{

//用于处理编码问题
@Bean
publicFiltercharacterEncodingFilter(){
CharacterEncodingFiltercharacterEncodingFilter=newCharacterEncodingFilter();
characterEncodingFilter.setEncoding("UTF-8");
characterEncodingFilter.setForceEncoding(true);
returncharacterEncodingFilter;
}

//文件下载
@Bean
publicHttpMessageConvertersrestFileDownloadSupport(){
ByteArrayHttpMessageConverterarrayHttpMessageConverter=newByteArrayHttpMessageConverter();
returnnewHttpMessageConverters(arrayHttpMessageConverter);
}

publicstaticvoidmain(String[]args)throwsException{
SpringApplication.run(AppMain.class,args);
}

}

点评

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

以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持毛票票。

声明：本文内容来源于网络，版权归原作者所有，内容由互联网用户自发贡献自行上传，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任。如果您发现有涉嫌版权的内容，欢迎发送邮件至：czq8825#qq.com（发邮件时，请将#更换为@）进行举报，并提供相关证据，一经查实，本站将立刻删除涉嫌侵权内容。

SpringBoot集成mybatis实例

热门推荐

随机推荐