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涓