网上有许多关于SpringMVC与Mybatis整合的实例,但是由于Mybaits-spring有好几种配置方式,这样看起来会觉得很乱,不知道哪个是对的,觉得很复杂(至少我的感觉是这样的)。把关于这块的学习过程记录下来,留作备注同时与大家分享交流。
工具:eclipse-luna、mysql数据库
SpringMVC版本:3.2.1
Mybatis版本:3.0.4
Mybaits-spring版本:
服务器:tomcat7.0.57
文件结构:
项目所使用的lib包截图:
我们按照javaWeb项目在服务器中执行顺序(web项目首先加载web.xml文件)来说:
web.xml文件:在文件中,我们需要配置Spring的监听器ContextLoaderListener和SpringMVC的转发器DispatcherServlet,在web.xml中加入如下代码
<!--
说明:
我的所有的配置文件(.xml)都放在了WEB-INF/下,所以文件路径配置成了这种形式:<param-value>/WEB-INF/spring-applicationContext.xml</param-value>
如果你想把某一些配置文件(.xml)放到类路径下(也就是src文件下),形式为:<param-value>classpath:spring-applicationContext.xml</param-value>
-->
<!-- 配置Spring-start -->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<!-- 配置Spring-end -->
<!-- 配置Spring的上下文参数-start-->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>/WEB-INF/spring-applicationContext.xml</param-value>
</context-param>
<!-- 配置Spring的上下文参数-end -->
<filter>
<filter-name>encodingFilter</filter-name>
<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>utf-8</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>encodingFilter</filter-name>
<url-pattern>*.yy</url-pattern>
</filter-mapping>
<filter-mapping>
<filter-name>encodingFilter</filter-name>
<url-pattern>*.jsp</url-pattern>
</filter-mapping>
<!-- 配置SpringMVC-start -->
<servlet>
<servlet-name>springmvc</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>/WEB-INF/spring-dispatcher.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>springmvc</servlet-name>
<url-pattern>*.yy</url-pattern>
</servlet-mapping>
<!-- 配置SpringMVC-end -->
在web.xml文件中,包含spring的配置文件:spring-applicationContext.xml ;SpringMVC的配置文件:spring-dispatcher.xml。
spring-dispatcher.xml文件:在文件中加入如下代码
<!-- 扫描所以的bean包,解析@Controller @service等注解,自动set所用到的下一层的bean属性 -->
<context:component-scan base-package="com.yy" />
<!-- 模型视图名称解析 -->
<bean id="viewResolver"
class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<!-- 如果使用jstl的话,配置下面的属性-->
<property name="viewClass">
<value>org.springframework.web.servlet.view.JstlView</value>
</property>
<property name="prefix" value="/"></property>
<property name="suffix" value=".jsp"></property>
</bean>
spring-applicationContext.xml文件:在文件中加入如下代码
<!-- 由于spring-dispatcher文件已经加了下面这句话,所以这里加不加都行,但是spring-dispatcher是必须要加的,否则报错 -->
<!-- <context:component-scan base-package="com.yy" /> -->
<!-- 读取资源文件 -->
<!-- 第一种写法 -->
<context:property-placeholder location="WEB-INF/jdbc.properties"/>
<!-- 第二种写法
<bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="location" value="WEB-INF/jdbc.properties" />
</bean>
-->
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" >
<value>${driverClassName}</value>
</property>
<property name="password">
<value>${password}</value>
</property>
<property name="username">
<value>${username}</value>
</property>
<property name="url">
<value>${url}</value>
</property>
</bean>
<import resource="spring-mybatis.xml"/>
文件中包含数据库连接池datasource的配置文件:
jdbc.properties;spring与mybatis结合的配置文件:
spring-mybatis.xml。spring-mybatis.xml文件的内容可以都放在spring.xml文件中,合成一个spring.xml文件和分成两个文件各有各的好处,看你的习惯
jdbc.properties文件:在文件中加入如下代码
driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/你的数据库名字
username=root
password=root
spring-mybatis.xml文件:在文件中加入如下代码
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="configLocation" value="WEB-INF/mybatis-config.xml" />
<span style="white-space:pre"> </span><!-- 当BuyOrderMapper.java与BuyOrderMapper.xml文件在同一个包下时,不需要配置mapperLocations属性;相反,则必须配置 -->
<property name="mapperLocations">
<list>
<value>classpath:com/yy/mapper/**/*Mapper.xml</value>
</list>
</property>
</bean>
<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
<constructor-arg index="0" ref="sqlSessionFactory" />
</bean>
文件中包含mybatis的配置文件:
mybatis-config.xml
mybatis-config.xml文件:在文件中加入如下代码
<configuration>
<properties>
<property name="dialect" value="mysql"/>
</properties>
<settings>
<!-- 全局映的射器是否启用缓存 -->
<setting name="cacheEnabled" value="true" />
<!-- 全局启用或禁止延迟加载。当禁用时,所有关联对象都会即时加载 -->
<setting name="lazyLoadingEnabled" value="true" />
<!-- 允许或不允许多种结果集从一个单独的语句中返回(需要合适的驱动) -->
<setting name="multipleResultSetsEnabled" value="true" />
<!-- 使用列标签代替别名。不同的驱动器表现不同 -->
<setting name="useColumnLabel" value="true" />
<!-- 允许JDBC支持生成的建。需要合适的驱动 -->
<setting name="useGeneratedKeys" value="false" />
<!-- 配置默认的执行器,SIMPLE,REUSE:执行器重用预处理语句,BATCH:执行器重用语句和批量更新 -->
<setting name="defaultExecutorType" value="SIMPLE" />
</settings>
<typeAliases>
<typeAlias type="com.yy.model.Order"/>
<typeAlias type="com.yy.model.OrderProduct"/>
</typeAliases>
</configuration>
配置文件到这里就配置完了,下面我们说一下controller、service、dao、model四层的代码
controller层:
package com.yy.controller;
import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;
import com.yy.model.Order;
import com.yy.service.BuyOrderService;
@Controller
@RequestMapping("buyOrder")
public class BuyOrderController {
@Resource
private BuyOrderService buyOrderService;
@RequestMapping("/addBuyOrder")
public ModelAndView addBuyOrder(HttpServletRequest resquest,HttpServletResponse response){
return new ModelAndView("/test");
}
@RequestMapping("/deleteBuyOrder")
public ModelAndView deleteBuyOrder(HttpServletRequest resquest,HttpServletResponse response){
return new ModelAndView("/test");
}
@RequestMapping("/getBuyOrderById")
public ModelAndView getBuyOrderById(int id,HttpServletRequest resquest,HttpServletResponse response){
Order order = buyOrderService.getBuyOrderById(id);
System.out.println(order.getId()+"+++"+order.getId());
return new ModelAndView("/test");
}
@RequestMapping("/getBuyOrderList")
public ModelAndView getBuyOrderList(HttpServletRequest resquest,HttpServletResponse response){
return new ModelAndView("/test");
}
}
service层
package com.yy.service;
import com.yy.model.Order;
public interface BuyOrderService {
public Order getBuyOrderById(int id);
public void addBuyOrder(Order order);
}
serviceImpl层
package com.yy.service.Impl;
import javax.annotation.Resource;
import org.springframework.stereotype.Service;
import com.yy.dao.BuyOrderDao;
import com.yy.model.Order;
import com.yy.service.BuyOrderService;
@Service
public class BuyOrderServiceImpl implements BuyOrderService{
@Resource
private BuyOrderDao buyOrderDao;
@Override
public Order getBuyOrderById(int id) {
return buyOrderDao.getBuyOrderById(id);
}
@Override
public void addBuyOrder(Order order) {
buyOrderDao.addBuyOrder(order);
}
}
dao层
package com.yy.dao;
import com.yy.model.Order;
public interface BuyOrderDao {
Order getBuyOrderById(int id);
void addBuyOrder(Order order);
}
mapper映射器类、映射器xml文件
映射器类文件
package com.yy.mapper;
import org.mybatis.spring.support.SqlSessionDaoSupport;
import org.springframework.stereotype.Repository;
import com.yy.dao.BuyOrderDao;
import com.yy.model.Order;
@Repository
public class BuyOrderMapper extends SqlSessionDaoSupport implements BuyOrderDao {
@Override
public Order getBuyOrderById(int id) {
return (Order)this.getSqlSession().selectOne("com.yy.mapper.BuyOrderMapper.getBuyOrderById", id);
}
@Override
public void addBuyOrder(Order order) {
this.getSqlSession().insert("org.mybatis.spring.com.yy.mapper.addBuyOrder",order);
}
}
映射器xml文件
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//ibatis.apache.org//DTD Mapper 3.0//EN" "http://ibatis.apache.org/dtd/ibatis-3-mapper.dtd">
<mapper namespace="com.yy.mapper.BuyOrderMapper">
<select id="getBuyOrderById" parameterType="int" resultType="com.yy.model.Order">
select * from order1 where id = #{id}
</select>
</mapper>
model层
package com.yy.model;
import java.sql.Date;
public class Order {
private int id;
private String code;
private String username;
private String tel;
private String addresss;
private Date create_time;
public Order(){}
public Order(int id, String code, String username, String tel,String addresss, Date create_time) {
super();
this.id = id;
this.code = code;
this.username = username;
this.tel = tel;
this.addresss = addresss;
this.create_time = create_time;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getCode() {
return code;
}
public void setCode(String code) {
this.code = code;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getTel() {
return tel;
}
public void setTel(String tel) {
this.tel = tel;
}
public String getAddresss() {
return addresss;
}
public void setAddresss(String addresss) {
this.addresss = addresss;
}
public Date getCreate_time() {
return create_time;
}
public void setCreate_time(Date create_time) {
this.create_time = create_time;
}
}
前台jsp文件:
index.jsp
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<base href="<%=basePath%>">
<title>Insert title here</title>
</head>
<body>
<a href="buyOrder/getBuyOrderById.yy">欢迎</a><br>
<form id="searchForm" name="searchForm" action="buyOrder/getBuyOrderById.yy">
<input type="text" name="name" value="y"/><br>
<input type="text" name="id" value="1"/><br>
<input type="submit" value="提交"/><br>
</form>
</body>
</html>
test.jsp
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<base href="<%=basePath%>">
<title>Insert title here</title>
</head>
<body>
<a href="jsp/welcome.jsp">test</a>
</body>
</html>
数据sql文件:
DROP TABLE IF EXISTS `order1`;
CREATE TABLE `order1` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`code` varchar(20) DEFAULT NULL,
`username` varchar(20) DEFAULT NULL,
`tel` varchar(20) DEFAULT NULL,
`address` varchar(20) DEFAULT NULL,
`create_time` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of order1
-- ----------------------------
INSERT INTO `order1` VALUES ('1', '001', 'yy', '123456', '亚洲', '2014-12-16 16:19:51');
INSERT INTO `order1` VALUES ('2', '002', 'yyy', '654321', '欧洲', '2014-12-24 16:21:04');
到这里,代码就全部呈现了。哪里的细节你觉得不明白,欢迎交流