listorder.java

网上商城

package store;
import java.sql.*;
import java.util.*;
public class ListOrder {
  public ListOrder(){
      }
  /*getOdersInfo()方法，获取多个订单信息。
   *参数为customerid，此时结果为多个记录集
   */
   DBConn conn=new DBConn();
  public Vector getOrdersInfo(int customerid) throws Exception {
    Vector vc=new Vector();
    String  sql="SELECT * FROM orders WHERE isorder=1 AND customerid="+customerid;
    ResultSet rs=conn.query(sql);
    while(rs.next()){
       OrderInfo OI = new OrderInfo();
       OI.setOrderid(rs.getInt("orderid"));
       OI.setCustomerid(rs.getInt("customerid"));
       OI.setQuantity(rs.getInt("quantity"));
       OI.setPrice(rs.getFloat("price"));
       OI.setSubmittime(rs.getString("time"));
       OI.setDelivery(rs.getInt("delivery"));
       OI.setPayment(rs.getInt("payment"));
       OI.setStatus(rs.getInt("status"));
       vc.add(OI);
    }
    rs.close();
    conn.DBclose();
    return vc;
  }
  /*getOderInfo()方法，获取单个订单信息。
   *参数为orderid，此时结果为一个记录集
   */
  public OrderInfo getOrderInfo(int orderid) throws Exception {
   OrderInfo OI = new OrderInfo();
   String  sql="SELECT * FROM orders WHERE isorder=1 AND orderid="+orderid;
   ResultSet rs1=conn.query(sql);
   if(rs1.next()){

      OI.setOrderid(rs1.getInt("orderid"));
      OI.setCustomerid(rs1.getInt("customerid"));
      OI.setQuantity(rs1.getInt("quantity"));
      OI.setPrice(rs1.getFloat("price"));
      OI.setSubmittime(rs1.getString("time"));
      OI.setDelivery(rs1.getInt("delivery"));
      OI.setPayment(rs1.getInt("payment"));
      OI.setStatus(rs1.getInt("status"));
   }
   rs1.close();
   conn.DBclose();
   return OI;
 }

}