（7）MyBatis之与Spring整合

1.引言

在本篇博客中主要介绍：MyBatis和Spring的整合

Spring和MyBatis的整合主要注意一下几点：

• MyBatis的配置在Spring配置文件中
• MyBatis的实现类有Spring动态代理生成
• MyBatis的事务要交给Spring来管理

2.MyBatis之与Spring整合

2.1 创建我们的数据库

DROP DATABASE IF EXISTS school;CREATE DATABASE IF NOT EXISTS school;USE school;CREATE TABLE `student`(`sid` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY ,`sname` VARCHAR(32) ,`hobit` VARCHAR(20));INSERT INTO `student` (`sid`,`sname`,`hobit`)VALUES(1,"aaa","喜欢玩游戏");INSERT INTO `student` (`sid`,`sname`,`hobit`)VALUES(2,"bbb","喜欢学习");INSERT INTO `student` (`sid`,`sname`,`hobit`)VALUES(3,"ccc","喜欢打篮球");

2.2 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>mybatis_spring</groupId>    <artifactId>mybatis_spring</artifactId>    <version>1.0-SNAPSHOT</version>    <packaging>war</packaging>    <properties>        <!-- spring版本号 -->        <spring.version>4.0.2.RELEASE</spring.version>        <!-- mybatis版本号 -->        <mybatis.version>3.2.6</mybatis.version>        <!-- log4j日志文件管理包版本 -->        <slf4j.version>1.7.7</slf4j.version>        <log4j.version>1.2.17</log4j.version>    </properties>    <dependencies>        <dependency>            <groupId>junit</groupId>            <artifactId>junit</artifactId>            <version>4.11</version>            <!-- 表示开发的时候引入，发布的时候不会加载此包 -->            <scope>test</scope>        </dependency>        <!-- spring核心包 -->        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-core</artifactId>            <version>${spring.version}</version>        </dependency>        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-web</artifactId>            <version>${spring.version}</version>        </dependency>        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-oxm</artifactId>            <version>${spring.version}</version>        </dependency>        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-tx</artifactId>            <version>${spring.version}</version>        </dependency>        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-jdbc</artifactId>            <version>${spring.version}</version>        </dependency>        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-webmvc</artifactId>            <version>${spring.version}</version>        </dependency>        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-aop</artifactId>            <version>${spring.version}</version>        </dependency>        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-context-support</artifactId>            <version>${spring.version}</version>        </dependency>        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-test</artifactId>            <version>${spring.version}</version>        </dependency>        <!-- mybatis核心包 -->        <dependency>            <groupId>org.mybatis</groupId>            <artifactId>mybatis</artifactId>            <version>${mybatis.version}</version>        </dependency>        <!-- mybatis/spring包 -->        <dependency>            <groupId>org.mybatis</groupId>            <artifactId>mybatis-spring</artifactId>            <version>1.2.2</version>        </dependency>        <!-- 导入Mysql数据库链接jar包 -->        <dependency>            <groupId>mysql</groupId>            <artifactId>mysql-connector-java</artifactId>            <version>5.1.30</version>        </dependency>        <!-- 导入dbcp的jar包，用来在applicationContext.xml中配置数据库 -->        <dependency>            <groupId>commons-dbcp</groupId>            <artifactId>commons-dbcp</artifactId>            <version>1.2.2</version>        </dependency>        <!-- JSTL标签类 -->        <dependency>            <groupId>jstl</groupId>            <artifactId>jstl</artifactId>            <version>1.2</version>        </dependency>        <!-- 日志文件管理包 -->        <!-- log start -->        <dependency>            <groupId>log4j</groupId>            <artifactId>log4j</artifactId>            <version>${log4j.version}</version>        </dependency>        <!-- 格式化对象，方便输出日志 -->        <dependency>            <groupId>com.alibaba</groupId>            <artifactId>fastjson</artifactId>            <version>1.1.41</version>        </dependency>        <dependency>            <groupId>org.slf4j</groupId>            <artifactId>slf4j-api</artifactId>            <version>${slf4j.version}</version>        </dependency>        <dependency>            <groupId>org.slf4j</groupId>            <artifactId>slf4j-log4j12</artifactId>            <version>${slf4j.version}</version>        </dependency>        <!-- 映入JSON -->        <dependency>            <groupId>org.codehaus.jackson</groupId>            <artifactId>jackson-mapper-asl</artifactId>            <version>1.9.13</version>        </dependency>    </dependencies>    <build>        <finalName>mybatis_spring</finalName>    </build></project>

2.3 创建持久化类（Student）

package com.skd.domain;public class Student {    private Integer sid;    private String sname;    private String hobit;    public Integer getSid() {        return sid;    }    public void setSid(Integer sid) {        this.sid = sid;    }    public String getSname() {        return sname;    }    public void setSname(String sname) {        this.sname = sname == null ? null : sname.trim();    }    public String getHobit() {        return hobit;    }    public void setHobit(String hobit) {        this.hobit = hobit == null ? null : hobit.trim();    }}

2.4 创建映射文件（StudentMapper.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="com.skd.mapper.StudentMapper" >  <resultMap id="BaseResultMap" type="com.skd.domain.Student" >    <id column="sid" property="sid" jdbcType="INTEGER" />    <result column="sname" property="sname" jdbcType="VARCHAR" />    <result column="hobit" property="hobit" jdbcType="VARCHAR" />  </resultMap></mapper>

2.5 创建BaseMapper

