Spring集成Mybatis的配置文件的全注解的

1导入maven坐标

1.1导入mybatis的坐标2个

<!--mybatis的依赖-->
<dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis</artifactId>
    <version>3.5.9</version>
</dependency>
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.028</version>
</dependency>

1.2.导入Spring的坐标3个

 <groupId>org.springframework</groupId>
    <artifactId>spring-context</artifactId>
    <version>5.3.16</version>
</dependency>
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-aop</artifactId>
    <version>5.3.16</version>
</dependency>

<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-Jdbc</artifactId>
<version>5.3.16</version>
</dependency>

1.3导入mybatis和Spring集成依赖jar包

<dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis-spring</artifactId>
    <version>2.0.7</version>
</dependency>

2.先创建properties文件

druid.driver=com.mysql.cj.jdbc.Driver
druid.url=jdbc:mysql://localhost:3306/mybaties?serverTimezone=Asia/Shanghai
druid.userName=root
druid.passWord=123456
#连接池的参数
#连接池初始化参数为5个
druid.pool.init=5
#最小连接为7个
druid.pool.minIde=7
#最大连接为10个
druid.pool.maxActive=10
#等待时间为30s
druid.pool.timeout=30000

3.创建JdbcConfig.class

@Configuration//指定该类属于配置类，等价于Sping配置文件
@PropertySource("classpath:druid.properties")//引入properties文件
public class JdbcConfig {
    @Value("${druid.driver}")
    private  String driver;
    @Value("${druid.url}")
    private  String url;
    @Value("${druid.userName}")
    private  String username;
    @Value("${druid.passWord}")
    private  String pass;
    @Value("${druid.pool.init}")//初始化个数
    private  Integer initSize;
    @Value("${druid.pool.minIde}")//最小连接个数
    private  Integer minIdle;
    @Value("${druid.pool.maxActive}")//最大连接个数
    private  Integer maxActive;
    @Value("${druid.pool.timeout}")//最大等待时间
    private  Integer maxWait;
    //德鲁伊连接池的连接
    @Bean
    public DataSource druidDataSource(){
        DruidDataSource dataSource=new DruidDataSource();
        dataSource.setDriverClassName(driver);
        dataSource.setUrl(url);
        dataSource.setUsername(username);
        dataSource.setPassword(pass);
        dataSource.setInitialSize(initSize);
        dataSource.setMinIdle(minIdle);
        dataSource.setMaxActive(maxActive);
        dataSource.setMaxWait(maxWait);
        return dataSource;
    }
}

4.创建MybatisConfig.class文件

public class MybatisConfig {
    @Bean
    public SqlSessionFactoryBean getSqlSessionFactoryBean(@Autowired DataSource dataSource){
        SqlSessionFactoryBean sqlSessionFactoryBean=new SqlSessionFactoryBean();
        sqlSessionFactoryBean.setDataSource((javax.sql.DataSource) dataSource);
        sqlSessionFactoryBean.setTypeHandlersPackage("com.po");//给实体类取笔名
        return  sqlSessionFactoryBean;
    }
    @Bean
    public MapperScannerConfigurer getMapperScannerConfigurer(){
        MapperScannerConfigurer mapperScannerConfigurer=new MapperScannerConfigurer();
        mapperScannerConfigurer.setBasePackage("com.dao");//方法扫描并路径注册在Spring容器中
        return mapperScannerConfigurer;
    }
}

5.创建Spring.class文件

@Configuration//指定该类属于配置类，等价于Sping配置文件
@ComponentScan(basePackages ="com")//指定扫描包的范围
@Import({JdbcConfig.class,MybatisConfig.class})//引入类
@PropertySource("classpath:druid.properties")//引入properties文件
class SpringConfig{

}