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

package operation; 
 
import java.sql.ResultSet; 
import java.sql.SQLException; 
import java.util.ArrayList; 
import java.util.Date; 
 
import dataBase.DataBase; 
import entity.ShouldPayList; 
 
public class ShouldPayListOperation 
{ 
	private ResultSet rs = null; 
 
	private ArrayList list = null; 
 
	private String sql = ""; 
 
	private DataBase db = null; 
 
	public ShouldPayListOperation() 
	{ 
		db = new DataBase(); 
	} 
	public ArrayList getShouldPayListArrayList(String enterid) 
	{ 
		list = new ArrayList(); 
		String sql = "select * from shouldpaylist where EnterID='" + enterid+"'"; 
		try 
		{ 
			rs = db.getResult(sql); 
			while(rs.next()) 
			{ 
				String shouldPayID = rs.getString("ShouldPayID"); 
				String enterID = rs.getString("EnterID"); 
				float shouldPaySum = rs.getFloat("ShouldPaySum"); 
				float leaveSum = rs.getFloat("LeaveSum"); 
				String chargeman = rs.getString("ChargeMan"); 
				String shouldPayFlag = rs.getString("ShouldPayFlag"); 
				Date shouldPayDate = rs.getDate("ShouldPayDate"); 
				String shouldPayNotice = rs.getString("ShouldPayNotice"); 
 
				ShouldPayList shouldpaylist = new ShouldPayList(shouldPayID, 
						enterID, shouldPaySum, leaveSum, chargeman, 
						shouldPayFlag, shouldPayDate, shouldPayNotice); 
 
				list.add(shouldpaylist);// 将entercheck的对象添加到list中�1�7�1�7 
			} 
			rs.close(); 
			db.close();// 关闭DB中的Conn. 
			return list; 
 
		} catch (SQLException e) 
		{ 
			// TODO Auto-generated catch block 
			System.out.println("ShouldPayListOperation 出错＄1�7"); 
		} 
		return null; 
	} 
 
	public void close(ResultSet rs) 
	{ 
		try 
		{ 
			rs.close(); 
		} catch (SQLException e) 
		{ 
			System.out.println("rs和stmt已经关闭，但conn没有关闭"); 
		} 
	} 
}