jsp oracle分页与sqlserver分页

qbnqjrshph · 发表于 2016-7-27 09:56:44

先来个sqlserver分页
数据库很简单就一张表
表字段有：
id，主键，自动增长
name 组名
直接贴代码;

<%@ page language="java" import="java.sql.*,java.util.*" pageEncoding="gbk"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
String pageNowStr=request.getParameter("pageNow");    //当前是第几页
int pageNow=1;
if(pageNowStr!=null){
pageNow=Integer.valueOf(pageNowStr);
}
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'index.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">

</head>
<body>
<table border="1">
<%
Connection conn=null;
PreparedStatement pst=null;
ResultSet result=null;
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
conn=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DataBaseName=Spring_dataBase","sa","123456");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
int pageSize=3;    //每页多少条记录
int rowCount=0;    //总共有多少条记录
int pageCount=0;    //总共有多少页记录
String queryPageCount="select count(*) from Group_tbl";
try {
pst=conn.prepareStatement(queryPageCount);
result=pst.executeQuery();
while(result.next()){
rowCount=result.getInt(1);  //获取页数
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
if(rowCount%pageSize==0){
pageCount=rowCount/pageSize;
}else{
pageCount=rowCount/pageSize+1;
}
System.out.print("pageCount"+pageCount);
String sql="select top "+pageSize+" * from Group_tbl where id not in(select top "+pageSize*(pageNow-1)+"id from Group_tbl)";
try {
pst=conn.prepareStatement(sql);
result=pst.executeQuery();
while(result.next()){
out.print("<tr><td>"+result.getString("id")+"</td><td>"+ result.getString("name")+"</td></tr>");
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
result.close();
pst.close();
conn.close();
}
%>
</table>
<%
if(pageNow!=1){
out.print("<a href=sqlserver.jsp?pageNow="+(pageNow-1)+">上一页</a>   ");
}
for(int i=pageNow;i<pageNow+3;i++){
if(i<=pageCount)    //使其不超过总页数
out.print("<a href=sqlserver.jsp?pageNow="+i+">"+i+"</a>   ");
}
if(pageNow<pageCount)
out.print("<a href=sqlserver.jsp?pageNow="+(pageNow+1)+">下一页</a>");
%>

<br>
</body>
</html>

效果如下;

----------------------------------------------------------------------
再来个oracle分页

账号		自动登录	找回密码
密码			立即注册

大疆运维招人啦，

C++ :try 语句块和异常处理

C++的多态

Red Hat RHCE 8 (EX294) Cert Guide

Java/C++ 区别：看完这一篇，就够用！

别再用过时库了！这 13 个顶级 C++ 库才是

c++ size_t 和 int 的区别

[经验分享] jsp oracle分页与sqlserver分页

浏览过的版块

扫码加入运维网微信交流群