Mybatis整合Spring

所需导入的jar包

配置mybatis核心配置文件

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

    <properties resource="db.properties"/>
    <settings>
        <setting name="cacheEnabled" value="true"/>
    </settings>
    <typeAliases>
        <package name="cn.sky"/>
    </typeAliases>
    <!-- 配置mybatis的环境信息 -->


   <!-- <environments default="development">
        <environment id="development">
            &lt;!&ndash; 配置JDBC事务控制，由mybatis进行管理 &ndash;&gt;
            <transactionManager type="JDBC"></transactionManager>
            &lt;!&ndash; 配置数据源，采用dbcp连接池 &ndash;&gt;
            <dataSource type="POOLED">
                <property name="driver" value="${driverClass}"/>
                <property name="url" value="${url}"/>
                <property name="username" value="${username}"/>
                <property name="password" value="${password}"/>
            </dataSource>
        </environment>
    </environments>-->
    <!--加载映射文件-->
    <mappers>
        <mapper resource="cn/sky/backoffice/mapper/ItemsMapper.xml"/>
        <mapper resource="cn/sky/backoffice/mapper/OrdersMapper.xml"/>
        <mapper resource="cn/sky/backoffice/mapper/OrderdetailMapper.xml"/>
        <mapper resource="cn/sky/backoffice/mapper/UserMapper.xml"/>
    </mappers>

</configuration>

配置Spring的数据源

<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:mvc="http://www.springframework.org/schema/mvc"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
		http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
		http://www.springframework.org/schema/mvc
		http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd
		http://www.springframework.org/schema/context
		http://www.springframework.org/schema/context/spring-context-3.2.xsd
		http://www.springframework.org/schema/aop
		http://www.springframework.org/schema/aop/spring-aop-3.2.xsd
		http://www.springframework.org/schema/tx
		http://www.springframework.org/schema/tx/spring-tx-3.2.xsd">


    <!-- 1.配置数据库，dbcp数据库连接池 -->
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
        <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
        <property name="url" value="jdbc:mysql://localhost:3306/mybatisday1?       useUnicode=true&amp;characterEncoding=utf8"/>
        <property name="username" value="root"/>
        <property name="password" value="123456"/>
			<!-- 最大连接  -->
        <property name="maxActive" value="10"/>
        <!--最大空闲数  -->
        <property name="maxIdle" value="5"/>
    </bean>
    <!-- 3.配置SqlSessionFactory -->
    <bean id="SessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="configLocation" value="classpath:SqlMapConfig.xml"></property>
        <property name="dataSource" ref="dataSource"></property>
    </bean>
 
    <!-- 用MapperScanerConfigurer批量扫描代理对象 -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="cn.sky.backoffice.mapper"/>
        <property name="sqlSessionFactoryBeanName" value="SessionFactory"/>
    </bean>

</beans>

mapper接口整合dao（略）
测试

@Test
    public void test02(){
        ApplicationContext context=new ClassPathXmlApplicationContext("beans.xml");
        UserMapper mapper= (UserMapper) context.getBean("userMapper");
        User user = mapper.selectByPrimaryKey(1);
        System.out.println(user);
    }