www.pudn.com > BeiJie.rar > 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; 
		 
	} 
	 
}