名称：<input type="text" name="name"** ****value="${door.name}"**/><br />        电话：<input type="text" name="tel" **value="${door.tel}"**/><br />        <br />        <input type="submit" value="提交"><br />    </form><br /></body>

DoorMapper.xml

<!-- 修改门店 now()获取当前时间--><br />    <update id=_"update"_><br />        update tb_door set <br />            name=#{name},<br />            tel=#{tel},<br />            created=now(),<br />            updated=now()<br />        where id=#{id}<br />    </update><br />    

DoorMapper接口

//
//
public void update(Door door);

DoorService接口

//
//
public void update(Door door);

DoorServiceImpl

//
@Override
public void update(Door door) {
doorMapper.update(door);
}

DoorController

//
@RequestMapping(“update”)
public String update(Door door){
//更新数据
doorService.update(door);

//跳转到列表(访问列表方法)
return “redirect:list”;
}

删除门店

1. 获取到当前记录的id，向服务器发送请求

2. 执行delete的SQL，返回的不是页面，而是刷新列表

DoorMapper.xml

delete from tb_door
where id=#{id}

DoorMapper接口

//
//
public void delete(Integer id);

DoorService接口

//
//
public void delete(Integer id);

DoorServiceImpl

//删除门店
@Override
public void delete(Integer id) {
doorMapper.delete(id);
}

DoorController

//删除门店<br />    @RequestMapping("delete")<br />    **public** String delete(Integer id){<br />        //删除门店<br />        doorService.delete(id);<br />        <br />        //跳转到列表方法（执行列表方法）<br />        **return** "redirect:list";<br />    }

总结

====订单管理

查询所有订单

Order对象

package cn.tedu.pojo;

import java.util.Date;

