案例29-购物车提交订单

1 案例分析

1 订单分析1

2 订单分析2

3 订单的业务操作

2 代码实现

1 cart.jsp代码修改

<a href="${pageContext.request.contextPath }/product?method=submitOrder">
     <input type="button" width="100" value="提交订单" name="submit" border="0" style="background: url('./images/register.gif') no-repeat scroll 0 0 rgba(0, 0, 0, 0);
      height:35px;width:100px;color:white;">
</a>

2 ProductServlet代码

// 8 提交订单  submitOrder
public void submitOrder(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    
    HttpSession session = request.getSession();
    
    //首先需要判断用户是否登录
    User user = (User) session.getAttribute("user");
    if(user==null){
        //如果用户没有登录的话，就重定向到登录页面
        response.sendRedirect(request.getContextPath()+"/login.jsp");
        //不在执行继续执行之后的代码
        return;
    }
    
    
    //目的：封装好一个Order对象 传递给service层
    Order order = new Order();
    // 1 private String oid; //该订单的编号
    String oid = CommonsUtils.getUUID();
    order.setOid(oid);
    
    // 2 private Date ordertime ; //下单时间
    order.setOrdertime(new Date());
    
    // 3 private double total; //该订单的总金额
      //首先应该获得session中的购物车Cart对象
    Cart cart = (Cart) session.getAttribute("cart");
    double total = 0.0;
    if(cart!=null){
        total = cart.getTotal();
    }
    order.setTotal(total);
    
    // 4 private int state ; //该订单的支付状态 1代表已付款 0代表未付款
    order.setState(0);
    
    // 5 private String address; //收获地址
    order.setAddress(null);
    // 6 private String name; //姓名
    order.setName(null);
    // 7 private String telephone; //电话
    order.setTelephone(null);
    
    // 8 private User user;//该订单属于哪个用户
    order.setUser(user);
    
    // 9 该订单中有多少订单项
      //从购物车中获取所有的cartItem
    Map<String, CartItem> cartItems = cart.getCartItems();
    //遍历所有的购物车项，加入到订单项orderItem中
    for(Map.Entry<String, CartItem> entry:cartItems.entrySet()){
        //取出里面的每一个购物项
        CartItem cartItem = entry.getValue();
        
        // 创建新的订单项
        OrderItem orderItem = new OrderItem();
        
        // 1)private String itemid; //订单项
        orderItem.setItemid(CommonsUtils.getUUID());
        // 2)private int count; //订单项内商品的购买数量
        orderItem.setCount(cartItem.getBuyNum());
        // 3)private double subtotal; //订单项小计
        orderItem.setSubtotal(cartItem.getSubtotal());
        // 4)private  Product product; //订单项内的商品
        orderItem.setProduct(cartItem.getProduct());
        // 5)private Order order; //该订单项属于哪个订单
        orderItem.setOrder(order);
        
        //将该订单项添加到订单的订单项集合中
        order.getOrderItems().add(orderItem);
    }
    
     //order对象封装完毕
    //传递数据到service层
    ProductService service = new ProductService();
    service.submitOrder(order);
    
    session.setAttribute("order", order);
    
    //页面跳转
    response.sendRedirect(request.getContextPath()+"/order_info.jsp");
    
}

3 ProductService代码

//订单提交 将订单的数据和订单项的数据存储到数据库中
public void submitOrder(Order order) {
    ProductDao dao = new ProductDao();
    
    
    try {
        // 1 、开启事务
        C3P0Utils.startTransaction();
        
        //2、调用dao存储order表数据的方法
        boolean isaddOrdersSuccess = false;
        int rowAddOrders = dao.addOrders(order);
        if(rowAddOrders>0){
            isaddOrdersSuccess = true;
        }
        
        //3、调用dao存储orderItem表数据的方法
        boolean isaddOrderItemSuccess = false;
        int rowAddOrderItem = dao.addOrderItems(order);
        if(rowAddOrderItem>0){
            isaddOrderItemSuccess = true;
        }
        
        //只要有一项操作不成功就回滚。
        if(!isaddOrdersSuccess&&isaddOrderItemSuccess){
            C3P0Utils.rollback();
        }
        
    } catch (SQLException e) {
        try {
            C3P0Utils.rollback();
        } catch (SQLException e1) {
            
            e1.printStackTrace();
        }
        e.printStackTrace();
    }finally {
        //无论是否成功都提交并且释放资源
        try {
            C3P0Utils.commitAndRelease();
        } catch (SQLException e) {
            
            e.printStackTrace();
        }
    }
}

4 ProductDao代码

