Mybatis 创建于配置

 1.配置所属依赖

         <!-- Mybatis 的依赖 -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.6</version>
        </dependency>

        <!-- Mybatis 整合Spring 的依赖项 -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>2.0.6</version>
        </dependency>

        <!-- Spring 的依赖(context) -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>5.3.14</version>
        </dependency>

        <!-- Spring-jdbc 的依赖 -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>5.3.14</version>
        </dependency>

        <!--  mysql 依赖 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.21</version>
        </dependency>

        <!-- 数据库连接池 -->
        <dependency>
            <groupId>org.apache.commons</groupId>
            <artifactId>commons-dbcp2</artifactId>
            <version>2.8.0</version>
        </dependency>

        <!-- junit 测试的依赖 -->
        <dependency>
            <groupId>org.junit.jupiter</groupId>
            <artifactId>junit-jupiter-api</artifactId>
            <version>5.7.0</version>
            <scope>test</scope>
        </dependency>
		
	<!-- test 依赖 -->
	<dependency>
		<groupId>org.springframework</groupId>
		<artifactId>spring-test</artifactId>
		<version>5.3.14</version>
	</dependency>

 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 的文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
  PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<!-- 此文件必须使用 mapper 作为根节点 -->
<!-- namespace 属性: 必须的,用于指定此 xml 文件对应的接口 ,取值为接口的全限定名 -->

<mapper namespace="cn.tedu.mapping.UserMapping">
<!-- 里面用来写sql 语句 -->

</mapper>

 4.配置类 SpringConfig

目录

 1.配置所属依赖

 2. 创建数据库连接文件 

3.  创建xml 文件

---

/**
 * 配置类  所有的 Bean 都是让 sql 创建对象;   -- 以及路劲
 */
@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

<!-- https://mvnrepository.com/artifact/com.alibaba/druid -->
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid</artifactId>
    <version>1.1.22</version>
</dependency>