【Spring+Mybatis+SpringMVC整合项目五】天猫商城（后台-订单管理开发）

一时失言乱红尘 2022-04-11 04:42 218阅读 0赞

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTg2Njk2MA_size_16_color_FFFFFF_t_70][]

这里再记录订单管理的开发步骤。看看订单的POJO

里面包含了四个非数据库字段

private List<OrderItem> orderItems;
     
    private User user;
     
    private float total;
     
    private int totalNumber;

1.orderItems是指订单项，每个订单项都有一个oid字段，表示对应某个订单，可以根据oid来查出这个订单下有哪些订单项

2.user订单归属的用户

3.total是总价格，所有产品的价格

4.totalNumber是订单总共有几件

5.getStatusDesc方法，用于把英文表达的Status信息转换为中文

Order.java

package com.how2java.tmall.pojo;
     
    import com.how2java.tmall.service.OrderService;
     
    import java.util.Date;
    import java.util.List;
     
    public class Order {
        private Integer id;
     
        private String orderCode;
     
        private String address;
     
        private String post;
     
        private String receiver;
     
        private String mobile;
     
        private String userMessage;
     
        private Date createDate;
     
        private Date payDate;
     
        private Date deliveryDate;
     
        private Date confirmDate;
     
        private Integer uid;
     
        private String status;
     
        /*如下是非数据库字段*/
        private List<OrderItem> orderItems;
     
        private User user;
     
        private float total;
     
        private int totalNumber;
     
        
        public String getStatusDesc(){
            String desc ="未知";
            switch(status){
                case OrderService.waitPay:
                    desc="待付款";
                    break;
                case OrderService.waitDelivery:
                    desc="待发货";
                    break;
                case OrderService.waitConfirm:
                    desc="待收货";
                    break;
                case OrderService.waitReview:
                    desc="等评价";
                    break;
                case OrderService.finish:
                    desc="完成";
                    break;
                case OrderService.delete:
                    desc="刪除";
                    break;
                default:
                    desc="未知";
            }
            return desc;
        }
    
        /*****/
        setter and getter
        /****/
    }

再看看orderItem这个类

这个类下面有个Product类，我们可以根据OrderItem类下的pid查出这个product，就查出这条订单项的产品信息了

package com.how2java.tmall.pojo;
     
    public class OrderItem {
        private Integer id;
     
        private Integer pid;
     
        private Integer oid;
     
        private Integer uid;
     
        private Integer number;
    
        /*非数据库字段*/
        private Product product;
    
        /***/
        setter and getter
        /***/
    }

因为Order类里面有List orderItems这个属性，所以我们就得在orderItemService中加入方法，提供一个可以根据oid查询出orderitem的接口

OrderItemService

package com.how2java.tmall.service;
      
    import java.util.List;
     
    import com.how2java.tmall.pojo.Order;
    import com.how2java.tmall.pojo.OrderItem;
     
    public interface OrderItemService {
          
        void add(OrderItem c);
     
        void delete(int id);
        void update(OrderItem c);
        OrderItem get(int id);
        List list();
     
        void fill(List<Order> os);
     
        void fill(Order o);
     
    }

OrderItemServiceImpl

OrderItemServiceImpl实现OrderItemService，提供CRUD一套方法的实现。  
同时还提供fill(Order order)和fill(List<Order> orders), 先说fill(Order order) :   
为什么要提供这个方法呢？ 因为在订单管理界面，首先是遍历多个订单，然后遍历这个订单下的多个订单项。 而由MybatisGenerator逆向工程所创建的一套自动生成代码，是不具备一对多关系的，需要自己去二次开发。 这里就是做订单与订单项的一对多关系。  
在fill(Order order)中：  
1. 根据订单id查询出其对应的所有订单项  
2. 通过setProduct为所有的订单项设置Product属性  
3. 遍历所有的订单项，然后计算出该订单的总金额和总数量  
4. 最后再把订单项设置在订单的orderItems属性上。  
  
在fill(List<Order> orders) 中，就是遍历每个订单，然后挨个调用fill(Order order)。

