跪求JSP分页代码,包括范例.

跪求JSP分页代码,包括实例...
如上....

[解决办法]
uppp
[解决办法]
不是很难，自己试试写写
[解决办法]
<%@ page contentType= "text/html; charset=GBK " %>
<%@ page import= "java.sql.* " %>

<%String url = "jdbc:oracle:thin:@192.168.1.13:1521:GSSHJDB ";
String user = "newbaissq ";
String password = "newbaissq ";
Connection conn = DriverManager.getConnection(url,user,password);
Statement stmt = conn.createStatement();
%>
<% String toptitle= "所有新闻 ";%>

<script> <%--选中一个值后，打开它所链接的页面--%>
function GoToWhere(s){
var d = s.options[s.selectedIndex].value;
window.location=d;
s.selectedIndex=0;
}
</script>

<div align= "center ">
<table width= "766 " align= "center ">
<% String colors;
String sqlname;
int intPageSize;
int intRowCount;
int intPageCount;
int intPage;
String strPage;
int i,j;
intPageSize=10;
strPage=request.getParameter( "page ");

if(strPage==null){
intPage=1;
}else{
intPage=Integer.parseInt(strPage);
if(intPage <1)
intPage=1;
}
sqlname= "select count(id) from scott.video order by times desc ";
ResultSet rt = stmt.executeQuery(sqlname);
rt.next();
intRowCount=rt.getInt(1);
intPageCount=(intRowCount+intPageSize-1)/intPageSize;
if(intPage> intPageCount)
intPage=intPageCount;
sqlname= "select * from scott.video order by times desc ";
ResultSet rs=stmt.executeQuery(sqlname);
i=(intPage-1)*intPageSize;
for(j=0;j <i;j++)
rs.next();
if(intRowCount==0){%>
对不起，此版块暂无内容！
<%}else{
i=0;
while (i <intPageSize && rs.next()){
if(i%2==0){
colors= "#ffffff ";
}else{
colors= "#d6e8e9 ";
}
%>
<tr bgcolor= " <%=colors%> ">
<td width= "4% ">
<div align= "center "> <img src= " ">
</div>
</td>
<td width= "96% " height= "20 "> <a href= "video.jsp?id= <%=rs.getString( "id ")%> ">
<%=rs.getString( "vdtitle ")%> </a>
</td>
</tr>
<% i++;}
}%>
<tr bgcolor= "#ffffff "> <td height=20 colspan=2>
<div align= "left ">
<p align= 'center ' vAlign= 'bottom '>
第 <%=intPage%> 页   共 <%=intPageCount%> 页   
<%if(intPage <intPageCount){%>
<a href= "listvedio.jsp?page= <%=intPage+1%> "> 下一页 </a>    
<%}if(intPage> 1){%>
<a href= "listvedio.jsp?page= <%=intPage-1%> "> 上一页 </a>    
<%}%>
</div>
<div align= "right "> <a href= 'javascript:window.close() '> [关闭窗口] </a> </div>
</tr>

</table>
</div>
[解决办法]
分页最好是在从数据库取出数据的时候做最好！还有一种是假分页，回家要是有时间给你传代码吧
[解决办法]
我也想要个分页的代码。。。

[解决办法]
mysql语句：
select * from table limit (当前页-1)*每页行数,每页行数
ms sql :
select top 每页行数 * from table where id not in (select top (当前页-1) id from table)
上一页，下一页跳转时传递参数当前页数即可
[解决办法]
楼上的代码写的可以了。
楼主要是还是不会的吧，把你的表，sql语句，全部发上来，让大家帮忙改。
[解决办法]
<%@page import= "java.util.ArrayList "%>
<%@page import= "java.util.Iterator "%>
<%@page import= " "%>
<jsp:useBean id= "db " scope= "page " class= " "/>
<jsp:useBean id= "bsmb " scope= "page " class= " "/>

.........


<%
String p = request.getParameter( "page ");
String sql = "查询语句 ";
int tempPage = 1;
if (p != null)
tempPage = Integer.parseInt(p);

ArrayList list = db.自己写的方法(sql);

int recordsCount = list.size(); //总记录数
// System.out.println(recordsCount);
int pageSize = 10; //每页记录数
int pagesCount = (recordsCount + pageSize - 1) / pageSize; //总页数
// System.out.println(pagesCount);
if (tempPage < 0)
tempPage = 1;
if (tempPage > pagesCount)
tempPage = pagesCount;
int curPage = tempPage; //当前页结束页码
// System.out.println(curPage);
int start = (curPage - 1)*pageSize; //当前页起始页码
// System.out.println(start);
int end = curPage*pageSize + 1; //当前页结束页码
// System.out.println(end);
int i = 0;
Iterator it = list.iterator(); //叠代
while (it.hasNext()) { //it.hasNext()判断有无下一条记录
bsmb = (Select_message_bean) it.next(); //it.next()指针指向下一条
i++;
if (i > start && i < end) {
%>


......在此放分页的部分比如：
<tr bgcolor= "#66FFFF ">
<td> <div align= "center "> <%=bsmb.getMessage_number()%> </div> </td>
<td> <div align= "center "> <%=bsmb.getMessage_title()%> </td>
<td> <div align= "center "> <%=bsmb.getMessage_fitTitle()%> </div> </td>
<td> <div align= "center "> <%=bsmb.getColumn_name()%> </div> </td>
</tr>


<%
}
}
%>
<tr bgcolor= "#ffffff ">
<td height= "27 " colspan= "7 "> <div align= "center ">
<%if (curPage != 1) {%>
<a href= "本页面名.jsp?page=1 "> 第一页 </a> <a href= "本页面名.jsp?page= <%=curPage-1%> "> 上一页 </a>
<%
}
if (curPage != pagesCount) {
%>
<a href= "本页面名.jsp?page= <%=curPage+1%> "> 下一页 </a> <a href= "本页面名.jsp?page= <%=pagesCount%> "> 最后一页 </a>

<%}%>
</div> </td>
</tr>


[解决办法]
为什么要在页面分呢，在后台分好不可以吗
方法一
select top 10 * from tablename where id not in (select top 10*4 id from tablename)
//10 每页显示记录数
//4 第几页
//id 主健
//自己写个函数吧,别忘了加上where 和order by条件。

方法二：(针对视图也好用，相对第一种方法效率低一些)
select * from
(select top 20 * from v_LkFaceValue ) ss
where trnbr not in (select top 10 trnbr from v_LkFaceValue)
[解决办法]
邮箱给我
[解决办法]
其实分页很简单的有具体到哪个数据库的分页也有公用的分页
而且有时候具体到哪个数据库的话还会有相应的分页解决办法
比如sql 2005 就出现了一个分页查询以后有时间研究研究吧哈哈

跪求JSP分页代码,包括范例.

热点推荐