package com.skd.mapper;public interface BaseMapper<T> {    //添加单个对象    public int insert(T entity);    //修改单个对象    public int update(T entity);    //删除单个对象    public int delete(T entity);    //通过主键（数组）批量删除数据    public int deleteList(String [] pks);    //根据id查询单个对象    public T select(Integer id);}

2.6 创建StudentMapper

package com.skd.mapper;import com.skd.domain.Student;public interface StudentMapper extends BaseMapper<Student> {}

2.6.1 向映射文件添加SQL语句

<select id="select" parameterType="int" resultMap="BaseResultMap">    select * from student where sid=#{id}</select>

2.7 创建Spring-MyBatis配置文件

2.7.1 JDBC配置

driver=com.mysql.jdbc.Driverurl=jdbc:mysql://localhost:3306/schoolusername=rootpassword=root

2.7.2 Spring-MyBatis配置

<?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:p="http://www.springframework.org/schema/p"       xmlns:context="http://www.springframework.org/schema/context"       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.1.xsd                        http://www.springframework.org/schema/context                        http://www.springframework.org/schema/context/spring-context-3.1.xsd                        http://www.springframework.org/schema/tx                        http://www.springframework.org/schema/tx/spring-tx-2.0.xsd">    <!-- 引入配置文件 -->    <bean id="propertyConfigurer"          class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">        <property name="location" value="classpath:jdbc.properties" />    </bean>    <!--MySQL数据库的链接信息-->    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"          destroy-method="close">        <property name="driverClassName" value="${driver}" />        <property name="url" value="${url}" />        <property name="username" value="${username}" />        <property name="password" value="${password}" />    </bean>    <!--让Spring创建sqlSessionFactory对象-->    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">        <property name="dataSource" ref="dataSource" />        <property name="mapperLocations" value="classpath:com/skd/mapper/*.xml"></property>    </bean>    <!--让Spring为Mapper接口生成动态代理-->    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">        <property name="basePackage" value="com.skd.mapper" />        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>    </bean>    <!--让Spring管理事务-->    <bean id="transactionManager"          class="org.springframework.jdbc.datasource.DataSourceTransactionManager">        <property name="dataSource" ref="dataSource" />    </bean>    <!--配置扫描式事务-->    <tx:annotation-driven transaction-manager="transactionManager" proxy-target-class="true" /></beans>

2.8 测试Mapper测试是否成功

2.8.1 测试代码

import com.skd.mapper.StudentMapper;import org.junit.Test;import org.junit.runner.RunWith;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.test.context.ContextConfiguration;import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;@RunWith(SpringJUnit4ClassRunner.class)@ContextConfiguration(locations={"classpath:spring-mybatis.xml"})public class TestMapper {    @Autowired    private StudentMapper studentMapper;    @Test    public void test(){        studentMapper.select(1);    }}

2.8.2 测试成功

2.9 创建BaseService（如果测试成功）

package com.skd.service;public interface BaseService<T> {    //添加单个对象    public int insert (T entity) throws Exception;    //修改单个对象    public int update(T entity) throws Exception;    //删除单个对象    public int delete(T entity) throws Exception;    //通过主键（数组）批量删除数据    public int deleteList(String [] pks) throws Exception;    //查询单个对象    public T select(Integer id);}

2.10 创建BaseServiceImpl

package com.skd.service.impl;import com.skd.mapper.BaseMapper;import com.skd.service.BaseService;import org.springframework.transaction.annotation.Transactional;public abstract class BaseServiceImpl<T> implements BaseService<T>{    public abstract BaseMapper<T> getMapper();    @Transactional(readOnly=false)    public int insert(T entity) throws Exception {        return getMapper().insert(entity);    }    @Transactional(readOnly=false)    public int update(T entity) throws Exception {        return getMapper().update(entity);    }    @Transactional(readOnly=false)    public int delete(T entity) throws Exception {        return getMapper().delete(entity);    }    @Transactional(readOnly=false)    public int deleteList(String[] pks) throws Exception {        return getMapper().deleteList(pks);    }    public T select(Integer id) {        return getMapper().select(id);    }}

2.10 创建StudentService

package com.skd.service;import com.skd.domain.Student;public interface StudentService extends BaseService<Student>{}

2.11 创建StudentServiceImpl

package com.skd.service.impl;import com.skd.domain.Student;import com.skd.mapper.BaseMapper;import com.skd.mapper.StudentMapper;import com.skd.service.StudentService;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;@Servicepublic class StudentServiceImpl extends BaseServiceImpl<Student> implements StudentService{    @Autowired    private StudentMapper studentMapper;    @Override    public BaseMapper<Student> getMapper() {        return studentMapper;    }}

2.12 创建Spring.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:p="http://www.springframework.org/schema/p"       xmlns:context="http://www.springframework.org/schema/context"       xsi:schemaLocation="http://www.springframework.org/schema/beans                        http://www.springframework.org/schema/beans/spring-beans-3.1.xsd                        http://www.springframework.org/schema/context                        http://www.springframework.org/schema/context/spring-context-3.1.xsd">    <!-- 自动扫描 -->    <context:component-scan base-package="com.skd.service.impl" />    <import resource="spring-mybatis.xml"></import> </beans>

2.13 创建测试类（查看是否整合成功）

import com.skd.service.StudentService;import org.junit.Test;import org.junit.runner.RunWith;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.test.context.ContextConfiguration;import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;@RunWith(SpringJUnit4ClassRunner.class)@ContextConfiguration(locations={"classpath:Spring.xml"})public class TestService {    @Autowired    private StudentService studentService;    @Test    public void test(){        System.out.print(studentService.select(1));    }}

2.14 整合成功

3.代码下载

本博客的代码下载地址为：MyBatis之与Spring整合