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涓