package com.how2java.tmall.service.impl;
     
    import java.util.List;
     
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
     
    import com.how2java.tmall.mapper.OrderItemMapper;
    import com.how2java.tmall.pojo.Order;
    import com.how2java.tmall.pojo.OrderItem;
    import com.how2java.tmall.pojo.OrderItemExample;
    import com.how2java.tmall.pojo.Product;
    import com.how2java.tmall.service.OrderItemService;
    import com.how2java.tmall.service.ProductService;
     
    @Service
    public class OrderItemServiceImpl implements OrderItemService {
        @Autowired
        OrderItemMapper orderItemMapper;
        @Autowired
        ProductService productService;
     
        @Override
        public void add(OrderItem c) {
            orderItemMapper.insert(c);
        }
     
        @Override
        public void delete(int id) {
            orderItemMapper.deleteByPrimaryKey(id);
        }
     
        @Override
        public void update(OrderItem c) {
            orderItemMapper.updateByPrimaryKeySelective(c);
        }
     
        @Override
        public OrderItem get(int id) {
            OrderItem result = orderItemMapper.selectByPrimaryKey(id);
            setProduct(result);
            return result;
        }
     
        public List<OrderItem> list(){
            OrderItemExample example =new OrderItemExample();
            example.setOrderByClause("id desc");
            return orderItemMapper.selectByExample(example);
     
        }
     
        @Override
        public void fill(List<Order> os) {
            for (Order o : os) {
                fill(o);
            }
        }
     
        public void fill(Order o) {
            OrderItemExample example =new OrderItemExample();
            example.createCriteria().andOidEqualTo(o.getId());
            example.setOrderByClause("id desc");
            List<OrderItem> ois =orderItemMapper.selectByExample(example);
            setProduct(ois);
     
            float total = 0;
            int totalNumber = 0;
            for (OrderItem oi : ois) {
                total+=oi.getNumber()*oi.getProduct().getPromotePrice();
                totalNumber+=oi.getNumber();
            }
            o.setTotal(total);
            o.setTotalNumber(totalNumber);
            o.setOrderItems(ois);
     
        }
     
        public void setProduct(List<OrderItem> ois){
            for (OrderItem oi: ois) {
                setProduct(oi);
            }
        }
     
        private void setProduct(OrderItem oi) {
            Product p = productService.get(oi.getPid());
            oi.setProduct(p);
        }
     
        ;
     
    }

OrderService

package com.how2java.tmall.service;
      
    import java.util.List;
     
    import com.how2java.tmall.pojo.Order;
     
    public interface OrderService {
     
        String waitPay = "waitPay";
        String waitDelivery = "waitDelivery";
        String waitConfirm = "waitConfirm";
        String waitReview = "waitReview";
        String finish = "finish";
        String delete = "delete";
     
        void add(Order c);
     
        void delete(int id);
        void update(Order c);
        Order get(int id);
        List list();
    }

OrderServiceImpl

### 查询功能 ###

