java分页jsp代码_jsp实现页面分页功能代码

hello

public static final String DRIVER = "com.mysql.jdbc.Driver";

public static final String USER = "root";

public static final String PASS = "";

public static final String URL = "jdbc:mysql://localhost:3306/teachinfo";

public static final int PAGESIZE = 5;

int pageCount;

int curPage = 1;

%>

//一页放5个

String user = null;

String pass = null;

try{

Class.forName(DRIVER);

Connection con = DriverManager.getConnection(URL,USER,PASS);

String sql = "SELECT * FROM department";

PreparedStatement stat = con.prepareStatement(sql,ResultSet.TYPE_FORWARD_ONLY,ResultSet.CONCUR_READ_ONLY);

ResultSet rs = stat.executeQuery();

rs.last();

int size = rs.getRow();

pageCount = (size%PAGESIZE==0)?(size/PAGESIZE):(size/PAGESIZE+1);

String tmp = request.getParameter("curPage");

if(tmp==null){

tmp="1";

}

curPage = Integer.parseInt(tmp);

if(curPage>=pageCount) curPage = pageCount;

boolean flag = rs.absolute((curPage-1)*PAGESIZE+1);

out.println(curPage);//输出到屏幕上

int count = 0;

do{

if(count>=PAGESIZE)break;

int departmentid = rs.getInt(1);

String departmentname = rs.getString(2);

count++;

%>

}while(rs.next());

con.close();

}

catch(Exception e){

}

%>

首页

上一页

下一页

尾页

第页/共页