spring mvc+mybatis整合 (二)

转：http://lifeneveralone.diandian.com/post/2012-11-02/40042292065

本文介绍使用spring mvc结合Mybatis搭建一个应用程序框架.

demo源码下载：springMVC-Mybatis

1.准备工作：

spring的jar包：

spring-beans-3.1.0.RELEASE.jar

spring-core-3.1.0.RELEASE.jar

spring-web-3.1.0.RELEASE.jar

spring-webmvc-3.1.0.RELEASE.jar

spring-context-3.1.0.RELEASE.jar

spring-expression-3.1.0.RELEASE.jar

spring-aop-3.1.0.RELEASE.jar

spring-asm-3.1.0.RELEASE.jar

spring-context-support-3.1.0.RELEASE.jar

mybatis与Spring的整合所需的包:

mysql-connector-java-5.1.21-bin.jar

mybatis-spring-1.1.1.jar

mybatis-3.1.1.jar

JDBC驱动：

mysql-connector-java-3.1.6-bin.jar

公共jar包：

commons-dbcp-1.4.jar

commons-io-2.0.1.jar

commons-logging-1.1.1.jar

commons-pool-1.6.jar

hibernate-validator-4.1.0.Final.jar

slf4j-api-1.6.1.jar

slf4j-log4j12-1.6.1.jar

log4j-1.2.16.jar

2.web.xml配置

<?xml version="1.0" encoding="UTF-8"?>

