deliveryinfo.java

来自「一个用java开发的网上购物系统。基本功能都是可以实现的」· Java 代码 · 共 58 行

package store;
import java.sql.*;
import java.util.*;
public class DeliveryInfo {
  private int did=0;
  private String description;
  private int fee=0;
  private ResultSet rs=null;
  DBConn conn = new DBConn();
  public DeliveryInfo(){
  }
  public void setDid(int id){
    this.did=id;
  }
  public int getDid(){
    return did;
      }
  public void setDescription(String des){
    this.description=des;
  }
  public String getDescription(){
    return description;
  }
  public void setFee(int fee){
    this.fee=fee;
  }
  public String getDescription(int did)throws Exception{
    try{
     String sql = "SELECT * FROM delivery WHERE id=" + did;
     rs = conn.query(sql);
     rs.next();
     description=rs.getString(2);
     fee=rs.getInt(3);
   }
   catch(Exception e){
     System.out.print(e.toString());
   }
    return description;
  }
  public int getFee()throws Exception {
    return fee;
  }
  public Vector ListDelivery()throws Exception{
    Vector ve=new Vector();
    String sql2="SELECT * FROM delivery";
    rs=conn.query(sql2);
    while(rs.next()){
      DeliveryInfo DI=new DeliveryInfo();
      DI.setDid(rs.getInt("id"));
      DI.setDescription(rs.getString("description"));
      DI.setFee(rs.getInt("fee"));
      ve.add(DI);
    }
    return ve;

  }
}