?? pageonebyone.java
字號:
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>首 頁</a> ";}
else
{URLlinkStr += "首 頁 ";}
if(CurrentPage > 1)
{URLlinkStr += "<a href=" + PageURL + "?pages=" + prevPage + ">上一頁</a> ";}
else
{URLlinkStr += "上一頁 ";}
if(CurrentPage < TotalPages)
{URLlinkStr += "<a href=" + PageURL + "?pages=" + nextPage + ">下一頁</a> ";}
else
{URLlinkStr += "下一頁 ";}
if((TotalPages > 1) && (TotalPages != CurrentPage))
{URLlinkStr += "<a href=" + PageURL + "?pages=" + TotalPages + ">尾 頁</a> ";}
else
{URLlinkStr += "尾 頁 ";}
URLlinkStr += "</i></b></td>";
return URLlinkStr;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -