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;
		}
	}
}