getlistoperation.java

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

package operation;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Collection;
import java.util.Vector;

import entity.GetList;
import entity.PageBean;

import dataBase.*;
public class GetListOperation
{
	private DataBase db=null;
	private ResultSet rs = null;
	int totalrows = 0;
	Vector v = null;
	public GetListOperation()
	{
		db = new DataBase();
		v = new Vector();
	}
	public Collection getGetList(String shouldGetID)
	{
		Collection ret = new ArrayList();
		String sql = "select * from GetList where ShouldGetID = '"+shouldGetID+"'";
		rs=db.getResult(sql);//执行SQL语句
		try
		{
			while(rs.next())
			{
				GetList gl = new GetList();
				gl.setGetID(rs.getString("GetID"));
				gl.setShouldGetID(rs.getString("ShouldGetID"));
				gl.setGetSum(rs.getFloat("GetSum"));
				gl.setChargeman(rs.getString("Chargeman"));
				gl.setGetDate(rs.getDate("GetDate"));
				gl.setGetNotice(rs.getString("GetNotice"));
				ret.add(gl);
			}
		} catch (SQLException e)
		{
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}	
		return ret;
	}
	
	public Collection getGetList(String starttime,String endtime)
	{
		Collection ret = new ArrayList();
		String sql = "select * from GetList where GetDate between '"+starttime+"' and '"+endtime+"'";
		rs=db.getResult(sql);//执行SQL语句
		try
		{
			while(rs.next())
			{
				GetList gl = new GetList();
				gl.setGetID(rs.getString("GetID"));
				gl.setShouldGetID(rs.getString("ShouldGetID"));
				gl.setGetSum(rs.getFloat("GetSum"));
				gl.setChargeman(rs.getString("Chargeman"));
				gl.setGetDate(rs.getDate("GetDate"));
				gl.setGetNotice(rs.getString("GetNotice"));
				//System.out.println(gl.getGetDate());
				ret.add(gl);
			}
		} catch (SQLException e)
		{
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}
		return ret;
	}
	
	public int getAvailableCount() throws Exception
	{
		int rows = 0;
		String sql = "select count(*) from GetList";
		ResultSet rs = db.getResult(sql);
		while(rs.next())
		{
			rows = rs.getInt(1);
		}
		return rows;
	}
	
	public Vector getResult() throws Exception
	{
		return v;
	}
	
	public GetListPage listData(String page,String starttime,String endtime) throws Exception
	{
		
		int pageNum = Integer.parseInt(page);
		String rowssql = "select count(*) from GetList where GetDate between '"+starttime+"' and '"+endtime+"'";
		
		ResultSet rst = db.getResult(rowssql);
		while(rst.next())
		{
			totalrows = rst.getInt(1);
		}
		GetListPage glp = new GetListPage(this);
		String sql = "select * from GetList where GetDate between '"+starttime+"' and '"+endtime+"'"+" limit "+0+","+pageNum*glp.rowsPerPage;
		ResultSet rs = db.getResult(sql);
		int i = 0;
		while(rs.next())
		{
			if(i>(pageNum-1)*glp.rowsPerPage-1)
			{
				Object[] obj = new Object[6];
				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);
				v.add(obj);
			}
			i++;
		}
		rst.close();
		rs.close();
		db.close();
		glp.curPage=pageNum;
		glp.data=v;
		return glp;
	}
	
	public GetListPage listData(String page,String shouldGetID) throws Exception
	{
		
		int pageNum = Integer.parseInt(page);
		String rowssql = "select count(*) from GetList where ShouldGetID = '"+shouldGetID+"'";
		
		ResultSet rst = db.getResult(rowssql);
		
		while(rst.next())
		{
			totalrows = rst.getInt(1);
		}
		GetListPage glp = new GetListPage(this);
		String sql = "select * from GetList where ShouldGetID ='"+shouldGetID+"'"+" limit "+0+","+pageNum*glp.rowsPerPage;
		ResultSet rs = db.getResult(sql);
		int i = 0;
		while(rs.next())
		{
			if(i>(pageNum-1)*glp.rowsPerPage-1)
			{
				Object[] obj = new Object[6];
				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);
				v.add(obj);
			}
			i++;
		}
		rs.close();
		db.close();
		glp.curPage=pageNum;
		glp.data=v;
		return glp;
		
	}
}