本文介绍使用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" οnclick="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>