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