请问你们都是如何做的呢？~分页显示__private_String_currentPageNum_totalRecord_pageSize_

当前位置: 技术问答>java相关

请问你们都是如何做的呢？~分页显示

来源: 互联网发布时间：2015-10-07

本文导语: 查询表记录。记录过多。想每10条一页，按翻页可以显示下10条。请问你们都是如何做的呢？谢谢。 | 我已经贴过很多次了，不在乎再来一次，看来我的这个bean很赚分阿，给我带来了不少收...

查询表记录。记录过多。想每10条一页，按翻页可以显示下10条。
请问你们都是如何做的呢？

谢谢。

我已经贴过很多次了，不在乎再来一次，看来我的这个bean很赚分阿，给我带来了不少收入，给你源代码，自己研究一下。
package mshtang.html;
/**
*

Title: DataBaseQuery

Description: 用于数据库翻页查询操作

Company: 厦门一方软件公司

* @author 小唐蔡
* @version 1.0
*/
import java.sql.*;
import javax.servlet.http.*;
import java.util.*;
import mshtang.StringAction;
public class DataBaseQuery
{

  private HttpServletRequest request;
  private StringAction S;
  private String sql;
  private String userPara;
  private String[][] resultArray;
  private String[] columnNameArray;
  private String[] columnTypeArray;
  private int pageSize;
  private int columnCount;
  private int currentPageNum;
  private int currentPageRecordNum;
  private int totalPages;
  private int pageStartRecord;
  private int totalRecord;
  private static boolean initSuccessful;
  private String currentJSPPageName;
  private String displayMessage;

  public DataBaseQuery()
  {
    S = new StringAction();
    sql = "";
    pageSize = 10;
    totalRecord = 0;
    initSuccessful = false;
    currentJSPPageName = "";
    displayMessage = "";
    columnNameArray = null;
    columnTypeArray = null;
    currentPageRecordNum = 0;
    columnCount = 0;
  }

  /**功能：数据库初始化操作，其它操作的前提。
   *
   * @param conn：数据库连接；
   * @param request：jsp页面request对象；
   * @param querySQL：查询语句；
   * @param pageSize：每页显示记录数；
   * @param startPageNum：开始显示页码
   */
  public void init(Connection conn, HttpServletRequest request, String querySQL, int pageSize, int startPageNum)
  {
    if(conn != null)
    {
      this.request = request;
      this.sql = request.getParameter("querySQL");
      this.userPara = request.getParameter("userPara");
      if(sql == null || sql.equals(""))
      {
        sql = querySQL;
      }
      if(this.userPara == null)
      {
        this.userPara = "";
      }
      if(S.isContains(sql, "select;from", ";", true))
      {
        try
        {
          Statement st = conn.createStatement();
          ResultSet rs = st.executeQuery(sql);
          ResultSetMetaData rsmd = rs.getMetaData();
          columnCount = rsmd.getColumnCount();
          columnNameArray = new String[columnCount];
          columnTypeArray = new String[columnCount];
          String columnName;
          String value;
          while(rs != null && rs.next())
          {
            totalRecord++;
            if(totalRecord == 1)
            {
              for(int i = 0; i  0 && pageSize > 0 && columnCount > 0 && startPageNum > 0)
          {
            //获取总页数
            totalPages = totalRecord / pageSize;
            int tempNum = totalRecord % pageSize;
            if(tempNum != 0)
            {
              totalPages++;
            }

            //获得当前页页码
            String currentPage = request.getParameter("currentPageNum");
            currentPageNum = (currentPage == null || currentPage.equals(""))? startPageNum:Integer.parseInt(currentPage);
            currentPageNum = (currentPageNum > totalPages)?totalPages:currentPageNum;
            currentPageNum = (currentPageNum  totalRecord)
            {
              currentPageRecordNum = totalRecord - (currentPageNum - 1) * pageSize;
            }
            else
            {
              currentPageRecordNum = pageSize;
            }
            resultArray = new String[currentPageRecordNum][columnCount];

            //用于跳过前面不需显示的记录
            int continueRowNum = 0;

            //用于跳过后面不再显示的记录
            int breakRowNum = 0;

            ResultSet rs2 = st.executeQuery(sql);
            while(rs2 != null && rs2.next())
            {
              //跳过前面不需显示的记录
              continueRowNum++;
              if(continueRowNum