jsp实现读取数据库数据分页显示

最新推荐文章于 2022-09-29 12:20:59 发布

itzyjr

最新推荐文章于 2022-09-29 12:20:59 发布

阅读量3.7k

点赞数 1

本文链接：https://blog.csdn.net/itzyjr/article/details/8212581

版权

<%@ page language="java" pageEncoding="gb2312" %>
<%@ page contentType="text/html;charset=gb2312" %>
<%request.setCharacterEncoding("gb2312");%>
<%@ page import="java.util.*,java.lang.*,java.sql.*,javax.naming.*,javax.sql.*" %>
<%@ page errorPage="error.html" %>
<html>
<head><meta http-equiv=Content-Type content="text/html;charset=gb2312"></head>
<body>
<%Connection con=null;
  Statement stmt=null;
  ResultSet rs=null;
  int pageSize,rowCount,pageCount,curPage;
  pageSize=5;
  pageCount=1;
  String strPage=request.getParameter("page");
  if(strPage==null) curPage=1;
  else{
    curPage=Integer.parseInt(strPage);//通过参数来定当前页面
    if(curPage<1) curPage=1;
    }
%>
<%try{
  InitialContext ctx=new InitialContext();
  DataSource ds=(DataSource)ctx.lookup("java:comp/env/MySqlDS");
  con=ds.getConnection();
  stmt=con.createStatement();
  rs=stmt.executeQuery("select * from infos");
  rs.last();
  rowCount=rs.getRow();
  pageCount=(rowCount+pageSize-1)/pageSize;
  if(curPage>pageCount) curPage=pageCount;
  }catch(SQLException e){
    System.out.println(e.toString());
  }
%>
<table width="100%" ><tr><td>
页次：<%=curPage %>/<%=pageCount %>页     <%=pageSize %>条/页</td></tr>
</table>
<table width="80%"><tr>
<th>Number</th><th>Name</th><th>Activity</th><th>Score</th></tr>
<%if(pageCount>0) rs.absolute((curPage-1)*pageSize+1);
int i=0;
while(i<pageSize&&!rs.isAfterLast()){%>
<tr align="center"><td><%=rs.getString(1)%></td><td><%=rs.getString(2)%></td>
<td><%=rs.getString(3)%></td><td><%=rs.getString(4)%></td></tr>
<%
rs.next();
i++;
} %>
</table>
<%if(curPage>1){ %>
<a href="MyJsp.jsp?page=<%=curPage-1%>">上一页</a><%} %>
<%if(curPage<pageCount){ %>
<a href="MyJsp.jsp?page=<%=curPage+1%>">下一页</a><%} %>
</body></html>
<%rs.close();
  stmt.close();
  con.close();
%>

~~------------------------------------------------------------------------~~

itzyjr

关注

1
点赞
踩
14

收藏

觉得还不错? 一键收藏
打赏
0
评论
jsp实现读取数据库数据分页显示

<%Connection con=null; Statement stmt=null; ResultSet rs=null; int pageSize,rowCount,pageCount,curPage; pageSize=5; pageCount=1; String strPage=request.getParameter("page"); if(strPage==
复制链接

扫一扫