1.首先要引入相关的依赖
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter-test</artifactId>
<version>1.3.4</version>
</dependency>
<!--在pom文件中记得添加版本号,如果不添加版本号,那么依赖导入就截止这里为止,后续的一些驱动包会无法导入-->
<!--会报错-->
<!--java.lang.IllegalStateException: Failed to load ApplicationContext-->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.6</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.40</version>
</dependency>
2.MybatisConfig
package com.alibaba.counsel.aitrain.dao.config;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import org.springframework.jdbc.datasource.DriverManagerDataSource;
import javax.sql.DataSource;
import java.sql.SQLException;
/**
* @author jx.yj
* @date 2021/7/29 10:19 上午
*/
@Configuration
@MapperScan(basePackages = {"com.alibaba.counsel.aitrain.dao.mapper"},
sqlSessionFactoryRef = "dataSessionFactory",
sqlSessionTemplateRef = "dataSessionTemplate")
public class MybatisTestConfig {
@Bean(name = "dataSource")
public DataSource dataSource() throws SQLException {
DriverManagerDataSource dataSource = new DriverManagerDataSource();
dataSource.setDriverClassName("com.mysql.jdbc.Driver");
// dataSource.setDriverClassName("com.alibaba.druid.proxy.DruidDriver");
dataSource.setUrl("jdbc:mysql://beebot-mysql:3306/counsel-aitrain");
dataSource.setUsername("alibbpoc");
dataSource.setPassword("alibbpoc");
return dataSource;
}
//配置事务管理
@Bean
@Qualifier("transactionManager")
public PlatformTransactionManager txManager(@Qualifier("dataSource") DataSource dataSource){
return new DataSourceTransactionManager(dataSource);
}
//为sqlSessionshe生产工厂实现
@Bean(name = "dataSessionFactory")
public SqlSessionFactory sessionFactory(@Qualifier("dataSource") DataSource dataSource) throws Exception {
SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
sqlSessionFactoryBean.setDataSource(dataSource);
//设置mapper接口包名
sqlSessionFactoryBean.setTypeAliasesPackage("com.alibaba.counsel.aitrain.dao.mapper");
PathMatchingResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();
//设置对应的mapper.xml的地址
sqlSessionFactoryBean.setMapperLocations(resolver.getResources("classpath*:/sqlmapper/*Mapper.xml"));
return sqlSessionFactoryBean.getObject();
}
@Bean(name = "dataSessionTemplate")
public SqlSessionTemplate sqlSessionTemplate(SqlSessionFactory dataSessionFactory) {
return new SqlSessionTemplate(dataSessionFactory);
}
}
3.BaseTest
package com.alibaba.counsel.aitrain.dao.mappertest;
import com.alibaba.counsel.aitrain.dao.config.MybatisTestConfig;
import org.junit.runner.RunWith;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringRunner;
/**
* @author jx.yj
* @date 2021/7/29 10:19 上午
*/
@RunWith(SpringRunner.class)
//Spring环境相关配置
//只依赖加在mybatis的相关配置,执行单测的效率相比直接启动springboot应用快的多
@ContextConfiguration(classes = MybatisTestConfig.class)
public class BaseTest {
}
这里注意并没有使用@SpringBootTest;
原因:通过@ContextConfiguration(classes = MybatisTestConfig.class)只依赖加在mybatis的相关配置,执行单测的效率相比直接启动springboot应用快的多
实际上@SpringBootTest下通过一个类级注解@BootstrapWith(SpringBootTestContextBootstrapper.class) 导入SpringBootTestContextBootstrapper的一些配置,而SpringBootTestContextBootstrapper中也会引入ContextConfiguration
BootstrapWith注解解释
4.问题总结
另外注意 :在设置了mybatis的mapper接口包地址和对应的xml文件的地址之后,那么xml文件以及mapper文件不能出现错误或以下的情况,否则会报错。
-
mapper.xml文件中对于mapper接口中的某一方法重复实现
-
接口包或xml文件包地址下存在无效的mapper接口文件/mapper.xml文件
-
如果出现找不到**driver.class的相关错误,则看pom中的依赖文件是否导入,( 可根据idea中右侧的Maven管理选项,根据对应的包名找到dependencies是否真的导入 )
-
如果出现一些sqlSession等的错误,可查看myBatisConfig的配置文件