pagebean.java

JSP网上书店系统,有完整的程序,可以直接使用,无需修改

package com.tsinghua.dao;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import com.tsinghua.db.DB;
import com.tsinghua.vo.Orders2;

public class PageBean {
 
	//每页显示多少条记录
	private int Pagesize=1;
	//当前的页数
	private int Pageid;
	//共有多少条记录
	private int Size;
	//分页后的总页数
	private int Pagenum;
	public int getPageid() {
		return Pageid;
	}
	public void setPageid(int pageid) {
		Pageid = pageid;
	}
	public int getPagenum() {
		return Pagenum;
	}
	public void setPagenum(int pagenum) {
		Pagenum = pagenum;
	}
	public int getPagesize() {
		return Pagesize;
	}
	public void setPagesize(int pagesize) {
		Pagesize = pagesize;
	}
	public int getSize() {
		return Size;
	}
	public void setSize(int size) {
		Size = size;
	}
	//查询方法
	Connection conn=null;
	ResultSet rs=null;
	Statement met=null;
	public PageBean()throws Exception{
	   conn=DB.getconn();
	   met=conn.createStatement(1004,1008);
	   String sql="select * from orders2";
	   rs=DB.getrs(met, sql);
	   //将游标移到最后
	   rs.last();
	   
	   this.Size=rs.getRow();
	   this.Pagenum=(Size/Pagesize==0?Size/Pagesize:Size/Pagesize+1)-1;
	 
	   //再将游标移到最前面
	   rs.beforeFirst();
	}
	//查询方法
	public List seeorders(int Pageid)throws Exception{
		  this.Pageid=Pageid;
		  //判断当前
		  for(int i=0;i<(Pageid-1)*Pagesize;i++){
			  rs.next();
		  }
		  //判断当前页能否显满
		  for(int j=0;j<Pagesize;j++){
			  if(!rs.next()){
				  break;
			  }
		  }
		    Orders2 r=new Orders2();
		    List list=new ArrayList(); 
			r.setId(rs.getInt(1));
			r.setShopusername(rs.getString(2));
			r.setShopphone(rs.getString(3));
			r.setShopaddress(rs.getString(4));
			r.setShopfangshi(rs.getString(5));
			r.setUserinfo(rs.getString(6));
			r.setOrdertime(rs.getString(7));
			list.add(r);
		return list;
	}
	
	
}