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

package operation; 
 
import java.sql.ResultSet; 
import java.sql.SQLException; 
import java.util.ArrayList; 
import java.util.Iterator; 
 
import dataBase.DataBase; 
import entity.FinanceInfo; 
 
public class FinanceCheckOperation 
{ 
	private ResultSet rs = null; 
 
	private ArrayList list = null; 
 
	private String sql = ""; 
 
	private DataBase db = null; 
 
	public FinanceCheckOperation() 
	{ 
		db = new DataBase(); 
	} 
 
	/** 
	 * @param shouldpayid 
	 * @return 
	 */ 
	public ArrayList getFinancialInfo(String starttime,String endtime) 
	{ 
		ArrayList list=new ArrayList(); 
		try 
		{ 
			String sql="select ProductID,ProductName,Sum(costsum) as costsum,Sum(salesum) as salesum from saledetailview where SaleDate between '"+starttime+"' and '"+endtime+"' group by ProductID"; 
			rs=db.getResult(sql); 
			while(rs.next()) 
			{ 
				FinanceInfo financeinfo=new FinanceInfo(); 
				financeinfo.setProductID(rs.getInt("ProductID")); 
				financeinfo.setProductName(rs.getString("ProductName")); 
				financeinfo.setSaleSum(rs.getFloat("salesum")); 
				financeinfo.setCostSum(rs.getFloat("costsum")); 
				list.add(financeinfo);				 
			} 
			 
		} catch (SQLException e) 
		{ 
			// TODO Auto-generated catch block 
			e.printStackTrace(); 
			System.out.println("getFinancialInfo ´يخَ"); 
		} 
		return list; 
	} 
 
}