comenteroperation.java

该源代码实现了系统的进货

package operation;

import dataBase.DataBase;
import entity.EnterCheckView;

import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.Collection;

public class ComEnterOperation
{
	private DataBase db = null;
	public ComEnterOperation()
	{
		db = new DataBase();
	}
	public void close()
	{
		db.close();
	}
	public ArrayList getProviderEnterInfo(String ProviderName)
	{
		try
		{
			
			ArrayList list = new ArrayList();
			String sql = "SELECT * FROM ProviderInfo,Productinfo,enterinfocheckview " +
					"where productinfo.productid=enterinfocheckview.productid and " +
					"providerinfo.providerid=productinfo.providerid and " +
					"providername='"+ProviderName+"'";
			ResultSet rs = db.getResult(sql);
			while(rs.next())
			{
				EnterCheckView ecv = new EnterCheckView();
				ecv.setEnterID(rs.getString("EnterID"));
				ecv.setProductID(rs.getInt("ProductID"));
				ecv.setEnterQuantity(rs.getInt("EnterQuantity"));
				ecv.setEnterPrice(rs.getFloat("EnterPrice"));
				ecv.setEnterSum(rs.getFloat("EnterSum"));
				ecv.setEnterDate(rs.getDate("EnterDate"));
				ecv.setChargeman(rs.getString("Chargeman"));
				ecv.setEnterNotice(rs.getString("EnterNotice"));
				ecv.setProductName(rs.getString("ProductName"));
				ecv.setShouldPayFlag(rs.getString("ShouldPayFlag"));
				ecv.setStockId(rs.getString("StockID"));
				list.add(ecv);
			}
			return list;
		}
		catch(Exception e)
		{
			e.printStackTrace();
			return null;
		}
	}
  public ArrayList getProductEnterInfo(String ProductName)
  {
	 try
	 {
	  ArrayList list = new ArrayList();
		String sql = "select * from enterinfocheckview where ProductName='"+ProductName+"'";
		ResultSet rs = db.getResult(sql);
		while(rs.next())
		{
			EnterCheckView ecv = new EnterCheckView();
			ecv.setEnterID(rs.getString("EnterID"));
			ecv.setProductID(rs.getInt("ProductID"));
			ecv.setEnterQuantity(rs.getInt("EnterQuantity"));
			ecv.setEnterPrice(rs.getFloat("EnterPrice"));
			ecv.setEnterSum(rs.getFloat("EnterSum"));
			ecv.setEnterDate(rs.getDate("EnterDate"));
			ecv.setChargeman(rs.getString("Chargeman"));
			ecv.setEnterNotice(rs.getString("EnterNotice"));
			ecv.setProductName(rs.getString("ProductName"));
			ecv.setShouldPayFlag(rs.getString("ShouldPayFlag"));
			ecv.setStockId(rs.getString("StockID"));
			list.add(ecv);
		}
		return list;
	}
	catch(Exception e)
	{
		e.printStackTrace();
		return null;
	}
  }
}