如何让数据库中的记录在网页上分页显示? ACCESS网上说的应该是一篇文章行数很多所以分页吧我的意思是ACCESS里记录有很多,所以在网页上要分页显示大家能不能教我? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 参考这篇文章,呵呵!http://blog.csdn.net/qiyadeng/archive/2003/10/20/20376.aspx <%@ page contentType="text/html; charset=GBK" %><%@ page import="java.sql.*, javax.sql.DataSource, javax.naming.Context, javax.naming.InitialContext" %><%@ page import="pcmanage.PcinfoBase"%><% HttpSession usession = request.getSession(false); //检查用户的session信息 if (usession == null) { response.sendRedirect("error.jsp?id=1"); return; } String userdept = new String(request.getParameter("userdept").trim().getBytes("gb2312"),"8859_1"); Connection conn = null; Statement stmt = null; DataSource ds = null; try { Context context = new InitialContext(); ds = (DataSource) context.lookup("java:comp/env/jdbc/InformixDB"); } catch (Exception e) { System.out.println("err:" + e); ds = null; } try { conn = ds.getConnection(); } catch (Exception e) { conn = null; e.printStackTrace(); }int intPageSize; //一页显示的记录数int intRowCount; //记录总数int intPageCount; //总页数int intPage; //待显示页码int i; //设置一页显示的记录数PcinfoBase tt=new PcinfoBase();intPageSize = 10;//取得待显示页码String strPage=request.getParameter("page");%><%=strPage%><%//String strPage = new String(request.getParameter("page").getBytes("8859_1")); if(strPage==null){ //表明在QueryString中没有page这一个参数,此时显示第一页数据 intPage = 1; } else{ //将字符串转换成整型 intPage = java.lang.Integer.parseInt(strPage); if(intPage<1) intPage = 1; }// 得到结果stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);String sql = "select * from computerinfo where userdept = '" + userdept + "'";ResultSet sqlRst = stmt.executeQuery(sql);//获取记录总数sqlRst.last();intRowCount = sqlRst.getRow();//记算总页数intPageCount = (intRowCount+intPageSize-1) / intPageSize;//调整待显示的页码 if(intPage>intPageCount) intPage = intPageCount;%><html><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><% String dept=new String(userdept.getBytes("8859_1"),"gb2312");%><title><%=dept%>使用的设备一览表</title></head><h1><%=dept%>使用的设备一览表</h1><body><table border="1" cellspacing="0" cellpadding="0" width="85%" align="center"><tr> <th>整机id</th><th>姓名</th><th>ip</th><th>配置</th></tr><% if(intPageCount>0) { //将记录指针定位到待显示页的第一条记录上 sqlRst.absolute((intPage-1) * intPageSize + 1); //显示数据 i = 0; while(i<intPageSize && !sqlRst.isAfterLast()){ %> <tr> <% tt.setid(sqlRst.getInt("id")); tt.setusername(sqlRst.getString("username")); tt.setip(sqlRst.getString("ip")); tt.setpcinfo(sqlRst.getString("pcinfo")); %> <td><%=tt.id%></td> <td><%=tt.username%></td> <td><%=tt.ip%></td> <td><%=tt.pcinfo%></td> </tr> <% sqlRst.next(); i++; } }%></table><%//关闭结果集sqlRst.close();stmt.close();conn.close();String temp=Integer.toString(intPage+1);%>共<%=intRowCount%>条记录 第<%=intPage%>页 共<%=intPageCount%>页<%if(intPage<intPageCount){%><a href="PcQueryBydept.jsp?page=<%=temp%>&userdept=<%=dept%>">下一页</a><%}%><%if(intPage>1){%><a href="PcQueryBydept.jsp?page=<%=intPage-1%>">上一页</a><%}%></body></html> 【100分】请教extjs做的表单如何展示后台数据库查出来的数据? java 如何将字符串转json方法 关于SSH开发中JSP页面向Action传值的问题!急~ 求解疑:servlet到jsp的转形,我觉得好难哦! unicode&big5 页面代码用什么工具调试好呀 用“苹果茶”内网建站软件的问题 拜师!!! 高手请进, 可不可以split一个全角字符? 难道include真的有这么低级吗 我彷徨!我迷惑! tif格式的扫描图片,如何通过链接用浏览器直接打开或下载
http://blog.csdn.net/qiyadeng/archive/2003/10/20/20376.aspx
<%@ page import="java.sql.*, javax.sql.DataSource, javax.naming.Context, javax.naming.InitialContext" %>
<%@ page import="pcmanage.PcinfoBase"%><%
HttpSession usession = request.getSession(false); //检查用户的session信息
if (usession == null) {
response.sendRedirect("error.jsp?id=1");
return;
}
String userdept = new String(request.getParameter("userdept").trim().getBytes("gb2312"),"8859_1");
Connection conn = null;
Statement stmt = null;
DataSource ds = null;
try {
Context context = new InitialContext();
ds = (DataSource) context.lookup("java:comp/env/jdbc/InformixDB");
}
catch (Exception e) {
System.out.println("err:" + e);
ds = null;
}
try {
conn = ds.getConnection();
}
catch (Exception e) {
conn = null;
e.printStackTrace();
}
int intPageSize; //一页显示的记录数
int intRowCount; //记录总数
int intPageCount; //总页数
int intPage; //待显示页码
int i; //设置一页显示的记录数
PcinfoBase tt=new PcinfoBase();
intPageSize = 10;
//取得待显示页码String strPage=request.getParameter("page");
%>
<%=strPage%>
<%
//String strPage = new String(request.getParameter("page").getBytes("8859_1"));
if(strPage==null){ //表明在QueryString中没有page这一个参数,此时显示第一页数据
intPage = 1;
}
else{ //将字符串转换成整型
intPage = java.lang.Integer.parseInt(strPage);
if(intPage<1)
intPage = 1;
}
// 得到结果
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
String sql = "select * from computerinfo where userdept = '" + userdept + "'";
ResultSet sqlRst = stmt.executeQuery(sql);
//获取记录总数
sqlRst.last();
intRowCount = sqlRst.getRow();
//记算总页数
intPageCount = (intRowCount+intPageSize-1) / intPageSize;
//调整待显示的页码
if(intPage>intPageCount)
intPage = intPageCount;%><html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<% String dept=new String(userdept.getBytes("8859_1"),"gb2312");%>
<title><%=dept%>使用的设备一览表</title>
</head>
<h1><%=dept%>使用的设备一览表</h1>
<body>
<table border="1" cellspacing="0" cellpadding="0" width="85%" align="center">
<tr>
<th>整机id</th><th>姓名</th><th>ip</th><th>配置</th>
</tr>
<% if(intPageCount>0) { //将记录指针定位到待显示页的第一条记录上
sqlRst.absolute((intPage-1) * intPageSize + 1);
//显示数据
i = 0;
while(i<intPageSize && !sqlRst.isAfterLast()){ %>
<tr>
<% tt.setid(sqlRst.getInt("id"));
tt.setusername(sqlRst.getString("username"));
tt.setip(sqlRst.getString("ip"));
tt.setpcinfo(sqlRst.getString("pcinfo"));
%>
<td><%=tt.id%></td>
<td><%=tt.username%></td>
<td><%=tt.ip%></td>
<td><%=tt.pcinfo%></td>
</tr>
<% sqlRst.next();
i++;
}
}
%>
</table>
<%
//关闭结果集
sqlRst.close();
stmt.close();
conn.close();
String temp=Integer.toString(intPage+1);
%>
共<%=intRowCount%>条记录 第<%=intPage%>页 共<%=intPageCount%>页
<%if(intPage<intPageCount){%><a href="PcQueryBydept.jsp?page=<%=temp%>&userdept=<%=dept%>">下一页</a><%}%>
<%if(intPage>1){%><a href="PcQueryBydept.jsp?page=<%=intPage-1%>">上一页</a><%}%>
</body>
</html>