JSP分页技术的实现资源-CSDN文库

共3个文件

jsp：3个

需积分: 6 51 浏览量 2008-11-06 13:21:42 上传评论收藏 3KB RAR 举报

资源推荐

资源详情

资源评论

收起资源包目录

-JSP.rar （3个子文件）

分页-JSP

session1.jsp 938B

search_result.jsp 13KB

chaxun.jsp 884B

<%@page contentType="text/html; charset=gbk" language="java" import="java.sql.*" errorPage=""%> <%@page pageEncoding="gbk"%> <%request.setCharacterEncoding("gbk");%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=gbk"> <title>查询结果</title> <script type="" language="javascript">  </script> <script type="text/JavaScript">  </script> </head> <jsp:useBean id="db1" scope="session" class="db.dbcon"/> <body> <% ResultSet rs1; ResultSet rs2; ResultSet rs3; String fanwei=null; int totalrec=0; int intpage=1; int pageline=8; int intpagecount=0; String keywords; String classid; String type; int c; int i;%> <% if(request.getParameter("page")!=null) intpage=Integer.parseInt(request.getParameter("page")); classid=(String)session.getAttribute("classid"); keywords=(String)session.getAttribute("keywords"); c=Integer.parseInt(classid); if(c==0){ //计算查询结果的数量 rs2 = db1.executeSql("select count(*) as zongshu from ct where cid like '%"+keywords+"%'"); if(rs2.next()) totalrec=rs2.getInt("zongshu"); db1.closeStat(); //rs2.close(); intpagecount=(totalrec+pageline-1)/pageline; //查询数据库 rs1 = db1.executeSql("select * from ct where cid like '%"+keywords+"%'"); %> <table width="751" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF"> <tr> <td width="544" valign="top"> <table width="541" border="1" bordercolordark="#ffffff" bordercolorlight="#18a6ff"> <tr> <td colspan="5"></td> </tr> <tr> <td nowrap> <div align="center">课程号</div> </td> <td nowrap> <div align="center">课程名</div> </td> <td nowrap> <div align="center">教师编号</div> </td> <td nowrap> <div align="center">教师姓名</div> </td> <td nowrap> <div align="center">选课人数</div> </td> <td nowrap> <div align="center">类别</div> </td> </tr> <% if(rs1!=null){ if(intpagecount>0) { for(i=1;i<=(intpage-1)*pageline;i++) rs1.next(); for(i=1;i<=pageline;i++){ if(rs1.next()){ String cid = rs1.getString("cid").trim(); String cname = rs1.getString("cname").trim(); String tid = rs1.getString("tid"); String tname = rs1.getString("tname"); int num = rs1.getInt("num"); %> <tr> <td nowrap> <div align="center"><%=cid%></div> </td> <td nowrap> <div align="center"><%=cname%></div> </td> <td nowrap> <div align="center"><%=tid%></div> </td> <td nowrap> <div align="center"><%=tname%></div> </td> <td nowrap> <div align="center"><%=num%></div> </td> <td nowrap> <div align="center"><%=c%></div> </td> </tr><% // 若总页数乘每页显示的数量小于总条数则总页数加一 if(intpagecount*pageline<totalrec) intpagecount++; //若当前页数大于总页数则当前页数等于总页数 if(intpage>intpagecount) intpage=intpagecount; if(intpage<1) intpage=1; %> <%} } rs1.close(); } }else{out.print("ERROR!");} %> </tr> </table> <table width="541" border="0" bordercolordark="#ffffff" bordercolorlight="#18a6ff"> <tr> <td colspan="5"><hr width="541" color="#6633FF"></td> </tr> <tr> <td colspan="5" nowrap height="21"> <div align="center"> <% if(intpage<2) out.print("首页上一页"); //当前页数大于2时‘首页’与‘上一页’链接激活 else{ out.print("<a href='search_result.jsp?page=1'><font color='#2DFFFF' size='2'>首页</font></a>"); //单击“上一页”intpage减一并传值 out.print("<a href='search_result.jsp?page="+(intpage-1)+"'><font color='#2DFFFF' size='2'>上一页</font></a>"); } if(intpage-intpagecount>=0) out.print("下一页尾页"); //当前页数小于最大页数时 “下一页”与“尾页”激活 else{ out.print("<a href='search_result.jsp?page="+(intpage+1)+"'><font color='#2DFFFF' size='2'>下一页</font></a><a href='search_result.jsp?page="+intpagecount+"'><font color='#2DFFFF' size='2'>尾页</font></a>"); } //显示状态栏 out.print(" 页次:"+intpage+"/"+intpagecount+"页"); out.print(" 共"+totalrec+"条 <b>"+pageline+"</b>条/页 "); //实现goto out.print("转到第<input type='text' name='page' size=2 maxlength=10 class=smalInput value="+intpage+">"); out.print("页<input class=buttonface type='submit' value='go' name='cndok'></span></p></form>"); } %> </div></td> </tr> </table>  <% if(c==1){ //计算查询结果的数量 rs2 = db1.executeSql("select count(*) as zongshu from ct where cname like '%"+keywords+"%'"); if(rs2.next()) totalrec=rs2.getInt("zongshu"); db1.closeStat(); //rs2.close(); intpagecount=(totalrec+pageline-1)/pageline; //查询数据库 rs1 = db1.executeSql("select * from ct where cname like '%"+keywords+"%'"); %> <table width="751" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF"> <tr> <td width="544" valign="top"> <table width="541" border="1" bordercolordark="#ffffff" bordercolorlight="#18a6ff"> <tr> <td colspan="5"></td> </tr> <tr> <td nowrap> <div align="center">课程号</div> </td> <td nowrap> <div align="center">课程名</div> </td> <td nowrap> <div align="center">教师编号</div> </td> <td nowrap> <div align="center">教师姓名</div> </td> <td nowrap> <div align="center">选课人数</div> </td> <td nowrap> <div align="center">类别</div> </td> </tr> <% if(rs1!=null){ if(intpagecount>0) { for(i=1;i<=(intpage-1)*pageline;i++) rs1.next(); for(i=1;i<=pageline;i++){ if(rs1.next()){ String cid = rs1.getString("cid").trim(); String cname = rs1.getString("cname").trim(); String tid = rs1.getString("tid"); String tname = rs1.getString("tname"); int num = rs1.getInt("num"); %> <tr> <td nowrap> <div align="center"><%=cid%></div> </td> <td nowrap> <div align="center"><%=cname%></div> </td> <td nowrap> <div align="center"><%=tid%></div> </td> <td nowrap> <div align="center"><%=tname%></div> </td> <td nowrap> <div align="center"><%=num%></div> </td> <td nowrap> <div align="center"><%=c%></div> </td> </tr><% // 若总页数乘每页显示的数量小于总条数则总页数加一 if(intpagecount*pageline<totalrec) intpagecount++; //若当前页数大于总页数则当前页数等于总页数 if(intpage>intpagecount) intpage=intpagecount; if(intpage<1) intpage=1; %> <%} } rs1.close(); } }else{out.print("ERROR!");} %> </tr> </table> <table width="541" border="0" bordercolordark="#ffffff" bordercolorlight="#18a6ff"> <tr> <td colspan="5"><hr width="541" color="#6633FF"></td> </tr> <tr> <td colspan="5" nowrap height="21"> <div align="center"> <% if(intpage<2) out.print("首页上

评论收藏

内容反馈