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

}