JSP+JDBC_假分页

时间:2008-08-10 07:00:23  类别:JSP  作者:紫电

假分页:将数据全部读取出来,放入ResultSet中,再分别显示,具体代码如下:

<%@ page contentType="text/html;charset=gb2312"%>

<%@ page import="java.sql.*"%>

 

 

<html>

   <head>

      <title></title>

 

   </head>

   <body>

      <center>

          <h1>

             人员列表

          </h1>

          <hr>

 

          <br>

          <%!

             final String jspUrl="index_false_1.jsp";

           %>

          <%

 

             //定义如下分页变量

             //1.定义每页要显示的页数

             int lineSize = 3;

             //2.定义一个当前是第几页

             int currentPage = 1;

             // 计算出总页数

             int pageSize= 0;

             // 总记录数

             int allRecorders=0;

             

             // 接收传过来的当前页,第一次打开时没有传过来的值会发生异常,因此要try{}catch{}

             try{

                 currentPage = Integer.parseInt(request.getParameter("cp"));

             }catch(Exception e){

             }

 

             final String DBDRIVER = "org.gjt.mm.mysql.Driver";

             final String DBURL = "jdbc:mysql://59.64.167.41:3306/ren";

             final String DBUSER = "root";

             final String DBPASSWORD = "111111";

             Connection conn = null;

          %>

          <%

             try {

 

                 Class.forName(DBDRIVER);

                 conn = DriverManager.getConnection(DBURL, DBUSER, DBPASSWORD);

                 PreparedStatement pstmt = null;

                 

                 //先求出记录总数

                 String sql = "select count(Id) from person";

                 pstmt = conn.prepareStatement(sql);

                 ResultSet rs = pstmt.executeQuery();

                 if(rs .next())

                 {


特别推荐

广而告之