用struts+mysql实现的在线拍卖系统

package j2eebbs; import java.sql.ResultSet; import java.util.Date; import java.util.Vector; public class Product { private int id; private String name; private String introduce;//介绍 private String image;//图片 private int type;//产品类型 private Date submitDate ;//发布产品时间 private int endTime ;//过期时间,单位为天 比如 1天，2天 private int price ;//初始价格 private int status = 1 ;//产品状态 1未审核 2审核通过 public int getId() { return id; } public void setId(int id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getIntroduce() { return introduce; } public void setIntroduce(String introduce) { this.introduce = introduce; } public String getImage() { return image; } public void setImage(String image) { this.image = image; } public int getType() { return type; } public void setType(int type) { this.type = type; } public Date getSubmitDate() { return submitDate; } public void setSubmitDate(Date submitDate) { this.submitDate = submitDate; } public int getEndTime() { return endTime; } public void setEndTime(int endTime) { this.endTime = endTime; } public int getPrice() { return price; } public void setPrice(int price) { this.price = price; } public int getStatus() { return status; } public void setStatus(int status) { this.status = status; } public Product( String name, String introduce, String image, int type, int endTime, int price) { super(); this.name = name; this.introduce = introduce; this.image = image; this.type = type; this.endTime = endTime; this.price = price; } public Product() { // TODO Auto-generated constructor stub } public static Vector search(DB db) throws Exception { Vector productVector = new Vector(); ResultSet rs; String strSql; strSql = "select * from product"; rs = db.OpenSql(strSql); while (rs.next()) { Product product = new Product(); product.setId(rs.getInt("id")); product.setImage(rs.getString("image")); product.setIntroduce(rs.getString("introduce")); product.setName(rs.getString("name")); product.setPrice(rs.getInt("price")); product.setStatus(rs.getInt("status")); product.setSubmitDate(rs.getDate("submitDate")); product.setType(rs.getInt("type")); product.setEndTime(rs.getInt("endtime")); productVector.add(product); } return productVector; } public static Vector getUserProduct(DB db,int userid) throws Exception { Vector productVector = new Vector(); ResultSet rs; String strSql; strSql = "select * from product where userid="+userid; rs = db.OpenSql(strSql); while (rs.next()) { Product product = new Product(); product.setId(rs.getInt("id")); product.setImage(rs.getString("image")); product.setIntroduce(rs.getString("introduce")); product.setName(rs.getString("name")); product.setPrice(rs.getInt("price")); product.setStatus(rs.getInt("status")); product.setSubmitDate(rs.getDate("submitDate")); product.setType(rs.getInt("type")); product.setEndTime(rs.getInt("endtime")); productVector.add(product); } return productVector; } public boolean insert(DB db) throws Exception { String strSql; strSql = "insert into product(name,introduce,type,endtime,submitDate,price,image,status)values" + "('" + name + "','" + introduce + "','"+ type + "','"+ endTime + "','"+ submitDate + "','"+ price + "','"+ image + "','"+ status+"')"; if (db.ExecSql(strSql) == 0) { return false; } else { return true; } } public static boolean delete(DB db, int id) throws Exception { String strSql; strSql = "delete from product where id=" + id; if (db.ExecSql(strSql) == 0) { return false; } else { return true; } } }