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

package operation; 
 
import java.sql.ResultSet; 
import java.sql.SQLException; 
import java.util.ArrayList; 
 
import dataBase.DataBase; 
import entity.StockCheckView; 
 
public class StockCheckViewOperation 
{ 
	private ResultSet rs = null; 
 
	private ArrayList list = null; 
 
	private String sql = ""; 
 
	private DataBase db = null; 
 
	public StockCheckViewOperation() 
	{ 
		db = new DataBase(); 
	} 
	 
	public ArrayList  getStockArrayList() 
	{ 
		list = new ArrayList(); 
		String sql = "select * from stockinfoview"; 
		try 
		{ 
			rs = db.getResult(sql); 
			while(rs.next()) 
			{ 
					int stockID=rs.getInt("StockID"); 
					int   productID=rs.getInt("ProductID"); 
					int  productQuatity=rs.getInt("ProductQuantity"); 
					String productName=rs.getString("ProductName"); 
					String  productType=rs.getString("ProductType"); 
					String productRegulate=rs.getString("ProductRegulate"); 
					String productTax=rs.getString("ProductTax"); 
					String  productNotice=rs.getString("ProductNotice"); 
					StockCheckView stockcheckview=new StockCheckView(stockID,productID,productQuatity, 
							productName,productType,productRegulate, 
							productTax, productNotice); 
					list.add(stockcheckview); 
			} 
			rs.close(); 
			db.close();// 关闭DB中的Conn. 
			return list; 
 
		} catch (SQLException e) 
		{ 
			// TODO Auto-generated catch block 
			e.printStackTrace(); 
			System.out.println("getStockArrayList 出错＄1¤7"); 
		} 
		return null; 
	} 
	 
	public ArrayList getStockName(String name) throws Exception 
	{ 
		list = new ArrayList(); 
		String sql = "select * from stockinfoview where ProductName = '"+name+"'"; 
		rs = db.getResult(sql); 
		while(rs.next()) 
		{ 
			StockCheckView scv = new StockCheckView(); 
			scv.setStockID(rs.getInt(1)); 
			scv.setProductID(rs.getInt(2)); 
			scv.setProductQuatity(rs.getInt(3)); 
			scv.setProductName(rs.getString(4)); 
			scv.setProductType(rs.getString(5)); 
			scv.setProductRegulate(rs.getString(6)); 
			scv.setProductTax(rs.getString(7)); 
			scv.setProductNotice(rs.getString(8)); 
			list.add(scv); 
			 
			System.out.println(rs.getInt(1)); 
		} 
		return list; 
		 
	} 
 
}