www.pudn.com > BeiJie.rar > EnterCheckOperation.java

package operation; 
 
import java.sql.ResultSet; 
import java.sql.SQLException; 
import java.util.ArrayList; 
import java.util.Date; 
import java.util.Vector; 
 
import dataBase.DataBase; 
import entity.EnterCheckView; 
import entity.EnterPageBean; 
 
public class EnterCheckOperation 
{ 
 
	private ResultSet rs = null; 
 
	private ArrayList list = null; 
 
	private String sql = ""; 
 
	private DataBase db = null; 
	 
	Vector v; 
	 
	public int totalrows = 0; 
 
	public EnterCheckOperation() 
	{ 
		db = new DataBase(); 
		v = new Vector(); 
	} 
	 
	 
	 
	public ArrayList getEnterCheckArrayList(String starttime,String endtime) 
	{ 
		list = new ArrayList(); 
		sql = "select * from enterinfocheckview where EnterDate between '"+starttime+"' and '"+endtime+"'";  
		try 
		{ 
			rs = db.getResult(sql); 
			while (rs.next()) 
			{ 
				String enterID = rs.getString(1);// 进货编号 
				int productID = rs.getInt(2);// 商品编号 
				int enterQuantity = rs.getInt(3);// 进货数量 
				float enterPrice = rs.getFloat(4);// 进货单价 
				float enterSum = rs.getFloat(5);// 进货金额 
				Date enterDate = rs.getDate(6);// 进货日期 
				String chargeman = rs.getString(7);// 经手亄1�7 
				String enterNotice = rs.getString(8);// 备注 
				String productName=rs.getString(9);//商品名称〄1�7 
				String shouldPayFlag=rs.getString(10);//是否付清 
				String stockid = rs.getString(11); 
				EnterCheckView entercheckview = new EnterCheckView(enterID, productID, 
						enterQuantity, enterPrice, enterSum, enterDate, 
						chargeman, enterNotice,productName,shouldPayFlag,stockid);// 利用数据库中读出的信息构造一个entercheck的对象�1�7�1�7 
				list.add(entercheckview);// 将entercheck的对象添加到list中�1�7�1�7 
			} 
			rs.close(); 
			db.close();// 关闭DB中的Conn. 
			return list; 
 
		} catch (SQLException e) 
		{ 
			// TODO Auto-generated catch block 
			e.printStackTrace(); 
			System.out.println("EnterCheckOperation ���� "); 
		} 
		return null; 
	} 
 
	public void close(ResultSet rs) 
	{ 
		try 
		{ 
			rs.close(); 
		} catch (SQLException e) 
		{ 
			System.out.println("rs和stmt已经关闭，但conn没有关闭"); 
		} 
	} 
	 
	public EnterPageBean listData(String page,String starttime,String endtime) throws Exception 
	{ 
		int pageNum = Integer.parseInt(page); 
		String rowssql = "select count(*) from enterinfocheckview where EnterDate between '"+starttime+"' and '"+endtime+"'"; 
		ResultSet rst = db.getResult(rowssql); 
		while(rst.next()) 
		{ 
			totalrows = rst.getInt(1); 
		} 
		EnterPageBean epb = new EnterPageBean(this); 
		String sql = "select * from enterinfocheckview where EnterDate between '"+starttime+"' and '"+endtime+"'"+" limit "+0+","+pageNum*epb.rowsPerPage; 
		ResultSet rs = db.getResult(sql); 
		int i = 0; 
		while(rs.next()) 
		{ 
			if(i>(pageNum-1)*epb.rowsPerPage-1) 
			{ 
				Object[] obj = new Object[11]; 
				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); 
				obj[10] = rs.getString(11); 
				v.add(obj); 
			} 
			i++; 
		} 
		rst.close(); 
		rs.close(); 
		db.close(); 
		epb.curPage=pageNum; 
		epb.data=v; 
		return epb; 
		 
	} 
	 
	public Vector getResult() throws Exception 
	{ 
		return v; 
	}  
	 
	public Vector getStockID(String stockid) throws Exception 
	{ 
		stockid="%"+stockid+"%"; 
		String sql = "select * from enterinfocheckview where StockID like '"+stockid+"'"; 
		ResultSet rs = db.getResult(sql); 
		while(rs.next()) 
		{ 
			EnterCheckView ecv = new EnterCheckView(); 
			ecv.setEnterID(rs.getString("EnterID")); 
			ecv.setProductID(rs.getInt("ProductID")); 
			ecv.setEnterQuantity(rs.getInt("EnterQuantity")); 
			ecv.setEnterPrice(rs.getFloat("EnterPrice")); 
			ecv.setEnterSum(rs.getFloat("EnterSum")); 
			ecv.setEnterDate(rs.getDate("EnterDate")); 
			ecv.setChargeman(rs.getString("Chargeman")); 
			ecv.setEnterNotice(rs.getString("EnterNotice")); 
			ecv.setProductName(rs.getString("ProductName")); 
			ecv.setShouldPayFlag(rs.getString("ShouldPayFlag")); 
			ecv.setStockId(rs.getString("StockID")); 
			v.add(ecv); 
		} 
		return v; 
		 
	} 
}