一、通过配置类整合Mybatis
1,导入三个依赖
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>5.2.10.RELEASE</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>2.0.2</version>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.16</version>
</dependency>
2,在resources目录下创建db.properties
driver = com.mysql.cj.jdbc.Driver
url = jdbc:mysql://localhost:3306/brrbaii?useUnicode=true&characterEncoding=UTF8&useSSL=false&serverTimezone=UTC&rewriteBatchedStatements=true
username = root
password = 123456
3,创建JdbcConfig
package com.brrbaii.config;
import com.alibaba.druid.pool.DruidDataSource;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.Bean;
import javax.sql.DataSource;
public class JdbcConfig {
@Value("${driver}")
private String driver;
@Value("${url}")
private String url;
@Value("${username}")
private String name;
@Value("${password}")
private String password;
@Bean
public DataSource dataSource(){
DruidDataSource ds = new DruidDataSource();
ds.setDriverClassName(driver);
ds.setUrl(url);
ds.setUsername(name);
ds.setPassword(password);
return ds;
}
}
4,创建MybatisConfig
package com.brrbaii.config;
import com.brrbaii.pojo.User;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.mapper.MapperScannerConfigurer;
import org.springframework.context.annotation.Bean;
import javax.sql.DataSource;
public class MybatisConfig {
@Bean
public SqlSessionFactoryBean sqlSessionFactory(DataSource dataSource){
SqlSessionFactoryBean sqfb = new SqlSessionFactoryBean();
//从容器中获取并设置数据源
sqfb.setDataSource(dataSource);
//设置别名
sqfb.setTypeAliasesPackage("com.brrbaii");
return sqfb;
}
@Bean
public MapperScannerConfigurer mapperScannerConfigurer(){
MapperScannerConfigurer msc = new MapperScannerConfigurer();
//mapper.xml的路径
msc.setBasePackage("com.brrbaii.dao");
return msc;
}
}
5,创建SpringConfig在里面导入上述两个配置
package com.brrbaii.config;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Import;
import org.springframework.context.annotation.PropertySource;
@Configuration
@Import({JdbcConfig.class, MybatisConfig.class})
@ComponentScan("com.brrbaii")
@PropertySource({"db.properties","log4j.properties"})
public class SpringConfig {
}
6,编写测试类
最终目录图
二、整合Junit
1,导入依赖
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.13</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
<version>5.2.10.RELEASE</version>
</dependency>
2,创建Test类
3,在创建的测试类上添加两个注解
@RunWith(SpringJUnit4ClassRunner.class) //ContextConfiguration指定之前Spring配置类 @ContextConfiguration(classes = SpringConfig.class)
4,进行测试
接下来我们想测谁就自动注入谁之后直接调用方法就好啦