contactbean.java

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

package entity;

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





import dataBase.DataBase;

public class ContactBean
{
	private DataBase db;
	Vector v;
	 int totalrows;
	public ContactBean() throws Exception
	{
		db = new DataBase();
		v = new Vector();
	}
	
	public int getAvailableCount() throws Exception
	{
		int rows = 0;
		String sql = "select count(*) from saleinfo";
		ResultSet rs = db.getResult(sql);
		while(rs.next())
		{
			rows = rs.getInt(1);
		}
		return rows;
	}
	public PageBean listData(String page,String starttime,String endtime) throws Exception
	{
		
		
		
		int pageNum = Integer.parseInt(page);
		
		String rowsql = "select count(*) from saleinfocheckview where SaleDate between '"+starttime+"' and '"+endtime+"'";
		ResultSet rst = db.getResult(rowsql);
		while(rst.next())
		{
			totalrows = rst.getInt(1);
		}
		PageBean pageBean = new PageBean(this);
		String sql = "select * from saleinfocheckview where SaleDate between '"+starttime+"' and '"+endtime+"'"+" limit "+0+","+pageNum*pageBean.rowsPerPage;
		ResultSet rs = db.getResult(sql);
		int i = 0;
		while(rs.next())
		{
			if(i>(pageNum-1)*pageBean.rowsPerPage-1)
			{
				Object[] obj = new Object[10];
				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);
				obj[9] = rs.getString(10);
				
				v.add(obj);
			}
			i++;
		}
		rs.close();
		rst.close();
		db.close();
		pageBean.curPage=pageNum;
		
		pageBean.data=v;
		System.out.println(totalrows);
		return pageBean;
	}
	
	public Vector getResult() throws Exception
	{
		return v;
	}
	
	public Vector getSaleID(String saleid) throws Exception
	{
		String sql = "select * from saleinfocheckview where SaleID like '%"+saleid+"%'";
		
		ResultSet rs = db.getResult(sql);
		while(rs.next())
		{
			SaleInfoView si = new SaleInfoView();
			si.setSaleID(rs.getString("SaleID"));
			si.setProductName(rs.getString("ProductName"));
			si.setCustomerName(rs.getString("CustomerName"));
			
			si.setSaleQuantity(rs.getInt("SaleQuantity"));
			si.setSalePrice(rs.getFloat("SalePrice"));
			si.setSaleSum(rs.getFloat("SaleSum"));
			si.setSaleDate(rs.getDate("SaleDate"));
			si.setChargeman(rs.getString("Chargeman"));
			si.setSaleNotice(rs.getString("SaleNotice"));
			si.setShouldGetFlag(rs.getString("ShouldGetFlag"));
			v.add(si);
			
		}
		return v;
		
	}
	
}