downbackcheckoperation.java

该源代码实现了系统的进货

package operation;

import java.sql.ResultSet;
import java.util.Vector;

import dataBase.DataBase;
import entity.DownBackBean;
import entity.PageBean;
import entity.UpBackBean;

public class DownBackCheckOperation
{
	private DataBase db;
	Vector v;
	public int totalrows;
	 public DownBackCheckOperation() throws Exception
		{
			db = new DataBase();
			v = new Vector();
		}
	 
	 public DownBackBean listData(String page,String starttime,String endtime) throws Exception
	 {
		 int pageNum = Integer.parseInt(page);
		 String rowsql = "select count(*) from downbackcheckview where BaclDate between '"+starttime+"' and '"+endtime+"'";
		 ResultSet rst = db.getResult(rowsql);
			while(rst.next())
			{
				totalrows = rst.getInt(1);
			}
			DownBackBean dbb = new DownBackBean(this);
			String sql = "select * from downbackcheckview where BaclDate between '"+starttime+"' and '"+endtime+"'"+" limit "+0+","+pageNum*dbb.rowsPerPage;
			ResultSet rs = db.getResult(sql);
			int i = 0;
			while(rs.next())
			{
				if(i>(pageNum-1)*dbb.rowsPerPage-1)
				{
					Object[] obj = new Object[9];
					obj[0] = rs.getString(1);
					obj[1] = rs.getString(2);
					obj[2] = rs.getString(3);
					obj[3] = rs.getString(4);
					obj[4] = rs.getString(5);
					obj[5] = rs.getString(6);
					obj[6] = rs.getString(7);
					obj[7] = rs.getString(8);
					obj[8] = rs.getString(9);
					
					
					v.add(obj);
				}
				i++;
			}
			rs.close();
			rst.close();
			db.close();
			dbb.curPage=pageNum;
			
			dbb.data=v;
			return dbb;
	 }
	 public Vector getResult() throws Exception
		{
			return v;
		}
}