Spring 整合 Mybatis（注解版）

1.导入依赖

<!-- Spring -->
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-context</artifactId>
    <version>5.0.6.RELEASE</version>
</dependency>
<!-- Mybatis -->
<dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis</artifactId>
    <version>3.4.1</version>
</dependency>
 <!-- 导入连接驱动包 -->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.25</version>
</dependency>
<!-- 使用 druid 数据源 -->
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid</artifactId>
    <version>1.1.10</version>
</dependency>
<!-- 导入整合 -->
<!--Mybatis-Spring整合-->
<dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis-spring</artifactId>
    <version>1.3.0</version>
</dependency>

2.配置类的设置

简述:配置类需要完成的、有关整合的有以下几点：
	1.指定 Mapper 接口的位置
	2.注册数据源
	3.注册 SqlSessionFactory

@Configuration
@PropertySource(value={"classpath:jdbc.properties"})//读取外部 jdbc 配置文件
@MapperScan(basePackages = "com.yuke.mapper")//指定 mapper 接口位置
@ComponentScan(basePackages = "com.yuke")//组件扫描范围
public class MyConfig {

    @Value(value = "${jdbc.driver}")
    private String driverClassName;

    @Value(value = "${jdbc.username}")
    private String username;

    @Value(value = "${jdbc.password}")
    private String password;

    @Value(value = "${jdbc.url}")
    private String url;

    /*配置数据源*/
    @Bean
    public DataSource dataSource(){
    	//这里使用 druid 数据源
        DruidDataSource dataSource = new DruidDataSource();
        dataSource.setDriverClassName(this.driverClassName);
        dataSource.setUrl(this.url);
        dataSource.setUsername(this.username);
        dataSource.setPassword(this.password);
        return dataSource;
    }

    /*配置 SqlSessionFactory 工厂*/
    @Bean
    public SqlSessionFactory sqlSessionFactory() throws Exception{
        //创建 Spring 中定义好的工厂 Bean：内部存在 
        SqlSessionFactoryBean factory = new SqlSessionFactoryBean();
        //设置数据源
        factory.setDataSource(dataSource());
        //设置 Mapper 映射文件的位置:* 表示获取 mapper 文件夹下的所有 xml 配置文件
        factory.setMapperLocations(new PathMatchingResourcePatternResolver()
                .getResources("classpath:mapper/*.xml"));
        //从 SqlSessionFactoryBean 中获取 SqlSessionFactory
        return factory.getObject();
    }
}

3.测试

• 1.导入测试需要的依赖

<!-- junit4:Spring 测试模块需要它-->
<dependency>
    <groupId>junit</groupId>
    <artifactId>junit</artifactId>
    <version>4.12</version>
</dependency>
<!-- 导入 Spring 的测试依赖 -->
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-test</artifactId>
    <version>5.0.6.RELEASE</version>
</dependency>

• 2.创建测试类

@RunWith(SpringRunner.class)
@ContextConfiguration(classes = {MyConfig.class})
public class Test {

	//自动注入 Mapper,观察是否成功
    @Autowired
    private PersonMapper personMapper;

    @org.junit.Test
    public void test1() throws Exception{
        System.out.println(personMapper.getPersonById(1));
    }
}