www.pudn.com > BeiJie.rar > 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; 
	} 
  } 
}