昨天看到一篇《 純JSP分頁代碼 》的文章，是用于mysql，稍微修改下，用于Sqlserver2005/2008，沒有異常處理。沒有考慮性能等。
現將代碼貼出，以供初學者參考：
注：邀月使用環境Eclipse 3.4.2+Tomcat 6.18+Sqlserver2005 sp3調試成功。
頁面pagelistDemo.jsp內容：
<!-- {cps..0}-->
<%
@pagelanguage
=
"
java
"
contentType
=
"
text/html;charset=UTF-8
"
pageEncoding
=
"
UTF-8
"
%>
<%
//
連接字符串
Stringurl
=
"
jdbc:sqlserver://
"
+
Globals.Server
+
"
;databaseName=
"
+
Globals.DbName;
Class.forName(Globals.driverName).newInstance();
Connectionconnection
=
DriverManager.getConnection(url,
Globals.username,Globals.pwd);
Statementstatement
=
connection.createStatement();
//
每頁顯示記錄數
int
PageSize
=
10
;
int
StartRow
=
0
;
//
開始顯示記錄的編號
int
PageNo
=
0
;
//
需要顯示的頁數
int
CounterStart
=
0
;
//
每頁頁碼的初始值
int
CounterEnd
=
0
;
//
顯示頁碼的最大值
int
RecordCount
=
0
;
//
總記錄數;
int
MaxPage
=
0
;
//
總頁數
int
PrevStart
=
0
;
//
前一頁
int
NextPage
=
0
;
//
下一頁
int
LastRec
=
0
;
int
LastStartRecord
=
0
;
//
最后一頁開始顯示記錄的編號
//
獲取需要顯示的頁數，由用戶提交
if
(request.getParameter(
"
PageNo
"
)
==
null
)
{
//
如果為空，則表示第1頁
if
(StartRow
==
0
)
{
PageNo
=
StartRow
+
1
;
//
設定為1
}
}
else
{
PageNo
=
Integer.parseInt(request.getParameter(
"
PageNo
"
));
//
獲得用戶提交的頁數
StartRow
=
(PageNo
-
1
)
*
PageSize;
//
獲得開始顯示的記錄編號
}
//
因為顯示頁碼的數量是動態變化的，假如總共有一百頁，則不可能同時顯示100個鏈接。而是根據當前的頁數顯示
//
一定數量的頁面鏈接
//
設置顯示頁碼的初始值!!
if
(PageNo
%
PageSize
==
0
)
{
CounterStart
=
PageNo
-
(PageSize
-
1
);
}
else
{
CounterStart
=
PageNo
-
(PageNo
%
PageSize)
+
1
;
}
CounterEnd
=
CounterStart
+
(PageSize
-
1
);
%>
<!
DOCTYPEhtmlPUBLIC
"
-//W3C//DTDHTML4.01Transitional//EN
"
"
http://www.w3.org/TR/html4/loose.dtd
"
>
<%
@page
import
=
"
net.data.util.Globals
"
%>
<%
@page
import
=
"
java.sql.ResultSet
"
%>
<%
@page
import
=
"
java.sql.DriverManager
"
%>
<%
@page
import
=
"
java.sql.Connection
"
%>
<%
@page
import
=
"
java.sql.Statement
"
%>
<
element
>
<
html
>
<
head
>
<
metahttp
-
equiv
=
"
Content-Type
"
content
=
"
text/html;charset=UTF-8
"
>
<
title
>
分頁顯示記錄
</
title
>
<
linkrel
=
"
stylesheet
"
href
=
"
style.css
"
type
=
"
text/css
"
>
</
head
>
<%
//
獲取總記錄數
ResultSetrs
=
statement
.executeQuery(
"
selectcount(P_ID)fromproduct
"
);
rs.next();
RecordCount
=
rs.getInt(
1
);
//
取特定頁數的數據
StringstrColumn
=
"
P_ID,P_Name,LoginID,modTime,P_SingleIntro
"
;
StringstrTable
=
"
Product
"
;
StringstrSort
=
"
p_IDdesc
"
;
StringPKID
=
"
P_ID
"
;
StringstrSql
=
""
;
StringstrWhere
=
""
;
StringSTART_ID
=
Integer.toString((PageNo
-
1
)
*
PageSize
+
1
);
StringEND_ID
=
Integer.toString(PageNo
*
PageSize);
strSql
=
"
SELECT
"
+
strColumn
+
"
FROM(SELECTROW_NUMBER()OVER(ORDERBY
"
+
strSort
+
"
)ASrownum,
"
+
strColumn
+
"
FROM
"
+
strTable
+
"
WITH(NOLOCK)
"
+
strWhere
+
"
)ASDWHERErownumBETWEEN
"
+
START_ID
+
"
AND
"
+
END_ID
+
"
ORDERBY
"
+
strSort;
rs
=
statement.executeQuery(strSql);
//
獲取總頁數
MaxPage
=
RecordCount
%
PageSize;
if
(RecordCount
%
PageSize
==
0
)
{
MaxPage
=
RecordCount
/
PageSize;
}
else
{
MaxPage
=
RecordCount
/
PageSize
+
1
;
}
%>
<
body
class
=
"
UsePageBg
"
>
<
tablewidth
=
"
100%
"
border
=
"
0
"
class
=
"
InternalHeader
"
>
<
tr
>
<
tdwidth
=
"
24%
"
><
fontsize
=
4
>
分頁顯示記錄
</
font
></
td
>
<
tdwidth
=
"
76%
"
><
fontsize
=
4
><%=
"
總共
"
+
RecordCount
+
"
條記錄-當前頁：
"
+
PageNo
+
"
/
"
+
MaxPage
%></
font
></
td
>
</
tr
>
</
table
>
<
br
>
<
tablewidth
=
"
100%
"
border
=
"
0
"
class
=
"
NormalTableTwo
"
>
<
tr
>
<
td
class
=
"
InternalHeader
"
>
記錄序號
</
td
>
<
td
class
=
"
InternalHeader
"
>
數據標識號
</
td
>
<
td
class
=
"
InternalHeader
"
>
產品名稱
</
td
>
<
td
class
=
"
InternalHeader
"
>
作者
</
td
>
<
td
class
=
"
InternalHeader
"
>
提交時間
</
td
>
<
td
class
=
"
InternalHeader
"
>
簡介
</
td
>
</
tr
>
<%
long
i
=
1
;
while
(rs.next())
{
long
bil
=
i
+
(PageNo
-
1
)
*
PageSize;
%>
<
tr
>
<
td
class
=
"
NormalFieldTwo
"
><%=
bil
%></
td
>
<
td
class
=
"
NormalFieldTwo
"
><%=
rs.getString(
1
)
%></
td
>
<
td
class
=
"
NormalFieldTwo
"
><%=
rs.getString(
2
)
%></
td
>
<
td
class
=
"
NormalFieldTwo
"
><%=
rs.getString(
3
)
%></
td
>
<
td
class
=
"
NormalFieldTwo
"
><%=
rs.getString(
4
)
%></
td
>
<
td
class
=
"
NormalFieldTwo
"
><%=
rs.getString(
5
)
%></
td
>
</
tr
>
<%
i
++
;
}
%>
</
table
>
<
br
>
<
tablewidth
=
"
100%
"
border
=
"
0
"
class
=
"
InternalHeader
"
>
<
tr
>
<
td
>
<
divalign
=
"
center
"
>
<%
out.print(
"
<fontsize=4>
"
);
//
顯示第一頁或者前一頁的鏈接
//
如果當前頁不是第1頁，則顯示第一頁和前一頁的鏈接
if
(PageNo
!=
1
)
{
PrevStart
=
PageNo
-
1
;
out.print(
"
<ahref=pagelistDemo.jsp?PageNo=1>第一頁</a>:
"
);
out.print(
"
<ahref=pagelistDemo.jsp?PageNo=
"
+
PrevStart
+
"
>前一頁</a>
"
);
}
out.print(
"
[
"
);
//
打印需要顯示的頁碼
for
(
int
c
=
CounterStart;c
<=
CounterEnd;c
++
)
{
if
(c
<
MaxPage)
{
if
(c
==
PageNo)
{
if
(c
%
PageSize
==
0
)
{
out.print(c);
}
else
{
out.print(c
+
"
,
"
);
}
}
else
if
(c
%
PageSize
==
0
)
{
out.print(
"
<ahref=pagelistDemo.jsp?PageNo=
"
+
c
+
"
>
"
+
c
+
"
</a>
"
);
}
else
{
out.print(
"
<ahref=pagelistDemo.jsp?PageNo=
"
+
c
+
"
>
"
+
c
+
"
</a>,
"
);
}
}
else
{
if
(PageNo
==
MaxPage)
{
out.print(c);
break
;
}
else
{
out.print(
"
<ahref=pagelistDemo.jsp?PageNo=
"
+
c
+
"
>
"
+
c
+
"
</a>
"
);
break
;
}
}
}
out.print(
"
]
"
);
;
if
(PageNo
<
MaxPage)
{
//
如果當前頁不是最后一頁，則顯示下一頁鏈接
NextPage
=
PageNo
+
1
;
out.print(
"
<ahref=pagelistDemo.jsp?PageNo=
"
+
NextPage
+
"
>下一頁</a>
"
);
}
//
同時如果當前頁不是最后一頁，要顯示最后一頁的鏈接
if
(PageNo
<
MaxPage)
{
LastRec
=
RecordCount
%
PageSize;
if
(LastRec
==
0
)
{
LastStartRecord
=
RecordCount
-
PageSize;
}
else
{
LastStartRecord
=
RecordCount
-
LastRec;
}
out.print(
"
:
"
);
out.print(
"
<ahref=pagelistDemo.jsp?PageNo=
"
+
MaxPage
+
"
>最后一頁</a>
"
);
}
out.print(
"
</font>
"
);
%>
</
div
>
</
td
>
</
tr
>
</
table
>
<%
rs.close();
statement.close();
connection.close();
%>
</
body
>
</
html
>
用到的類文件：Globals.java
<!-- {cps..1}-->
/***/
/**
*
*/
package
net.data.util;
/***/
/**
*
@author
Administrator
*
*/
public
class
Globals
{
public
static
Stringusername
=
"
sa
"
;
public
static
Stringpwd
=
"
sa
"
;
public
static
StringDbName
=
"
TestData
"
;
//
publicstaticStringServer="192.168.30.6";
public
static
StringServer
=
"
192.168.44.2:1433
"
;
public
static
StringPort
=
"
1433
"
;
public
static
StringdriverName
=
"
com.microsoft.sqlserver.jdbc.SQLServerDriver
"
;
//
publicstaticStringconnectionURL{
//
//
return"jdbc:sqlserver:
//
"+Server+":"+Port+";databaseName="+DbName;
//
}
}
效果如圖：
更多文章、技術交流、商務合作、聯系博主
微信掃碼或搜索：z360901061
微信掃一掃加我為好友
QQ號聯系： 360901061
您的支持是博主寫作最大的動力，如果您喜歡我的文章，感覺我的文章對您有幫助，請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧，狠狠點擊下面給點支持吧，站長非常感激您！手機微信長按不能支付解決辦法：請將微信支付二維碼保存到相冊，切換到微信，然后點擊微信右上角掃一掃功能，選擇支付二維碼完成支付。
【本文對您有幫助就好】元
