带ææ°åå页çjsp代ç å®ç°æ¹å¼å¦ä¸ï¼
é¦å è¦å®ä¹å个åéï¼
int pageSize:æ¯é¡µæ¾ç¤ºå¤å°æ¡è®°å½
int pageNow:å¸ææ¾ç¤ºç¬¬å 页
int pageCount:ä¸å ±æå¤å°é¡µ
int rowCount:ä¸å ±æå¤å°æ¡è®°å½
说æï¼
pageSizeæ¯æå®ç pageNowæ¯ç¨æ·éæ©ç
rowCountæ¯è®¡ç®åºæ¥ç 该计ç®å¼ä¸º
if(rowCount%pageSize==0){
pageCount=rowCount/pageSize;
}else{
pageCount=rowCount/pageSize+1;
}
(æå·§ï¼
æ°æ®åºæå ¥ï¼
insert into 表å(å段1ï¼2ï¼ããã)select å段1,2,...from 表å
)
æ¥è¯¢è¯å¥
select top pageSizeå段åå表from表åwhere id not in
(select top pageSize*(pageNow-1)id from 表å)
以æ们åé¢çusers表为ä¾ï¼æ¾ç¤ºç¬¬äºé¡µï¼è¯¥æ¥è¯¢è¯å¥å°±æ¯ï¼
select top 3 * from users where userId not in(select top 3 userId from users)
(select top 3 userId from users):éåºè¿ä¸ªè¡¨çåä¸æ¡ åé¢åéä¸æ¡
<h1>ç¨æ·ä¿¡æ¯å表</h1>
<%
//å®ä¹å个å页ä¼ç¨å°çåé
int pageSize=3;
int pageNow=1;//é»è®¤æ¾ç¤ºç¬¬ä¸é¡µ
int rowCount=0;//该å¼ä»æ°æ®åºä¸æ¥è¯¢
int pageCount=0;//该å¼æ¯éè¿pageSizeårowCount
//æ¥åç¨æ·å¸ææ¾ç¤ºç页æ°ï¼pageNowï¼
String s_pageNow=request.getParameter("pageNow");
if(s_pageNow!=null){
//æ¥æ¶å°äºpageNow
pageNow=Integer.parseInt(s_pageNow);
}
//æ¥è¯¢å¾å°rowCount
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection ct=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;dataBaseName=System","sa","");
Statement sm=ct.createStatement();
ResultSet rs=sm.exeuteQuery("select count(*) form users ");
if(rs.next()){
rowCount=rs.getInt(1);
}
//计ç®pageCount
if(rowCount%pageSize==0){
pageCount=rowCount/pageSize;
}else{
pageCount=rowCount/pageSize+1;
}
//æ¥è¯¢åºéè¦æ¾ç¤ºçè®°å½
rs=sm.exeuteQuery("select top "+pageSize
+" * from users where userId not in(select top "
+pageSize*(pageNow-1)+" userId from users) ");
%>
//æ¾ç¤º
<table border="1">
<tr><td>ç¨æ·ID</td><td>ç¨æ·åå</td><td>å¯ç </td><td>çµé®</td><td>级å«</td></tr>
<%
while(rs.next()){
%>
<tr><td><%=rs.getInt(1)%></td><td><%=rs.getString(2)%></td>
<td><%=rs.getString(3)%></td><td><%=rs.getString(4)%></td><td><%=rs.getInt(5)%></td></tr>
<%}%>
</table>
<%
//ä¸ä¸é¡µ
if(pageNow!=1){
out.println("<a href=wel.jsp?pageNow="+(pageNow-1)+">ä¸ä¸é¡µ</a>");
}
//æ¾ç¤ºè¶ é¾æ¥
for(int i=1;i<=pageCount;i++){
out.println("<a href=wel.jsp?pageNow="+i+">["+i+"]</a>");
}
//ä¸ä¸é¡µ
if(pageNow!=pageCount){
out.println("<a href=wel.jsp?pageNow="+(pageNow+1)+">ä¸ä¸é¡µ</a>");
}
%>
è¿è¡ææï¼
pager-lib.jar
这个包怎么用呀
http://wenku.baidu.com/view/fc2042114431b90d6c85c73e.html
这个百度文档说得很详细
你照着这个试试吧
不过要想做得好,后台还是要写java类代码的,比如做一个辅助工具类,一个分页数据实体类,你先不用搞这么麻烦,先试试把功能做出来再深入吧
点到那个数字 就跳转到我点的那个数字页面,(不过我用的一下个类)