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;
	}

}