www.pudn.com > BuyFlowers.rar > ProduceBean.java

package com.qrsx.buyflowers.beans; 
 
import java.sql.PreparedStatement; 
import java.sql.ResultSet; 
import java.sql.SQLException; 
import java.util.ArrayList; 
import java.util.Collection; 
 
public class ProduceBean extends DBConnection{ 
//	 声明实体 
	private ProduceClass produceClass; 
 
	private PreparedStatement ptst; 
 
	private ResultSet rs; 
 
	private Collection collection; 
 
 
 
	public ProduceBean() throws ClassNotFoundException, SQLException { 
		super(); 
		// TODO Auto-generated constructor stub 
	} 
	public Collection getAllProduce(){ 
		String sql="select * from produce"; 
		try { 
			ptst=con.prepareStatement(sql); 
			rs=ptst.executeQuery(); 
			collection=new ArrayList(); 
			while(rs.next()){ 
				produceClass=new ProduceClass(); 
				produceClass.setProduceId(rs.getString("produceId")); 
				produceClass.setProduceName(rs.getString("produceName")); 
				collection.add(produceClass); 
			} 
		} catch (SQLException e) { 
			// TODO Auto-generated catch block 
			e.printStackTrace(); 
		} 
		 
		return collection; 
	} 
	 
	// 按ID查询厂商 
	public Collection getProduceByProduceId(String produceId) { 
		String sql = "select * from produceDetails where produceId=?;"; 
            ProduceDetailsClass pd=null; 
		try { 
 
			ptst = con.prepareStatement(sql); 
			ptst.setString(1, produceId); 
			rs = ptst.executeQuery(); 
			collection = new ArrayList(); 
			while (rs.next()) { 
				pd = new ProduceDetailsClass(); 
				pd.setProduceId(rs.getString("produceId")); 
			   pd.setProduceName(rs.getString("produceName")); 
				pd.setGoodsId(rs.getString("goodsId")); 
				pd.setSortId(rs.getString("sortId")); 
				collection.add(pd); 
			} 
		} catch (SQLException e) { 
			// TODO Auto-generated catch block 
			e.printStackTrace(); 
		} 
 
		return collection; 
	} 
}