spring整合mybatis

pom.xml配置文件

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>com.icis</groupId>
    <artifactId>mybatis-module4</artifactId>
    <version>1.0-SNAPSHO</version>
    <!--依赖包-->
    <dependencies>
        <!--导入spring相关依赖包-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>5.1.3.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-aspects</artifactId>
            <version>5.1.3.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>5.1.3.RELEASE</version>
        </dependency>
        <!--mybaits官方提供的整合包
        说明: 因为Spring框架比较流行 所以 如果别的框架想被Spring整合
        需要框架制作公司提供为Spring 整合的依赖包
        报的名字一般情况是:
        1. 如果是Spring自己的 Spring-context Spring-aspects
        2. 如果是别人提供  mybaits-spring..
        -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>1.3.2</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.0.9</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.34</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.6</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-test</artifactId>
            <version>5.1.3.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.13.2</version>
        </dependency>
        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.17</version>
        </dependency>
    </dependencies>
    <!--编译插件-->
    <build>
        <plugins>
            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-compiler-plugin</artifactId>
                <version>2.3.2</version>
                <configuration>
                    <source>1.8</source>
                    <target>1.8</target>
                    <encoding>UTF-8</encoding>
                </configuration>
            </plugin>
        </plugins>
    </build>

    
</project>

spring-mybatis.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:aop="http://www.springframework.org/schema/aop"
       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/aop
http://www.springframework.org/schema/aop/spring-aop.xsd">
    <!--
    思路：将mybatis框架的对象，交给spring管理。
1.把SqlSessionFactory对象，交给spring管理  SqlSessionFactoryBean 放入到Spring容器中
2.把SqlSession对象，交给spring管理
3.在原始的dao开发方法中，将dao实现类对象交给spring管理
4.在mapper代理开发方法中，把mapper代理对象交给spring管理
5.把数据源对象，交给spring管理
    -->
     <!--spring整合mybaits 开始-->
     <!--数据源  不再用mybait内置的-->
     <context:property-placeholder location="classpath:db.properties"/>
     <bean id="druidDataSource" class="com.alibaba.druid.pool.DruidDataSource">
       <!--属性赋值-->
         <property name="driverClassName" value="${db.db.driverClassName}"/>
         <property name="url" value="${db.url}"/>
         <property name="username" value="${db.username}"/>
         <property name="password" value="${db.password}"/>
     </bean>
    <!--
    sqlSessionFactory  工厂 生产SqlSession 和数据库交互 这个工厂需要给它配置一个数据源
    -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <!--配置数据源-->
        <property name="dataSource" ref="druidDataSource"/>
        <!--配置别名包扫描-->
        <property name="typeAliasesPackage" value="com.icis.pojo"/>

    </bean>
    <!--配置一个bean  MapperScannerConfigurer  配置mapper接口包扫描-->
    <bean id="mapperScannner" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <!--basePackage 配置mapper扫描的接口包-->
        <property name="basePackage" value="com.icis.mapper"/>
    </bean>

</beans>

db.properties配置文件

driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql:///db100
username=root
password=12345678
initialSize=5
maxActive=10
maxWait=3000