Spring(四）Spring整合Mybatis

版本spring4+MyBatis3+JDK1.8
Spring环境的配置请参考前面文章，本文参考代码将会在资源中上传

jar包

主要包括：数据连接池（dbpc)+io+pool+Spring中jdbc+tx+Spring对MyBatis的支持包+myBatis+数据库连接jar包。

application.xml配置文件
整合时将连接数据库的信息以javaBean的形式配置到该文件中

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.springframework.org/schema/beans
           http://www.springframework.org/schema/beans/spring-beans-2.5.xsd">
           <!-- 配置数据源，destroy-method:关闭数据库的连接 -->       
    <bean  id="mydataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
        <property name="driverClassName" value="com.mysql.jdbc.Driver" />
        <property name="url" value="jdbc:mysql://127.0.0.1/mydatabase" />
        <property name="username" value="root" />
        <property name="password" value="root" />   </bean>
    <!-- 配置mybatis自身的信息，都归spring管理 -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="mydataSource" />
            <!-- 配置entity -->
        <property name="typeAliasesPackage" value="com.spring.entity" />
            <!-- 配置映射xml文件，注意路径的写法 -->
        <property name="mapperLocations" value="classpath*:com/spring/dao/*Mapper.xml" />
    </bean>
    <!-- 配置dao组件，value是dao层的包路径 -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.spring.dao" />
    </bean>
    <!-- 配置服务层组件 -->
    <bean id="deptServices" class="com.spring.service.DeptServices"/>
</beans>

Dao层
1.接口:包含一个返回值为list的查询方法

package com.spring.dao;
import java.util.List;
import com.spring.entity.Dept;
public interface DeptMapper {
    public List<Dept> findDept();
}

2.对应的映射文件

<?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.spring.dao.DeptMapper">
    <select id="findDept" resultMap="deptMapper">
        select * from dept
    </select>
    <resultMap type="Dept" id="deptMapper">
        <id property="id" column="id" />
        <result property="dname" column="dname" />
    </resultMap>
</mapper>

Service层

创建一个类，并将其通过注解标记为service，并调用dao层的方法

package com.spring.service;
import java.util.List;
import javax.annotation.Resource;
import org.springframework.stereotype.Service;
import com.spring.dao.DeptMapper;
import com.spring.entity.Dept;
@Service
public class DeptServices {
    @Resource(name="deptMapper")
    private DeptMapper deptMapper;
    public List<Dept> findDept(){
        return deptMapper.findDept();   
    }
}

实体类

创建一个类名为Dept的类，包含Integer的id和String类型的dname、dnumber、dloc以及他们的get和set方法。

控制层
1.需要的工具类

package com.spring.until;

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.springframework.web.context.WebApplicationContext;
import org.springframework.web.context.support.WebApplicationContextUtils;

import com.google.gson.Gson;

public class CommController {
    public WebApplicationContext getWebApplicationContext(HttpServletRequest request){
        return WebApplicationContextUtils.getWebApplicationContext(request.getServletContext());
    }
    public void toJson(HttpServletResponse response,Object obj) throws IOException{
        response.setCharacterEncoding("utf-8");
        PrintWriter out=response.getWriter();
        out.print(new Gson().toJson(obj));
        out.flush();
        out.close();
    }
}

2.测试整合环境的控制器类

package com.spring.controller;
import java.io.IOException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import com.spring.service.DeptServices;
import com.spring.until.CommController;
@Controller
@RequestMapping("deptController")
public class DeptController extends CommController{
    private DeptServices deptServices;
    @RequestMapping("findDept")
    public void findDept(HttpServletRequest request,HttpServletResponse response) throws IOException{
        deptServices=(DeptServices) getWebApplicationContext(request).getBean("deptServices");
        toJson(response, deptServices.findDept());
    }
}

注意需要在web.xml中将配置文件添加进去。
页面一个链接即可
<a href="<%=request.getContextPath()%>/deptController/findDept.action">测试spring整合MyBatis</a>