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文件
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+"/";
%>
Insert title here
欢迎
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+"/";
%>
Insert title here
test
