跪求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>