Mybatis 创建于配置

 1.配置所属依赖

         
        
            org.mybatis
            mybatis
            3.5.6
        

        
        
            org.mybatis
            mybatis-spring
            2.0.6
        

        
        
            org.springframework
            spring-context
            5.3.14
        

        
        
            org.springframework
            spring-jdbc
            5.3.14
        

        
        
            mysql
            mysql-connector-java
            8.0.21
        

        
        
            org.apache.commons
            commons-dbcp2
            2.8.0
        

        
        
            org.junit.jupiter
            junit-jupiter-api
            5.7.0
            test
        
		
	
	
		org.springframework
		spring-test
		5.3.14
	

 2. 创建数据库连接文件 

        1.在 resource 下创建文件 后缀名:     .properties

 

datasource.url=jdbc:mysql://localhost:3306/mall_ams?useUnicode=true&ch
aracterEncoding=UTF-8&serverTimezone=Asia/Shanghai
datasource.driver=com.mysql.cj.jdbc.Driver
datasource.username=root
datasource.password=root

3.  创建xml 文件

          1.在文件 resources下 创建文件夹mapper  

          2. 创建一个人后缀为 xml 的文件

 4.配置类 SpringConfig

目录

 1.配置所属依赖

 2. 创建数据库连接文件 

3.  创建xml 文件

---

@Configuration
@PropertySource("classpath:datasource.properties")
@MapperScan("cn.tedu.mapping")
public class SpringConfig {

    @Bean
    public DataSource dataSource(Environment env){
        BasicDataSource dataSource = new BasicDataSource();
        dataSource.setUrl(env.getProperty("datasource.url"));
        dataSource.setDriverClassName(env.getProperty("datasource.driver"));
        dataSource.setUsername(env.getProperty("datasource.username"));
        dataSource.setPassword(env.getProperty("datasource.password"));
        return dataSource;


    }

    //规范
    @Bean
    public SqlSessionFactoryBean sqlSessionFactoryBean(DataSource dataSource,
               @Value("${mybatis.mapper-locations}") Resource mapperLocations) {
        SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
        sqlSessionFactoryBean.setDataSource(dataSource);
        sqlSessionFactoryBean.setMapperLocations(mapperLocations);
        return sqlSessionFactoryBean;
    }


}

                                                        测试依赖配置 Druid

    com.alibaba
    druid
    1.1.22