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);// 灏唀ntercheck鐨勫