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