www.pudn.com > BeiJie.rar > ProductCheckOper.java

package operation; 
 
import java.sql.ResultSet; 
import java.util.ArrayList; 
import java.util.Collection; 
 
import dataBase.DataBase; 
import entity.ProductInfo; 
 
public class ProductCheckOper 
{ 
	private DataBase db = null; 
	 
	 
	public ProductCheckOper() 
	{ 
		db = new DataBase(); 
	} 
	 
	public void close() 
	{ 
		db.close(); 
	} 
	 
	public Collection getProductInfo() 
	{ 
		try 
		{ 
			Collection ret = new ArrayList(); 
			String sql = "select * from productinfo"; 
			ResultSet rs = db.getResult(sql); 
			while(rs.next()) 
			{ 
				ProductInfo productinfo = new ProductInfo(); 
				productinfo.setProductId(rs.getInt("ProductID")); 
				productinfo.setProviderId(rs.getInt("ProviderID")); 
				productinfo.setProductName(rs.getString("ProductName")); 
				productinfo.setProductSign(rs.getString("ProductSign")); 
				productinfo.setProductType(rs.getString("ProductType")); 
				productinfo.setProductRegulate(rs.getString("ProductRegulate")); 
				productinfo.setProductTex(rs.getString("ProductTax")); 
				productinfo.setProductPlace(rs.getString("ProductPlace")); 
				productinfo.setProductNotice(rs.getString("ProductNotice")); 
				ret.add(productinfo); 
				 
			} 
			return ret; 
			 
		} 
		catch(Exception e) 
		{ 
			e.printStackTrace(); 
			return null; 
		} 
	} 
}