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

package operation; 
 
import java.sql.ResultSet; 
import java.sql.SQLException; 
import java.util.ArrayList; 
import java.util.Date; 
 
import dataBase.DataBase; 
import entity.PayCheck; 
import entity.ShouldPayList; 
 
public class PayCheckOperation 
{ 
 
	private ResultSet rs = null; 
 
	private ArrayList list = null; 
 
	private String sql = ""; 
 
	private DataBase db = null; 
 
	public PayCheckOperation() 
	{ 
		db = new DataBase(); 
	} 
 
	public ArrayList getPayArrayList(String shouldpayid) 
	{ 
		list=new ArrayList(); 
		sql="select * from paylist where shouldpayid='"+shouldpayid+"'"; 
		try 
		{ 
			rs = db.getResult(sql); 
			while (rs.next()) 
			{ 
				String payID=rs.getString("PayID"); 
				String shouldPayID=rs.getString("ShouldPayID"); 
				float  paySum=rs.getFloat("PaySum"); 
				String chargeman=rs.getString("Chargeman"); 
				Date   payDate=rs.getDate("PayDate"); 
				String payNotice=rs.getString("PayNotice"); 
				PayCheck paycheck=new PayCheck(payID,shouldPayID,paySum,chargeman,payDate,payNotice); 
				list.add(paycheck); 
			} 
			rs.close(); 
			db.close();// 关闭DB中的Conn. 
			return list; 
 
		} catch (SQLException e) 
		{ 
			// TODO Auto-generated catch block 
			System.out.println("PayCheckOperation 出错＄1¤7"); 
		} 
		return null; 
	} 
	public ArrayList getPayListArrayList(String starttime,String endtime) 
	{ 
		list = new ArrayList(); 
		String sql = "select * from paylist where PayDate between '" + starttime+"' and '"+endtime+"'"; 
		try 
		{ 
			rs = db.getResult(sql); 
			while(rs.next()) 
			{ 
				String payID=rs.getString("PayID"); 
				String shouldPayID=rs.getString("ShouldPayID"); 
				float  paySum=rs.getFloat("PaySum"); 
				String chargeman=rs.getString("Chargeman"); 
				Date   payDate=rs.getDate("PayDate"); 
				String payNotice=rs.getString("PayNotice"); 
				PayCheck paycheck=new PayCheck(payID,shouldPayID,paySum,chargeman,payDate,payNotice); 
				list.add(paycheck); 
			} 
			rs.close(); 
			db.close();// 关闭DB中的Conn. 
			return list; 
 
		} catch (SQLException e) 
		{ 
			// TODO Auto-generated catch block 
			System.out.println("getPayListArrayList() 出错＄1¤7"); 
			e.printStackTrace(); 
		} 
		return null; 
		 
	} 
 
}