分页

最新推荐文章于 2022-07-15 11:03:08 发布

khcrane

最新推荐文章于 2022-07-15 11:03:08 发布

阅读量230

点赞数

分类专栏： JAVA-JSP 文章标签： scroll string null

本文链接：https://blog.csdn.net/khcrane/article/details/2447055

版权

JAVA-JSP 专栏收录该内容

0 篇文章 0 订阅

订阅专栏

<%String sConn="你的连接" Class.forName("oracle.jdbc.driver.OracleDriver"); Connection conn=DriverManager.getConnection(sConn,"你的用户名","密码"); Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); Statement stmtcount=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); ResultSet rs=stmt.executeQuery("select * from mytable_view"); String sqlcount="select count(*) from mytable_view"; ResultSet rscount=stmtcount.executeQuery(sqlcount); int pageSize=你的每页显示纪录数； int rowCount=0; //总的记录数 while (rscount int pageCount; //总的页数 int currPage; //当前页数 String strPage; strPage=request.getParameter("page"); if (strPage==null){ currPage=1; } else{ currPage=Integer.parseInt(strPage); if (currPage<1) currPage=1; } pageCount=(rowCount+pageSize-1)/pageSize; if (currPage>pageCount) currPage=pageCount; int thepage=(currPage-1)*pageSize; int n=0; rs.absolute(thepage+1); while (n<(pageSize)&&!rs %> <%rs.close(); rscount.close(); stmt.close(); stmtcount.close(); conn.close(); %> //下面是第几页等

第<%=currPage%>页共<%=pageCount%>页共<%=rowCount%>条 <%if(currPage>1){%> 首页<%}%> <%if(currPage>1){%> 上一页<%}%> <%if(currPage