package bookSearchOrderBean;    //定義JavaBean所在的包

import java.sql.*;
import java.util.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class PageOneByOne
 {
  /* 這是一個實現記錄結果集分頁輸出的JavaBean */

  public int TotalRecs = 0;     // 記錄總數
  public int perPageRecs = -1;  // 每頁顯示的記錄數
  public int TotalPages = -1;   // 頁數總和
  public int CurrentPage = 1;   // 當前頁數
  public String PageURL = null;
  public String PageIndex = null;
  DBexecuteBean dbexe = null;
  ResultSet rset;

  public PageOneByOne()
    {
     /* 定義構造器，初始化每頁顯示的主題數 */
     perPageRecs = 3;   // 每頁顯示3條數據
     dbexe = new DBexecuteBean();
    }

  public ResultSet procPagesAndRecords(int TotalRecords,String sSQLCmd,HttpServletRequest req) throws SQLException
    {
     /* 這個方法（函數）是用來計算總的頁數 */
     PageURL = req.getRequestURI();     //獲取當前的連接
     PageIndex = req.getParameter("pages");
     if((PageIndex == null) || (PageIndex.length() < 1))
       {
        /* 定義當前頁數 */
        CurrentPage = 1;
       }       
     else
       {
        CurrentPage = Integer.parseInt(PageIndex);
        CurrentPage = (CurrentPage < 1) ? 1 : CurrentPage;
       }
     TotalRecs = TotalRecords;     // 獲取記錄結果集的總數
     TotalPages = (TotalRecs + perPageRecs + 1) / perPageRecs;  // 計算總的頁數
     CurrentPage = (CurrentPage > TotalPages) ? TotalPages : CurrentPage;
     rset = dbexe.getTableRecords(sSQLCmd);
     return rset;
    }

  public int getTotalRecs()
    {
     /* 獲取記錄總數 */
     return TotalRecs;
    }

  public int getTotalPages()
    {
     /* 獲取總的頁數 */
     return TotalPages;
    }
  public int getCurrentPage()
    {
     /* 獲取當前的頁數 */
     return CurrentPage;
    }

  public String cutPage()
    {
     /* 這個方法（函數）是建立URL連接對象 */

     String URLlinkStr = "";            // URL連接串
     int prevPage = -1;
     int nextPage = -1;
     prevPage = CurrentPage - 1;        // 前一頁
     nextPage = CurrentPage + 1;        // 后一頁

     URLlinkStr += "<td><b><i>總共有" + getTotalRecs() + " 條記錄，分" + getTotalPages() + "頁顯示，目前是第" + getCurrentPage() + "頁。";
     if(CurrentPage > 1)
       {URLlinkStr += "<a href=" + PageURL + "?pages=1>首&nbsp;&nbsp;頁</a>&nbsp;";}
     else
       {URLlinkStr += "首&nbsp;&nbsp;頁&nbsp;";}
     if(CurrentPage > 1)
       {URLlinkStr += "<a href=" + PageURL + "?pages=" + prevPage + ">上一頁</a>&nbsp;";}
     else
       {URLlinkStr += "上一頁&nbsp;";}
     if(CurrentPage < TotalPages)
       {URLlinkStr += "<a href=" + PageURL + "?pages=" + nextPage + ">下一頁</a>&nbsp;";}
     else
       {URLlinkStr += "下一頁&nbsp;";}
     if((TotalPages > 1) && (TotalPages != CurrentPage))
       {URLlinkStr += "<a href=" + PageURL + "?pages=" + TotalPages + ">尾&nbsp;&nbsp;頁</a>&nbsp;";}
     else
       {URLlinkStr += "尾&nbsp;&nbsp;頁&nbsp;";}
     URLlinkStr += "</i></b></td>";

     return URLlinkStr;
    }
 }