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

package operation; 
 
import java.sql.ResultSet; 
import java.sql.SQLException; 
import java.util.ArrayList; 
import java.util.Date; 
 
import dataBase.DataBase; 
import entity.ProductCheckView; 
 
public class ProductCheckViewOperation 
{ 
	private ResultSet rs = null; 
 
	private ArrayList list = null; 
 
	private String sql = ""; 
 
	private DataBase db = null; 
 
	public ProductCheckViewOperation() 
	{ 
		db = new DataBase(); 
	} 
	public ArrayList getProductCheckViewArrayList() 
	{ 
		list = new ArrayList(); 
		String sql = "select * from productinfoview"; 
		try 
		{ 
			rs = db.getResult(sql); 
			while(rs.next()) 
			{ 
				int productID = rs.getInt("ProductID"); 
				int providerID = rs.getInt("ProviderID"); 
				String productName = rs.getString("ProductName"); 
				String productSign = rs.getString("ProductSign"); 
				String productType = rs.getString("ProductType"); 
				String productRegulate = rs.getString("ProductRegulate"); 
				String productTax = rs.getString("ProductTax"); 
				String productPlace = rs.getString("ProductPlace"); 
				String productNotice=rs.getString("ProductNotice"); 
				String providerName=rs.getString("ProviderName"); 
 
				ProductCheckView productcheckview=new ProductCheckView(productID,providerID,productName, 
						productSign, productType,productRegulate, 
						 productTax, productPlace,productNotice, 
						providerName); 
 
				list.add(productcheckview);// 将entercheck的对象添加到list中。 
			} 
			rs.close(); 
			db.close();// 关闭DB中的Conn. 
			return list; 
 
		} catch (SQLException e) 
		{ 
			// TODO Auto-generated catch block 
			e.printStackTrace(); 
			System.out.println("getProductCheckViewArrayList 出错！"); 
		} 
		return null; 
	} 
 
	public void close(ResultSet rs) 
	{ 
		try 
		{ 
			rs.close(); 
		} catch (SQLException e) 
		{ 
			System.out.println("rs和stmt已经关闭，但conn没有关闭"); 
		} 
	} 
 
}