// 向orders表中插入数据
public int addOrders(Order order) throws SQLException {
    QueryRunner qr = new QueryRunner();
    String sql ="insert into orders values (?,?,?,?,?,?,?,?)";
    Connection conn = C3P0Utils.getConnection();
    int rowAddOrders = qr.update(conn,sql, order.getOid(),order.getOrdertime(),order.getTotal(),order.getState(),
            order.getAddress(),order.getName(),order.getTelephone(),order.getUser().getUid());
    return rowAddOrders;
}


// 向orderitem表插入数据
public int addOrderItems(Order order) throws SQLException {
    QueryRunner qr = new QueryRunner();
    String sql ="insert into orderItem values (?,?,?,?,?)";
    Connection conn = C3P0Utils.getConnection();
    List<OrderItem> orderItems = order.getOrderItems();
    int rowAddOrderItem = 0;
    for (OrderItem item : orderItems) {
        rowAddOrderItem += qr.update(conn, sql,item.getItemid(),item.getCount(),
                item.getSubtotal(),item.getProduct().getPid(),
                item.getOrder().getOid());
    }
    return rowAddOrderItem;
}

5 order_info.jsp修改代码

<table class="table table-bordered">
    <tbody>
        <tr class="warning">
            <th colspan="5">订单编号:${order.oid }</th>
        </tr>
        <tr class="warning">
            <th>图片</th>
            <th>商品</th>
            <th>价格</th>
            <th>数量</th>
            <th>小计</th>
        </tr>
        
        <c:forEach items="${order.orderItems }" var="orderItem">
        
            <tr class="active">
                <td width="60" width="40%">
                    <img src="${pageContext.request.contextPath }/${orderItem.product.pimage}" width="70" height="60">
                </td>
                <td width="30%"><a target="_blank">${orderItem.product.pname}</a></td>
                <td width="20%">￥${orderItem.product.shop_price}</td>
                <td width="10%">${orderItem.count}</td>
                <td width="15%"><span class="subtotal">￥${orderItem.subtotal }</span></td>
            </tr>
        </c:forEach> 
    </tbody>
</table>

3 domain部分

1 orderItem

package www.test.domain;

public class OrderItem {

    /*`itemid` varchar(32) NOT NULL,
      `count` int(11) DEFAULT NULL,
      `subtotal` double DEFAULT NULL,
      `pid` varchar(32) DEFAULT NULL,
      `oid` varchar(32) DEFAULT NULL*/
    
    private String itemid;//订单项的id
    private int count;//订单项内商品的购买数量
    private double subtotal;//订单项小计
    private Product product;//订单项内部的商品
    private Order order;//该订单项属于哪个订单
    
    
    public String getItemid() {
        return itemid;
    }
    public void setItemid(String itemid) {
        this.itemid = itemid;
    }
    public int getCount() {
        return count;
    }
    public void setCount(int count) {
        this.count = count;
    }
    public double getSubtotal() {
        return subtotal;
    }
    public void setSubtotal(double subtotal) {
        this.subtotal = subtotal;
    }
    public Product getProduct() {
        return product;
    }
    public void setProduct(Product product) {
        this.product = product;
    }
    public Order getOrder() {
        return order;
    }
    public void setOrder(Order order) {
        this.order = order;
    }
    
}

2 order

package www.test.domain;

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

public class Order {

    /*`oid` varchar(32) NOT NULL,
      `ordertime` datetime DEFAULT NULL,
      `total` double DEFAULT NULL,
      `state` int(11) DEFAULT NULL,
      `address` varchar(30) DEFAULT NULL,
      `name` varchar(20) DEFAULT NULL,
      `telephone` varchar(20) DEFAULT NULL,
      `uid` varchar(32) DEFAULT NULL*/
    
    private String oid;//该订单的订单号
    private Date ordertime;//下单时间
    private double total;//该订单的总金额
    private int state;//订单支付状态 1代表已付款 0代表未付款
    
    private String address;//收货地址
    private String name;//收货人
    private String telephone;//收货人电话
    
    private User user;//该订单属于哪个用户
    
    //该订单中有多少订单项
    List<OrderItem> orderItems = new ArrayList<OrderItem>();
    
    

    public String getOid() {
        return oid;
    }

    public void setOid(String oid) {
        this.oid = oid;
    }

    public Date getOrdertime() {
        return ordertime;
    }

    public void setOrdertime(Date ordertime) {
        this.ordertime = ordertime;
    }

    public double getTotal() {
        return total;
    }

    public void setTotal(double total) {
        this.total = total;
    }

    public int getState() {
        return state;
    }

    public void setState(int state) {
        this.state = state;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getTelephone() {
        return telephone;
    }

    public void setTelephone(String telephone) {
        this.telephone = telephone;
    }

    public User getUser() {
        return user;
    }

    public void setUser(User user) {
        this.user = user;
    }

    public List<OrderItem> getOrderItems() {
        return orderItems;
    }

    public void setOrderItems(List<OrderItem> orderItems) {
        this.orderItems = orderItems;
    }

}