javaWeb项目SpringMVC3.2.1与Mybatis3.0.4整合实例(Mybaits-Mysql Tutorial-php.cn

网上有许多关于SpringMVC与Mybatis整合的实例，但是由于Mybaits-spring有好几种配置方式，这样看起来会觉得很乱，不知道哪个是对的，觉得很复杂(至少我的感觉是这样的)。把关于这块的学习过程记录下来，留作备注同时与大家分享交流。工具：eclipse-luna、m

网上有许多关于SpringMVC与Mybatis整合的实例，但是由于Mybaits-spring有好几种配置方式，这样看起来会觉得很乱，不知道哪个是对的，觉得很复杂(至少我的感觉是这样的)。把关于这块的学习过程记录下来，留作备注同时与大家分享交流。

工具：eclipse-luna、mysql数据库

SpringMVC版本：3.2.1

Mybatis版本：3.0.4

Mybaits-spring版本：

服务器：tomcat7.0.57

文件结构：

javaWeb项目SpringMVC3.2.1与Mybatis3.0.4整合实例(Mybaits

项目所使用的lib包截图：

javaWeb项目SpringMVC3.2.1与Mybatis3.0.4整合实例(Mybaits

我们按照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  -->

Copy after login

在web.xml文件中，包含spring的配置文件：spring-applicationContext.xml ；SpringMVC的配置文件：spring-dispatcher.xml。

spring-dispatcher.xml文件：在文件中加入如下代码

<!-- 扫描所以的bean包，解析@Controller @service等注解，自动set所用到的下一层的bean属性 -->
    <component-scan base-package="com.yy"></component-scan>  
    <!-- 模型视图名称解析 -->
    <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>

Copy after login

spring-applicationContext.xml文件：在文件中加入如下代码

 <!-- 由于spring-dispatcher文件已经加了下面这句话,所以这里加不加都行,但是spring-dispatcher是必须要加的,否则报错 -->
    <!--  <context:component-scan base-package="com.yy" /> -->         
    <!-- 读取资源文件 -->  
    <!-- 第一种写法 -->
    <property-placeholder location="WEB-INF/jdbc.properties"></property-placeholder>
    <!-- 第二种写法
	<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"></import>

Copy after login

文件中包含数据库连接池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

Copy after login

spring-mybatis.xml文件：在文件中加入如下代码

  <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
	<property name="dataSource" ref="dataSource"></property>
	<property name="configLocation" value="WEB-INF/mybatis-config.xml"></property></bean>

Copy after login

<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 id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
	<constructor-arg index="0" ref="sqlSessionFactory"></constructor-arg>
</bean>

Copy after login

文件中包含mybatis的配置文件：mybatis-config.xml

mybatis-config.xml文件：在文件中加入如下代码

Copy after login

配置文件到这里就配置完了，下面我们说一下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");
	}
}

Copy after login

service层

package com.yy.service;

import com.yy.model.Order;

public interface BuyOrderService {

	public Order getBuyOrderById(int id);
	
	public void addBuyOrder(Order order);
}

Copy after login

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);
	}

}

Copy after login

dao层

package com.yy.dao;

import com.yy.model.Order;

public interface BuyOrderDao {

	Order getBuyOrderById(int id);

	void addBuyOrder(Order order);

}

Copy after login

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);
	}
}

Copy after login

映射器xml文件

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


<mapper namespace="com.yy.mapper.BuyOrderMapper">
	<select id="getBuyOrderById" parametertype="int" resulttype="com.yy.model.Order">
		select * from order1 where id = #{id}
	</select>
</mapper>

Copy after login

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;
	}
}

Copy after login

前台jsp文件：

index.jsp

    





<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<base href="<%=basePath%>">
<title>Insert title here</title>


	<a href="buyOrder/getBuyOrderById.yy">æ¬¢è¿</a><br>

Copy after login

test.jsp

    




<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<base href="<%=basePath%>">
<title>Insert title here</title>


	<a href="jsp/welcome.jsp">test</a>

Copy after login

æ°æ®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');

Copy after login