购物车订单管理_${yesterdayorders.amount} 报错-CSDN博客

本文链接：https://blog.csdn.net/m0_60375943/article/details/120694369

本文展示了如何作为卖家使用JSP进行订单管理，包括订单查询、修改订单状态等操作。同时，介绍了买家端的功能，如发货、撤单和签收。代码示例涉及了DAO和Action层的实现。

摘要由CSDN通过智能技术生成

我是卖家

JSP

orderDao

package com.hmf.dao;

import java.util.Date;
import java.util.List;

import com.hmf.entity.Order;
import com.zking.util.BaseDao;
import com.zking.util.PageBean;

public class OrderDao extends BaseDao<Order>{

   public void add(Order t) throws Exception {
       String sql= " insert into t_easyui_order(uid,orderTime,consignee,phone,postalcode,address,sendType,sendTime,orderPrice,orderState) values(?,now(),?,?,?,?,?,?,?,?)";
       super.executeUpdate(sql, t, new String[] {"uid","consignee","phone","postalcode","address","sendType","sendTime","orderPrice","orderState"});
   }

   /**s
   *v订单查询倒序
   * @param order
   * @param pageBean
   * @return
   * @throws Exception
   */
   public List<Order> list(Order order, PageBean pageBean) throws Exception {
       //String sql = " select * from t_easyui_order order by orderTime desc";
       String sql = " select * from t_easyui_order where 1=1";
       long id =order.getId();
       if(id!=0) {
           sql += " and id = " + id;
       }
       int orderState = order.getOrderState();
       if(orderState != 0) {
           sql += " and orderState = " + orderState;
       }
       sql += " order by orderTime desc";
       return super.executeQuery(sql, Order.class, pageBean);
   }

   /**
   * 修改订单
   * @param t
   * @throws Exception
   */
   public void editState(Order t) throws Exception {
       String sql= " update t_easyui_order set orderState=? where id=?";
       int orderState = t.getOrderState();