Spring与Mybatis整合

1、加入依赖

<dependencies>
            <!-- Spring依赖1：spring-core -->
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-core</artifactId>
                <version>5.2.1.RELEASE</version>
            </dependency>

            <!-- Spring依赖2：spring-beans -->
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-beans</artifactId>
                <version>5.2.1.RELEASE</version>
            </dependency>

            <!-- Spring依赖3：spring-context -->
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-context</artifactId>
                <version>5.2.1.RELEASE</version>
            </dependency>

            <!--mybatis整合spring-->
            <!--mybatis依赖-->
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis</artifactId>
                <version>3.5.1</version>
            </dependency>

            <!--mysql依赖，不加的话会报错驱动异常-->
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>8.0.15</version>
            </dependency>

            <!--事务的依赖，如果是更新数据库表操作是涉及到它的-->
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-tx</artifactId>
                <version>4.3.2.RELEASE</version>
            </dependency>
            <!--mybatis与spring整合的依赖依赖  -->
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis-spring</artifactId>
                <version>2.0.1</version>
            </dependency>

            <!-- Spring依赖4：spring-jdbc -->
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-jdbc</artifactId>
                <version>5.2.1.RELEASE</version>
            </dependency>
    </dependencies>
    
    <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                    <include>**/*.yml</include>
                </includes>
                <filtering>false</filtering>
            </resource>
            <resource>
                <directory>src/main/resources</directory>
                <includes>
                    <include>**/*.properties</include>
                    <include>**/*.xml</include>
                    <include>**/*.yml</include>
                </includes>
                <filtering>false</filtering>
            </resource>
        </resources>

2、创建properties文件

jdbc.driver=com.mysql.cj.jdbc.Driver
//不再使用转义字符，使用'&'
jdbc.url=jdbc:mysql://localhost:3306/ssm?useSSL=false&useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=UTC
jdbc.username=root
jdbc.password=123456

3、创建主配置文件（Application.xml）：

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:mvc="http://www.springframework.org/schema/mvc"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd">

    <context:property-placeholder location="classpath:db.properties"/>
    <!--配置连接池-->
    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
        <property name="driver" ref="driver"/>
        <property name="url" value="${jdbc.url}"/>
        <property name="username" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
    </bean>
    <bean id="driver" class="com.mysql.cj.jdbc.Driver"/>
    <!--配置SqlSessionFactory-->
    <!--相当于：InputStream in=Resources.getResourceAsStream("Mybatis.xml");
              SqlSessionFactory build = new SqlSessionFactoryBuilder().build(in);
              操作-->
    <bean id="sqlSessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">
        <!--使用Durid来配置SqlSessionFactory的DataSource-->
        <property name="dataSource" ref="dataSource"></property>
        <!--设置别名-->
        <property name="typeAliasesPackage" value="com.dn.domain"></property>
        <!--加载mapper的xml映射文件 ,配置该属性后全局配置文件可以不需要再配置<mappers>-->
        <!--
            在Mybatis.xml文件中不需要加载mapper的xml映射文件（也就是到这一步就不用写Mybatis主配置文件了）
        -->
        <property name="mapperLocations" value="com/dn/Mapper/EmpMapper.xml"></property>
    </bean>

	 <!--
        实例化对应包下映射文件对应的接口
        相当于做一下操作：
        SqlSessionFactory factory = (SqlSessionFactory) context.getBean("factory");
        SqlSession sqlSession = factory.openSession();
        for(接口 ： org.example.daos)【包中的接口】{
            接口 mapper = sqlSession.getMapper(接口.class);
            SpringMap.put(接口名（首字母小写）,mapper);
        }

        List<Student> students = mapper.selectStudentAll();
        students.forEach(stu-> System.out.println(stu));
    -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactoryBean"></property>
        <property name="basePackage" value="com.dn.Mapper"></property>
    </bean>

</beans>

4、测试