detailinfo.java

网上商城

package store;
import java.sql.*;
import java.util.*;
public class DetailInfo {
  public DetailInfo(){
      }
  public ProInfo getProDetailInfo(int pid) throws Exception {
    DBConn conn=new DBConn();
    ProInfo PI=new ProInfo();
    String sql="SELECT * FROM product WHERE id="+pid;
    ResultSet rs2=conn.query(sql);
     if(rs2.next()){
      PI.setId(rs2.getInt("id"));
      PI.setSort(rs2.getInt("sort"));
      PI.setPname(rs2.getString("pname"));
      PI.setProvider(rs2.getString("provider"));
      PI.setStock(rs2.getInt("stock"));
      PI.setPrice(rs2.getFloat("price"));
      PI.setSold(rs2.getInt("sold"));
      PI.setSinfo(rs2.getString("sinfo"));
      PI.setInfo(rs2.getString("info"));
      PI.setImage(rs2.getString("image"));
     }
    rs2.close();
    conn.DBclose();
    return PI;
  }
  public Vector getCommentary(int pid) throws Exception {
    DBConn conn=new DBConn();
    Vector vc=new Vector();
    String sql1="SELECT * FROM commentary WHERE pid="+pid;
    ResultSet rs1=conn.query(sql1);
    while(rs1.next()){
      CommentInfo CI = new CommentInfo();
      CI.setCid(rs1.getInt("id"));
      CI.setPid(rs1.getInt("pid"));
      CI.setCustomer(rs1.getString("customer"));
      CI.setContent(rs1.getString("content"));
      CI.setIp(rs1.getString("ip"));
      CI.setCtime(rs1.getString("time"));
      vc.add(CI);
      CI=null;
    }
    rs1.close();
    conn.DBclose();
    return vc;
  }
}