welfarecheckoper.java

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

package operation;

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

import dataBase.DataBase;
import entity.WelFare;

public class WelFareCheckOper
{
	private DataBase db = null;
	public WelFareCheckOper()
	{
		db = new DataBase();
	}
	
	public void close()
	{
		db.close();
	}
	
	public Collection getWelFare(String starttime,String endtime)
	{
		try
		{
			Collection ret = new ArrayList();
			String sql = "select * from welfare where WelfareDate between '"+starttime+"' and '"+endtime+"'";
			ResultSet rs = db.getResult(sql);
			while(rs.next())
			{
				WelFare wf = new WelFare();
				wf.setWelfareID(rs.getString(1));
				wf.setProductID(rs.getInt(2));
				wf.setProductQuantity(rs.getInt(3));
				wf.setWelFareNotice(rs.getString(4));
				wf.setWelFareDate(rs.getDate(5));
				wf.setCostSum(rs.getFloat(6));
				wf.setChargeMan(rs.getString(7));
				ret.add(wf);
			}
			return ret;
		}
		catch(Exception e)
		{
			e.printStackTrace();
			return null;
		}
	}
}