//描述订单表
public class Order extends BasePojo{
//id字段
private Integer id;

//door_id字段
private Integer doorId;

//order_no字段
private String orderNo;

//order_type字段
private String orderType;

//person_num字段
private Integer personNum;

//cashier字段
private String cashier;

//create_time字段
private Date createTime;

//end_time字段
private Date endTime;

//payment_type字段
private String paymentType;

//price字段
private Double price;

//getters and setters

public Integer getId() {
return id;
}

**public** **void** setId(Integer id) {<br />        **this**.id = id;<br />    }

**public** Integer getDoorId() {<br />        **return** doorId;<br />    }

**public** **void** setDoorId(Integer doorId) {<br />        **this**.doorId = doorId;<br />    }

**public** String getOrderNo() {<br />        **return** orderNo;<br />    }

**public** **void** setOrderNo(String orderNo) {<br />        **this**.orderNo = orderNo;<br />    }

**public** String getOrderType() {<br />        **return** orderType;<br />    }

**public** **void** setOrderType(String orderType) {<br />        **this**.orderType = orderType;<br />    }

**public** Integer getPersonNum() {<br />        **return** personNum;<br />    }

**public** **void** setPersonNum(Integer personNum) {<br />        **this**.personNum = personNum;<br />    }

**public** String getCashier() {<br />        **return** cashier;<br />    }

**public** **void** setCashier(String cashier) {<br />        **this**.cashier = cashier;<br />    }

**public** Date getCreateTime() {<br />        **return** createTime;<br />    }

**public** **void** setCreateTime(Date createTime) {<br />        **this**.createTime = createTime;<br />    }

**public** Date getEndTime() {<br />        **return** endTime;<br />    }

**public** **void** setEndTime(Date endTime) {<br />        **this**.endTime = endTime;<br />    }

**public** String getPaymentType() {<br />        **return** paymentType;<br />    }

**public** **void** setPaymentType(String paymentType) {<br />        **this**.paymentType = paymentType;<br />    }

**public** Double getPrice() {<br />        **return** price;<br />    }

**public** **void** setPrice(Double price) {<br />        **this**.price = price;<br />    }<br />    <br />    <br />    //toString<br />        <br />    @Override<br />    **public** String toString() {<br />        **return** "Order [id=" + id + ", doorId=" + doorId + ", orderNo=" + orderNo + ", orderType=" + orderType<br />                + ", personNum=" + personNum + ", cashier=" + cashier + ", createTime=" + createTime + ", endTime="<br />                + endTime + ", paymentType=" + paymentType + ", price=" + price + "]";<br />    }<br />    <br />    <br />    <br />    <br />    <br />}

OrderMapper.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">

<!-- 查询所有订单 <br />        resultType代表结果集要封装给谁<br />    --><br />    <select id=_"SelectAll"_<br />            resultType=_"cn.tedu.pojo.Order"_><br />        select * from tb_order<br />    </select><br />    <br />    

OrderMapper接口

package cn.tedu.dao;

import java.util.List;

import cn.tedu.pojo.Order;

public interface OrderMapper {

//查询所有订单 <br />    //<select id="SelectAll"<br />    //resultType="cn.tedu.pojo.Order"><br />    **public** List<Order> SelectAll();<br />    <br />    <br />    <br />    <br />}

OrderService接口

package cn.tedu.service;

import java.util.List;

import cn.tedu.pojo.Order;

public interface OrderService {

//查询所有订单
// //resultType=”cn.tedu.pojo.Order”>
public List SelectAll();

}

OrderServiceImpl.java

package cn.tedu.service;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import cn.tedu.dao.OrderMapper;
import cn.tedu.pojo.Order;

//作用1：交给spring管理对象
//作用2：代表是业务层代码
@Service
public class OrderServiceImpl implements OrderService {

<br />    @Autowired//自动注入dao层<br />    **private** OrderMapper orderMapper;<br />    <br />    <br />    //查询所有订单<br />    @Override<br />    **public** List<Order> SelectAll() {<br />        //调用dao层干活<br />        **return** orderMapper.SelectAll();<br />    }

}

OrderController.java

package cn.tedu.controller;

import java.util.List;

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 cn.tedu.pojo.Order;
import cn.tedu.service.OrderService;

@Controller
@RequestMapping(“order”)
public class OrderController {

@Autowired //自动注入service层<br />    **private** OrderService orderService;<br />    <br />    //查询所有订单<br />    @RequestMapping("list")<br />    **public** String list(Model model){<br />        //查询所有数据<br />        List<Order> list =<br />                orderService.SelectAll();<br />        <br />        //给页面准备数据<br />        model.addAttribute("orderList",list);<br />        <br />        //跳转页面<br />        **return** "order";<br />        <br />    }<br />    <br />    <br />    <br />}

order.jsp

<%@ page language=”java” contentType=”text/html; charset=utf-8”
pageEncoding=”utf-8”%>
<%@ taglib prefix=”c” uri=”http://java.sun.com/jsp/jstl/core"%>
<%@ taglib prefix=”fmt” uri=”http://java.sun.com/jsp/jstl/fmt"%>
<!DOCTYPE html PUBLIC “-//W3C//DTD HTML 4.01 Transitional//EN” “http://www.w3.org/TR/html4/loose.dtd">

！！！问题：数据没封装成功，需要使用resultMap

由于实体中的属性名和表中的字段名不一致，导致无法使用resultType来封装，这时需要使用resultMap来解决。
<?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">

<!-- 映射不规则字段 <br />        type：要把数据封装给哪个对象<br />        id：该resultMap的唯一标志<br />    --><br />    <resultMap type=_"cn.tedu.pojo.Order"_ <br />                **id=**_**"OrderRM"**_><br />        <br /><!-- id属性 column是字段名  property是属性名-->    <br />        <id column=_"id"_ property=_"id"_/><br />        <br /><!-- 其他属性 column是字段名  property是属性名-->            <br />        <result column=_"door_id"_ property=_"doorId"_/>        <br />        <result column=_"order_no"_ property=_"orderNo"_/>        <br />        <result column=_"order_type"_ property=_"orderType"_/>        <br />        <result column=_"person_num"_ property=_"personNum"_/>        <br />        <result column=_"cashier"_ property=_"cashier"_/>        <br />        <result column=_"create_time"_ property=_"createTime"_/>        <br />        <result column=_"end_time"_ property=_"endTime"_/>        <br />        <result column=_"payment_type"_ property=_"paymentType"_/>        <br />        <result column=_"price"_ property=_"price"_/>        <br />        <result column=_"created"_ property=_"created"_/>        <br />        <result column=_"updated"_ property=_"updated"_/>        <br />    </resultMap>

<!-- 查询所有订单 <br />        resultMap：引用一个id值<br />    --><br />    <select id=_"SelectAll"_<br />            **resultMap=**_**"OrderRM"**_**>**<br />        select * from tb_order<br />    </select><br />    <br />    

拓展

配置别名

在applicationContext-mybatis.xml中配置别名包，就会把类名作为别名：
xmlns:context=”http://www.springframework.org/schema/context“ xmlns:p=”http://www.springframework.org/schema/p“
xmlns:aop=”http://www.springframework.org/schema/aop“ xmlns:tx=”http://www.springframework.org/schema/tx“
xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance“
xsi:schemaLocation=”http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd
http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.0.xsd">

<!-- 配置sqlsessionfactory --><br />    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"><br />        <property name="configLocation" value="classpath:mybatis/mybatis-config.xml"></property><br />        <property name="dataSource" ref="dataSource"></property><br />    <br />        <!-- 扫描mapper --><br />        <property name="mapperLocations" value="classpath:mybatis/mapper/*.xml"></property><br />    <br />        <!-- 配置别名包 --><br /><property name="**typeAliasesPackage**" value="cn.tedu.pojo"></property><br />        <br />    </bean><br />    <br />    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <br />        <property name="basePackage" value="cn.tedu.dao"></property><br />    </bean><br />    <br /></beans>

中文乱码

在jsp中的form中加属性accept-charset=”utf-8”
在web.xml中添加字符集过滤器：
　　characterEncodingFilter 　　org.springframework.web.filter.CharacterEncodingFilter 　　 　　　　encoding 　　　　UTF-8 　　 　　 　　　　forceEncoding 　　　　true 　　
　　characterEncodingFilter 　　/*

查询关联的门店对象

修改Order实体类

修改OrderMapper.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">