www.pudn.com > BeiJie.rar > WelFareCheckOperation.java

package operation; 
 
import java.sql.ResultSet; 
import java.sql.SQLException; 
import java.util.ArrayList; 
 
import dataBase.DataBase; 
import entity.WelFareView; 
 
public class WelFareCheckOperation 
{ 
	private ResultSet rs = null; 
 
	private ArrayList list = null; 
 
	private String sql = ""; 
 
	private DataBase db = null; 
 
	public WelFareCheckOperation() 
	{ 
		db = new DataBase(); 
	} 
	public ArrayList getWelFareInfo(String starttime,String endtime) 
	{ 
		ArrayList list=new ArrayList(); 
		try 
		{ 
			String sql="select ProductID,ProductName,Sum(CostSum) as CostSum from welfareview  where WelfareDate between '"+starttime+"' and '"+endtime+"' group by ProductID "; 
			rs=db.getResult(sql); 
			while(rs.next()) 
			{ 
				WelFareView welfareview=new WelFareView(); 
				welfareview.setProductID(rs.getInt("ProductID")); 
				welfareview.setProductName(rs.getString("ProductName")); 
				welfareview.setCostSum(rs.getFloat("CostSum")); 
				list.add(welfareview);				 
			} 
			 
		} catch (SQLException e) 
		{ 
			// TODO Auto-generated catch block 
			e.printStackTrace(); 
			System.out.println("getWelFareInfo ´يخَ"); 
		} 
		return list; 
	} 
 
}