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);// 灏唀ntercheck鐨勫