orderimpl.java

jsp+servlet网上购物,是一个实现mvc的网站

package com.ebook.impl;

import com.ebook.dao.*;
import com.ebook.Entity.*;
import java.sql.*;
import java.text.SimpleDateFormat;
import java.util.ArrayList;

/**
 *
 * @author 隆科
 */
public class OrderImpl implements OrderDao {

    Connection con;

    public OrderImpl(Connection con) {
        this.con = con;
    }

    public void addOrder(Order order) throws Exception {
        PreparedStatement pstm;
        String sql = "insert into Order_info(Userid,Orderdate,PostName,PostTel,PostNumber,PostAdress) values(?,?,?,?,?,?)";
        pstm = con.prepareStatement(sql);
        pstm.setInt(1, order.getUserId());
        pstm.setString(2, getDate());
        pstm.setString(3, order.getPostName());
        pstm.setString(4, order.getPostTel());
        pstm.setString(5, order.getPostNumber());
        pstm.setString(6, order.getPostAdress());
        pstm.executeUpdate();
    }

    public String getDate() {
        SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
        String time = df.format(new java.util.Date());
        return time;
    }
     public ArrayList findOrder(int userid) throws Exception
     {
         ArrayList list=new ArrayList();
         PreparedStatement pstm;
         String sql="select* from order_info where Userid=?";
         pstm=con.prepareStatement(sql);
         pstm.setInt(1, userid);
         ResultSet rs=pstm.executeQuery();
         while(rs.next())
         {
             Order order=new Order();
             order.setOrderId(rs.getInt("Orderid"));
             order.setUserId(rs.getInt("Userid"));
             order.setOrderDate(rs.getString("Orderdate"));
             order.setPostName(rs.getString("PostName"));
             order.setPostTel(rs.getString("PostTel"));
             order.setPostNumber(rs.getString("PostNumber"));
             order.setPostAdress(rs.getString("PostAdress"));
             order.setStatus(rs.getString("stauts"));
             list.add(order);
         }
         return list;
     }
     public ArrayList showOrder() throws Exception
     {
         ArrayList list=new ArrayList();
         PreparedStatement pstm;
         String sql="select* from order_info";
         pstm=con.prepareStatement(sql);
         ResultSet rs=pstm.executeQuery();
         while(rs.next())
         {
             Order order=new Order();
             order.setOrderId(rs.getInt("Orderid"));
             order.setUserId(rs.getInt("Userid"));
             order.setOrderDate(rs.getString("Orderdate"));
             order.setPostName("PostName");
             order.setPostTel(rs.getString("PostTel"));
             order.setPostNumber(rs.getString("PostNumber"));
             order.setPostAdress(rs.getString("PostAdress"));
             list.add(order);
         }
         return list;
     }
      public void updateOrder(int orderid) throws Exception
      {
         PreparedStatement pstm;
         String sql="update order_info set stauts='已处理' where Orderid=?";
         pstm=con.prepareStatement(sql);
         pstm.setInt(1, orderid);
         pstm.executeUpdate();
      }
}