5087e4b99c0a001c1ab6bb783faf21cc

一个自行开发的网上商店一个自行开发的网上商店一个自行开发的网上商店

package com.car.bean;
import java.sql.*;
import java.util.*;
import com.database.*;
public class Productbean {
	private int productclickcount=0;
	private String productid="";
	private String psortid="";
	private String pbrandid="";
	private String productname="";
	private String unit="";
	private String spec="";
	private String colour="";
	private String image1="";
	private String image2="";
	private String image3="";
	private int amout=0;
	private int productpoint=0;
	private String remark="";
	private double marketprice=0.0;
	private double memberprice=0.0;
	private int salecount=0;
	private Connection conn=null;
	private ResultSet rs=null;
	private PreparedStatement stmt=null;
	DBconn dbcon=new DBconn();
	public int getProductclickcount() {
		return productclickcount;
	}
	public void setProductclickcount(int productclickcount) {
		this.productclickcount = productclickcount;
	}
	public int getAmout() {
		return amout;
	}
	public void setAmout(int amout) {
		this.amout = amout;
	}
	public String getColour() {
		return colour;
	}
	public void setColour(String colour) {
		this.colour = colour;
	}
	public String getImage1() {
		return image1;
	}
	public void setImage1(String image1) {
		this.image1 = image1;
	}
	public String getImage2() {
		return image2;
	}
	public void setImage2(String image2) {
		this.image2 = image2;
	}
	public String getImage3() {
		return image3;
	}
	public void setImage3(String image3) {
		this.image3 = image3;
	}
	public double getMarketprice() {
		return marketprice;
	}
	public void setMarketprice(double marketprice) {
		this.marketprice = marketprice;
	}
	public double getMemberprice() {
		return memberprice;
	}
	public void setMemberprice(double memberprice) {
		this.memberprice = memberprice;
	}
	public String getPbrandid() {
		return pbrandid;
	}
	public void setPbrandid(String pbrandid) {
		this.pbrandid = pbrandid;
	}
	public String getProductid() {
		return productid;
	}
	public void setProductid(String productid) {
		this.productid = productid;
	}
	public String getProductname() {
		return productname;
	}
	public void setProductname(String productname) {
		this.productname = productname;
	}
	public int getProductpoint() {
		return productpoint;
	}
	public void setProductpoint(int productpoint) {
		this.productpoint = productpoint;
	}
	public String getPsortid() {
		return psortid;
	}
	public void setPsortid(String psortid) {
		this.psortid = psortid;
	}
	public String getRemark() {
		return remark;
	}
	public void setRemark(String remark) {
		this.remark = remark;
	}
	public int getSalecount() {
		return salecount;
	}
	public void setSalecount(int salecount) {
		this.salecount = salecount;
	}
	public String getSpec() {
		return spec;
	}
	public void setSpec(String spec) {
		this.spec = spec;
	}
	public String getUnit() {
		return unit;
	}
	public void setUnit(String unit) {
		this.unit = unit;
	}
	public ArrayList getProduct(String sql){
		ArrayList result=new ArrayList();
		try{
			conn=dbcon.getConnect();
			stmt=conn.prepareStatement(sql);
			rs=stmt.executeQuery();
			while(rs.next()){
				Productbean product=new Productbean();
				product.setProductid(String.valueOf(rs.getInt(1)));
				product.setPsortid(String.valueOf(rs.getInt(2)));
				product.setPbrandid(String.valueOf(rs.getInt(3)));
				product.setProductname(rs.getString(4));
				product.setUnit(rs.getString(5));
				product.setSpec(rs.getString(6));
				product.setColour(rs.getString(7));
				product.setImage1(rs.getString(8));
				product.setImage2(rs.getString(9));
				product.setImage3(rs.getString(10));
				product.setAmout(rs.getInt(11));
				product.setProductpoint(rs.getInt(12));
				product.setProductclickcount(rs.getInt(13));
				product.setRemark(rs.getString(14));
				product.setMarketprice(rs.getDouble(15));
				product.setMemberprice(rs.getDouble(16));
				product.setSalecount(rs.getInt(17));
				result.add(product);
			}
			rs.close();
			stmt.close();
			conn.close();
		}
		catch(Exception e){
			e.printStackTrace();
		}
		
		
		return result;
		
	}
		
	}