<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" version="3.0">

 <display-name>shop</display-name>

   

 <!-- log4j配置初始化 -->

 <context-param>

   <param-name>log4jConfigLocation</param-name>

   <param-value>WEB-INF/log4j/log4j.properties</param-value>

 </context-param>

 <!-- log4j的配置每分钟刷新一次，这样在后续定位问题是修改日志配置后不需要重启系统 -->

 <context-param>

   <param-name>log4jRefreshInterval</param-name>

   <param-value>60000</param-value>

 </context-param>

 <listener>

   <listener-class>  

           org.springframework.web.util.Log4jConfigListener  

       </listener-class>

 </listener>

   

 <!-- spring配置初始化 -->

 <context-param>

   <param-name>contextConfigLocation</param-name>

   <param-value>/WEB-INF/spring/*-context.xml</param-value>

 </context-param>

 <listener>

   <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>

 </listener>

   

 <!-- Spring MVC配置，配置分发器 -->

 <servlet>

   <servlet-name>appServlet</servlet-name>

   <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>

   <init-param>

     <param-name>contextConfigLocation</param-name>

     <param-value>/WEB-INF/spring/appServlet/servlet-context.xml</param-value>

   </init-param>

   <load-on-startup>1</load-on-startup>

 </servlet>

 <servlet-mapping>

   <servlet-name>appServlet</servlet-name>

   <url-pattern>/</url-pattern>

 </servlet-mapping>

   

 <!-- 配置欢迎界面 -->

 <welcome-file-list>

   <welcome-file>index.jsp</welcome-file>

 </welcome-file-list>

   

</web-app>

3.spring mvc的配置servlet-context.xml：

<?xml version="1.0" encoding="UTF-8"?>

<beans:beans xmlns="http://www.springframework.org/schema/mvc"

   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

   xmlns:beans="http://www.springframework.org/schema/beans"

   xmlns:context="http://www.springframework.org/schema/context"

   xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd

       http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd

       http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd">

       <!-- DispatcherServlet Context: defines this servlet's request-processing infrastructure -->

   

   <!-- Enables the Spring MVC @Controller programming model -->

   <annotation-driven />

   

   <context:annotation-config />

   <context:component-scan base-package="com.huawei.shop.controller" />

   <!-- Handles HTTP GET requests for /resources/** by efficiently serving up static resources in the ${webappRoot}/resources directory -->

   <resources mapping="/js/**" location="/js/" />

   <resources mapping="/css/**" location="/css/" />

   <resources mapping="/images/**" location="/images/" />

   

   <!-- Resolves views selected for rendering by @Controllers to .jsp resources in the /WEB-INF/views directory -->

   <beans:bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">

       <beans:property name="prefix" value="/jsp/" />

       <beans:property name="suffix" value=".jsp" />

   </beans:bean>

   

   

   <!-- Imports user-defined @Controller beans that process client requests -->

   <!--

   <beans:import resource="controllers.xml" />

    -->

</beans:beans>

4.Mybatis-spring的配置：mybatis-context.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:aop="http://www.springframework.org/schema/aop"

    xmlns:tx="http://www.springframework.org/schema/tx"

    xmlns:context="http://www.springframework.org/schema/context"

    xmlns:jdbc="http://www.springframework.org/schema/jdbc"

    xsi:schemaLocation="

    http://www.springframework.org/schema/beans

    http://www.springframework.org/schema/beans/spring-beans-3.0.xsd

    http://www.springframework.org/schema/tx

    http://www.springframework.org/schema/tx/spring-tx-3.0.xsd

     http://www.springframework.org/schema/jdbc

     http://www.springframework.org/schema/jdbc/spring-jdbc-3.0.xsd

    http://www.springframework.org/schema/aop

    http://www.springframework.org/schema/aop/spring-aop-3.0.xsd

    http://www.springframework.org/schema/context

http://www.springframework.org/schema/context/spring-context-3.0.xsd"

>

<!-- enable autowire -->

   <context:annotation-config />

<context:component-scan base-package="com.huawei.shop.*" />

   <!--配置jdbc.properties文件的位置信息，路径还是区分大小写 -->

   <bean  class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">

   <property name="locations" value="WEB-INF/jdbc/jdbc.properties" />  

   </bean>  

   

   <!-- 读取jdbc.properties文件，配置数据源 -->  

   <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"   destroy-method="close">   

   <property name="driverClassName" value="${jdbc.driver}" />   

   <property name="url" value="${jdbc.url}" />

   <property name="username" value="${jdbc.user}" />   

   <property name="password" value="${jdbc.password}" />   

   <!-- 数据库连接池配置 -->   

   <property name="initialSize" value="${jdbc.initialPoolSize}" />

   <!-- 初始化连接数量 -->   

   <property name="maxActive" value="${jdbc.maxPoolSize}" />

   <!-- 最大连接数量 -->   

   <property name="maxIdle" value="${jdbc.maxIdlePollSize}" />

   <!-- 最大空闲连接数量 -->   

   <property name="minIdle" value="${jdbc.mixIdlePollSize}" />

   <!-- 最小空闲连接数量 -->  

   </bean>

<!-- sqlSessionFactory --><!-- MyBatis在spring中Bean的配置，都是固定的 -->  

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">   

<property name="configLocation" value="WEB-INF/mybatis/Mybatis-Configuration.xml" />   

<property name="dataSource" ref="dataSource" />

<property name="mapperLocations">

<list>

<value>WEB-INF/mybatis/*Mapper.xml</value>

</list>

</property>  

<property name="typeAliasesPackage" value="com.huawei.shop.model" />

</bean>  

<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">   

<constructor-arg index="0" ref="sqlSessionFactory" />  

</bean>

<!--

<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">

       <property name="basePackage" value="com.huawei.shop.repository" />

   </bean>

     -->

     

     <!-- scan for mappers and let them be autowired -->

   <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">

       <property name="basePackage" value="com.huawei.shop.repository" />

   </bean>

</beans>

5.Mybatis的配置：Mybatis-Configuration.xml：

<?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>

<settings>

   

    <!-- 全局的映射器启用或禁用缓存。 -->

<setting name="cacheEnabled" value="true" />

<!-- 全局启用或禁用延迟加载 -->

        <setting name="lazyLoadingEnabled" value="true" />

         

        <!-- 允许或不允许多种结果集从一个单独的语句中返回 -->

        <setting name="multipleResultSetsEnabled" value="true" />

        

        <!-- 设置超时时间 -->

        <setting name="defaultStatementTimeout" value="25000" />

        

</settings>

<!--

<typeAliases>  

       <typeAlias alias="AdminTable" type="com.huawei.shop.model.AdminTable"/>

   </typeAliases>  

   -->

 <!-- 对应vo类的DAO接口 所对应的xml配置文件的路径信息    -->

 <!--

 <mappers>

 <mapper resource="AdminTable.xml" />  

 </mappers>

   -->

</configuration>

6.jdbc的配置：jdbc.properties：

jdbc.driver=com.mysql.jdbc.Driver

jdbc.url=jdbc:mysql://127.0.0.1:3306/cop?useUnicode=true&characterEncoding=UTF-8

jdbc.user=root

jdbc.password=root

jdbc.initialPoolSize=10

jdbc.maxPoolSize=50

jdbc.maxIdlePollSize=50

jdbc.mixIdlePollSize=10

log4j的配置就不贴了，到目前为止，我们大致完成了spring mvc + mybatis的框架的所有配置文件。为了有效减少配置文件，我们使用了spring的annotation。实践证明，基于annotation的 spring mvc + mybatis的框架是可以做到后续的开发零配置，但是个人觉得，为了有效管理Mybatis的sql语句（这些是在我们开发过程中可能会不停的修改的。 而spring的配置一般是一次配置，后续就会很少修改），我们将sql语句使用了映射文件，而不是以注释方式写在代码里面。

下面，我们来看具体的代码实践。本demo实现了从页面输入一个用户名和密码，到数据库校验密码是否正确的功能，一个简单的登录流程。

1.login.jsp,主要实现了一个表单提交的功能:

<div>

<form id="login" name="login" action="login" method="post">

<table>

<tr>

<td>用户名</td>

<td><input id="name" name="name" type="text" /></td>

</tr>

<tr>

<td>密码</td>

<td><input id="password" name="password" type="password" /></td>

</tr>

<tr>

<td><input value="登录" type="submit" onclick="disp_alert()"/></td>

</tr>

</table>

</form>

</div>

2.LoginController.java

package com.huawei.shop.controller;

import java.util.List;

import org.apache.log4j.Logger;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Controller;

import org.springframework.ui.Model;

import org.springframework.web.bind.annotation.RequestMapping;

import org.springframework.web.bind.annotation.RequestMethod;

import com.huawei.shop.model.AdminTable;

import com.huawei.shop.model.ConfigTable;

import com.huawei.shop.service.AdminService;

import com.huawei.shop.service.ConfigService;

@Controller

public class LoginController

{

private static final Logger logger = Logger.getLogger("DEBUG");

@Autowired

private AdminService adminService;

@Autowired

private ConfigService configService;

@RequestMapping(value = "/login", method = RequestMethod.POST)

public String login(String name, String password, Model model)

{

logger.error("name = "+name);

AdminTable admin = adminService.getUserPassword(name);

List<ConfigTable> configs = configService.getAllConfig();

       String passwd = admin.getPassword();

       model.addAttribute("admin", admin);

       model.addAttribute("name", name);

       model.addAttribute("password", password);

       model.addAttribute("configs", configs);

   

if (passwd.equals(password))

{

return "home";

}

return "error";

}

}

3.AdminService.java

package com.huawei.shop.service;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Service;

import com.huawei.shop.model.AdminTable;

import com.huawei.shop.repository.AdminMapper;

@Service

public class AdminService

{

@Autowired

private AdminMapper adminMapper;

public AdminTable getUserPassword(String name) {

   return adminMapper.getUserPassword(name);

 }

}

 

4.AdminMapper.java

package com.huawei.shop.service;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Service;

import com.huawei.shop.model.AdminTable;

import com.huawei.shop.repository.AdminMapper;

@Service

public class AdminService

{

@Autowired

private AdminMapper adminMapper;

public AdminTable getUserPassword(String name) {

   return adminMapper.getUserPassword(name);

 }

}

 

5.AdminTable.java

package com.huawei.shop.model;

public class AdminTable

{

private String name;

private String password;

public String getName()

{

return name;

}

public void setName(String name)

{

this.name = name;

}

public String getPassword()

{

return password;

}

public void setPassword(String password)

{

this.password = password;

}

}

 

6.AdminTable-Mapper.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.huawei.shop.repository.AdminMapper">

<resultMap id="AdminMap" type="AdminTable" >

<id property="name" column="AD_NAME"></id>

<id property="password" column="AD_PASSWORD"></id>

</resultMap>

<select id="getUserPassword" parameterType="String" resultMap="AdminMap"> select

AD_NAME, AD_PASSWORD from ADMIN where AD_NAME=#{name}  </select>

</mapper>