javaWeb項目SpringMVC3.2.1與Mybatis3.0.4整合實例(Mybaits

 /WEB-INF/spring-applicationContext.xml
 	如果你想把某一些配置文件(.xml)放到類路徑下(也就是src文件下)，形式為：classpath:spring-applicationContext.xml
 -->
 
 	
	org.springframework.web.context.ContextLoaderListener
 	
 
 
 
 	
	contextConfigLocation
	/WEB-INF/spring-applicationContext.xml
 	
 
 
 
 	encodingFilter
 	org.springframework.web.filter.CharacterEncodingFilter
 	
 	encoding
 	utf-8
 	
 
 
 
 	encodingFilter
 	*.yy
 
 
 
 	encodingFilter
 	*.jsp
 
 
 
 
 springmvc
 org.springframework.web.servlet.DispatcherServlet
	 
	 	 contextConfigLocation
	 	 /WEB-INF/spring-dispatcher.xml
	 
 1
 

 
 springmvc
 *.yy
 
 

  
 
 
 
 
 org.springframework.web.servlet.view.JstlView
 
 
 
 

 
 --> 
 
 
 
 
	
	
	 -->
	
	
	${driverClassName}
	
	
	${password}
	
	
	${username}
	
	
	${url}
	
	
	
	

driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/你的數(shù)據(jù)庫名字
username=root
password=root

	
	
	
	classpath:com/yy/mapper/**/*Mapper.xml
	
	

	

	

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

package com.yy.service;

import com.yy.model.Order;

public interface BuyOrderService {

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

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

}

package com.yy.dao;

import com.yy.model.Order;

public interface BuyOrderDao {

	Order getBuyOrderById(int id);

	void addBuyOrder(Order order);

}

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

	
	select * from order1 where id = #{id}
	

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

<%@ 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+"/";
%>





">



	歡迎

	
	

<%@ 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+"/";
%>








	test

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