当我们访问[http://127.0.0.1:8080/tmall\_ssm/admin\_order\_list][http_127.0.0.1_8080_tmall_ssm_admin_order_list]时，就会导致OrderController.list()方法被调用

1. 获取分页对象  
2. 查询订单集合  
3. 获取订单总数并设置在分页对象上  
4. 借助orderItemService.fill()方法为这些订单填充上orderItems信息  
5. 把订单集合和分页对象设置在model上  
6. 服务端跳转到admin/listOrder.jsp页面  
7. 在listOrder.jsp借助c:forEach把订单集合遍历出来  
8. 遍历订单的时候，再把当前订单的orderItem订单项集合遍历出来

@RequestMapping("admin_order_list")
    public String list(Model model, Page page){
        PageHelper.offsetPage(page.getStart(),page.getCount());
     
        List<Order> os= orderService.list();
     
        int total = (int) new PageInfo<>(os).getTotal();
        page.setTotal(total);
     
        orderItemService.fill(os);
     
        model.addAttribute("os", os);
        model.addAttribute("page", page);
     
        return "admin/listOrder";
    }

### 发货功能 ###

当订单状态是waitDelivery的时候，就会出现发货按钮  
1. 发货按钮链接跳转到admin\_order\_delivery  
2. OrderController.delivery()方法被调用  
2.1 注入订单对象  
2.2 修改发货时间，设置发货状态  
2.3 更新到数据库  
2.4 客户端跳转到admin\_order\_list页面

@RequestMapping("admin_order_delivery")
    public String delivery(Order o) throws IOException {
        o.setDeliveryDate(new Date());
        o.setStatus(OrderService.waitConfirm);
        orderService.update(o);
        return "redirect:admin_order_list";
    }

OrderController.java完整代码

package com.how2java.tmall.controller;
     
    import java.io.IOException;
    import java.util.Date;
    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 com.github.pagehelper.PageHelper;
    import com.github.pagehelper.PageInfo;
    import com.how2java.tmall.pojo.Order;
    import com.how2java.tmall.service.OrderItemService;
    import com.how2java.tmall.service.OrderService;
    import com.how2java.tmall.util.Page;
     
    @Controller
    @RequestMapping("")
    public class OrderController {
        @Autowired
        OrderService orderService;
        @Autowired
        OrderItemService orderItemService;
     
        @RequestMapping("admin_order_list")
        public String list(Model model, Page page){
            PageHelper.offsetPage(page.getStart(),page.getCount());
     
            List<Order> os= orderService.list();
     
            int total = (int) new PageInfo<>(os).getTotal();
            page.setTotal(total);
     
            orderItemService.fill(os);
     
            model.addAttribute("os", os);
            model.addAttribute("page", page);
     
            return "admin/listOrder";
        }
     
        @RequestMapping("admin_order_delivery")
        public String delivery(Order o) throws IOException {
            o.setDeliveryDate(new Date());
            o.setStatus(OrderService.waitConfirm);
            orderService.update(o);
            return "redirect:admin_order_list";
        }
    }

最后，在JSP上显示出来，就完成了订单管理的开发

listOrder.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
             pageEncoding="UTF-8" import="java.util.*"%>
     
    <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
    <%@include file="../include/admin/adminHeader.jsp"%>
    <%@include file="../include/admin/adminNavigator.jsp"%>
     
    <script>
        $(function(){
            $("button.orderPageCheckOrderItems").click(function(){
                var oid = $(this).attr("oid");
                $("tr.orderPageOrderItemTR[oid="+oid+"]").toggle();
            });
        });
     
    </script>
     
    <title>订单管理</title>
     
    <div class="workingArea">
        <h1 class="label label-info" >订单管理</h1>
        <br>
        <br>
     
        <div class="listDataTableDiv">
            <table class="table table-striped table-bordered table-hover1  table-condensed">
                <thead>
                <tr class="success">
                    <th>ID</th>
                    <th>状态</th>
                    <th>金额</th>
                    <th width="100px">商品数量</th>
                    <th width="100px">买家名称</th>
                    <th>创建时间</th>
                    <th>支付时间</th>
                    <th>发货时间</th>
                    <th>确认收货时间</th>
                    <th width="120px">操作</th>
                </tr>
                </thead>
                <tbody>
                <c:forEach items="${os}" var="o">
                    <tr>
                        <td>${o.id}</td>
                        <td>${o.statusDesc}</td>
                        <td>￥<fmt:formatNumber type="number" value="${o.total}" minFractionDigits="2"/></td>
                        <td align="center">${o.totalNumber}</td>
                        <td align="center">${o.user.name}</td>
     
                        <td><fmt:formatDate value="${o.createDate}" pattern="yyyy-MM-dd HH:mm:ss"/></td>
                        <td><fmt:formatDate value="${o.payDate}" pattern="yyyy-MM-dd HH:mm:ss"/></td>
                        <td><fmt:formatDate value="${o.deliveryDate}" pattern="yyyy-MM-dd HH:mm:ss"/></td>
                        <td><fmt:formatDate value="${o.confirmDate}" pattern="yyyy-MM-dd HH:mm:ss"/></td>
     
                        <td>
                            <button oid=${o.id} class="orderPageCheckOrderItems btn btn-primary btn-xs">查看详情</button>
     
                            <c:if test="${o.status=='waitDelivery'}">
                                <a href="admin_order_delivery?id=${o.id}">
                                    <button class="btn btn-primary btn-xs">发货</button>
                                </a>
                            </c:if>
                        </td>
                    </tr>
                    <tr class="orderPageOrderItemTR"  oid=${o.id}>
                        <td colspan="10" align="center">
     
                            <div  class="orderPageOrderItem">
                                <table width="800px" align="center" class="orderPageOrderItemTable">
                                    <c:forEach items="${o.orderItems}" var="oi">
                                        <tr>
                                            <td align="left">
                                                <img width="40px" height="40px" src="img/productSingle/${oi.product.firstProductImage.id}.jpg">
                                            </td>
     
                                            <td>
                                                <a href="foreproduct?pid=${oi.product.id}">
                                                    <span>${oi.product.name}</span>
                                                </a>
                                            </td>
                                            <td align="right">
     
                                                <span class="text-muted">${oi.number}个</span>
                                            </td>
                                            <td align="right">
     
                                                <span class="text-muted">单价：￥${oi.product.promotePrice}</span>
                                            </td>
     
                                        </tr>
                                    </c:forEach>
     
                                </table>
                            </div>
     
                        </td>
                    </tr>
                </c:forEach>
                </tbody>
            </table>
        </div>
     
        <div class="pageDiv">
            <%@include file="../include/admin/adminPage.jsp" %>
        </div>
     
    </div>
     
    <%@include file="../include/admin/adminFooter.jsp"%>

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MTg2Njk2MA_size_16_color_FFFFFF_t_70]: /images/20220411/aaab763d08fd48d08cfab5acb87dd855.png
[http_127.0.0.1_8080_tmall_ssm_admin_order_list]: http://127.0.0.1:8080/tmall_ssm/admin_order_list