1.订单管理创建相应数据库表

2.创建相应实体类

3.订单列表分页全查询，订单名称模糊查询（有问题）

@Controller
@RequestMapping("/orders")
public class OrdersController {@AutowiredIOrdersService ordersService;/*** 查询订单全部信息* @param page* @param size* @param fuzzyName* @return* @throws Exception*/@RequestMapping(value = "/findAll.do",produces = "text/html;charset=UTF-8")public ModelAndView findAll(@RequestParam(value = "page",defaultValue = "1",required = false) String page,@RequestParam(value = "size",defaultValue = "4",required = false) String size,@RequestParam(value = "fuzzyName",defaultValue = "",required = false) String fuzzyName) throws Exception {ModelAndView mv = new ModelAndView();List<Orders> ordersList = ordersService.findAll(Integer.parseInt(page), Integer.parseInt(size),fuzzyName);PageInfo pageInfo = new PageInfo(ordersList);mv.addObject("ordersList",ordersList);mv.addObject("fuzzyName",fuzzyName);mv.addObject("pageInfo",pageInfo);mv.setViewName("orders-list");return mv;}
}

<?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" >
<mapper namespace="com.itheima.dao.IOrdersDao"><resultMap id="orderMap" type="com.itheima.domain.Orders"><id column="id" property="id"></id><result column="orderNum" property="orderNum"></result><result column="orderTime" property="orderTime"></result><result column="peopleCount" property="peopleCount"></result><result column="orderDesc" property="orderDesc"></result><result column="payType" property="payType"></result><result column="orderStatus" property="orderStatus"></result><association column="productId" property="product" javaType="com.itheima.domain.Product"><id column="id" property="id"></id><result column="productNum" property="productNum"></result><result column="productName" property="productName"></result><result column="cityName" property="cityName"></result><result column="departureTime" property="departureTime"></result><result column="productPrice" property="productPrice"></result><result column="productDesc" property="productDesc"></result><result column="productStatus" property="productStatus"></result></association><association column="memberId" property="member" javaType="com.itheima.domain.Member"><id column="id" property="id"></id><result column="name" property="name"></result><result column="nickname" property="nickname"></result><result column="phoneNum" property="phoneNum"></result><result column="email" property="email"></result></association></resultMap><select id="findAll" parameterType="java.lang.String" resultType="com.itheima.domain.Orders" resultMap="orderMap">selecto.id,o.orderNum,o.orderTime,o.peopleCount,o.orderDesc,o.payType,o.orderStatus,m.name,p.productNamefrom orders o,member m,product p<where>o.productId=p.id and o.memberId=m.id<if test="fuzzyName!=null and fuzzyName!=''">and productName like concat('%',#{fuzzyName},'%')</if></where></select>
</mapper>

						<!--数据列表--><table id="dataList" class="table table-bordered table-striped table-hover dataTable"><thead><tr><th class="" style="padding-right:0px;"><input id="selall" type="checkbox" class="icheckbox_square-blue"></th><th>订单ID</th><th>订单编号</th><th>产品名称</th><th>下单时间</th><th>会员姓名</th><th>出行人数</th><th>支付方式</th><th>订单状态</th><th>操作</th></tr></thead><tbody><c:forEach items="${ordersList}" var="order"><tr><td><input value="${order.id}" name="ids" type="checkbox"></td><td>${order.id}</td><td>${order.orderNum}</td><td>${order.product.productName}</td><td>${order.orderTimeStr}</td><td>${order.member.name}</td><td>${order.peopleCount}</td><td>${order.payTypeStr}</td><td>${order.orderStatusStr}</td><td class="text-center"><a href="${pageContext.request.contextPath}/orders/findById.do?id=${order.id}" class="btn bg-olive btn-xs">详情</a><a href="${pageContext.request.contextPath}/orders/findById.do?id=${order.id}" class="btn bg-olive btn-xs">编辑</a><a onclick="delById('${order.id}')" class="btn bg-olive btn-xs">删除</a></td></tr></c:forEach></tbody></table><!--数据列表/-->

今天就写到这