Oracle分页在Web上的首页

************************************* Oracle分页的重要代码，学习自 韩顺平老师的 Java操作Oracle 十二讲 ****************************************

//总共有多少页，计算得出
int pageCount = 0;
//总共有多少条记录，查询得出
int rowCount = 0;

//当前页
int currentPage = 1;
//初始化开始和结束的记录条数
int start = 1;
int end = pageSize;

//得到记录总数
rs = sm.executeQuery("select count(*) from emp");
while(rs.next()) {
rowCount = rs.getInt(1);
if(rowCount%pageSize==0){
pageCount = rowCount/pageSize;
} else {
pageCount = rowCount/pageSize+1;
}
}

//当前页码
String s_CurrentPage = request.getParameter("currentPage");
if(s_CurrentPage!=null && !"".equals(s_CurrentPage.trim())) {
currentPage = Integer.parseInt(s_CurrentPage);
start = (currentPage-1)*pageSize + 1;
end = currentPage*pageSize;
}


//分页的关键代码

String fenyeSql = "select * from (select a1.*, rownum bieming from (select * from emp) a1 where rownum<=" + end + ") where bieming>=" + start;
out.println(fenyeSql + "
");

rs = sm.executeQuery(fenyeSql);

//##查询所有的员工 rs = sm.executeQuery("select * from emp");
while(rs.next()){
out.print("

}

//打印总页数
for(int i=1; i<=pageCount; i++){
out.print("" + i + "　");
}

rs.close();
sm.close();
conn.close();
%>