问题描述
能够贴出来的更好，谢了
解决方案
解决方案二：
<%@pagelanguage="java"contentType="text/html;charset=GB18030"import="java.util.*"pageEncoding="GB18030"%><%@pageimport="com.xlh.userDao.*"%><%@pageimport="com.xlh.model.*"%><html><head><metahttp-equiv="Content-Type"content="text/html;charset="><linkhref="style/oa.css"rel="stylesheet"type="text/css"><scriptlanguage="javascript"src="script/public.js"></script><title>查看工会会员管理员</title><styletype="text/css"><!--a:link{text-decoration:none;}a:visited{text-decoration:none;color:#FF0000;}a:hover{text-decoration:underline;color:#0000FF;}a:active{text-decoration:none;color:#00FF00;}--></style><%//有几条消息//InfoDaoImpl_info=newInfoDaoImpl();//int_n=_info.getInfo();//if(_n>0){%><scripttype="text/javascript">functiondelAdmin(admin_id,pagesize){//alert('a');window.open('adminDel.do?adminId='+admin_id+'&pageSize='+pagesize);}functioneditAdmin(id,md,name,password,pagesize){//alert('a');//alert(id);openWin('edit_admin.jsp?id='+id+'&md='+md+'&username='+name+'&password='+password+'&pageSize='+pagesize,'addbook',600,300);}</script></head><BODYbgColor=#dee7ffleftMargin=0background=""topMargin=0marginheight="0"marginwidth="0"><center><TABLEwidth="778"border=0cellPadding=0cellSpacing=0borderColor=#ffffffbgColor=#dee7ffstyle="FONT-SIZE:10pt"><TBODY><TRheight=35><TDalign=middlewidth=20background=images/title_left.gifbgColor=#dee7ff></TD><TDalign=middlewidth=120background=images/title_left.gifbgColor=#dee7ff><FONTcolor=#f7f7f7>查看防陨管理员<fontcolor="#FFFFFF"> </font></FONT></TD><TDalign=middlewidth=11background=images/title_middle.gifbgColor=#dee7ff><FONTcolor=#f7f7f7> </FONT></TD><TDalign=middlebackground=images/title_right.gifbgColor=#dee7ff><FONTcolor=#f7f7f7> </FONT></TD></TR></TBODY></TABLE><TABLEwidth="778"border=0align=centercellPadding=0cellSpacing=0borderColor=#ffffffstyle="FONT-SIZE:10pt"><TBODY><TR><TDwidth="82%"height=14align=rightvAlign=centernoWrap> </TD><TDwidth="28%"align=centervAlign=centernoWrap><selectname="check_Number"><optionselectedvalue="0">请选择查询</option><optionvalue="1">姓名</option></select><inputtype="text"name="check_Name"size="13"onkeydown="check1()"><inputtype="button"value="查询"onClick="check()"><ahref="#"onClick="openWin('add_admin.jsp','addbook',600,300);">新增</a></TD><TDwidth="18%"align=rightvAlign=centernoWrap></TD></TR><TR><TDheight=28colspan="2"align=rightvAlign=centernoWrapbackground=images/list_middle.jpg> <!--可以在这里插入分页导航条--></TD></TR></TBODY></TABLE><tablewidth="778"border="0"cellPadding="0"cellSpacing="1"bgcolor="#6386d6"><!--列表标题栏--><trbgcolor="#EFF3F7"class="TableBody1"><tdwidth="10%"height="37"align="center"><B>用户名</B></td><tdwidth="18%"height="37"align="center"><b>门店</b></td><tdwidth="18%"height="37"align="center"><b>部门</b></td><tdwidth="18%"height="37"align="center"><b>职务</b></td><tdwidth="10%"height="37"align="center"><strong>权限</strong></td><tdwidth="10%"height="37"align="center"><strong>编辑</strong></td></tr><!--列表数据栏--><%intPageSize=1;try{if(request.getParameter("PageNumber")!=null){PageSize=Integer.parseInt(request.getParameter("PageNumber"));}}catch(Exceptione){PageSize=1;}if(PageSize<1){PageSize=1;}intcheckNumber=0;try{checkNumber=Integer.parseInt(request.getParameter("check_Number"));}catch(Exceptione){checkNumber=0;}StringcheckName=request.getParameter("check_Name");intaccount=UserDaoImpl.getAllUserCount();if(account%12==0)account=account/12;elseaccount=account/12+1;if(PageSize>account){PageSize=account;}System.out.println(request.getParameter("limit"));Listlist=UserDaoImpl.getListUser((PageSize-1)*13,13*PageSize,checkNumber,checkName,0);Iteratorit=list.iterator();booleanfalg=false;intcount=0;while(it.hasNext()){falg=true;count++;userTableadmin=(userTable)it.next();%><trbgcolor="#EFF3F7"class="TableBody1"onMouseOver="this.bgColor='#DEE7FF';"onMouseOut="this.bgColor='#EFF3F7';"><tdalign="center"vAlign="center"><%=admin.getUsername()%></td><tdalign="center"vAlign="center"><%=admin.getMd()%></td><tdalign="center"vAlign="center"><%=admin.getBm()%></td><tdalign="center"vAlign="center"><%=admin.getZw()%></td><tdalign="center"vAlign="center"><%switch(admin.getLimit()){case0:out.println("管理员");break;case1:out.println("门店管理员");break;case2:out.println("录入人员");break;case3:out.println("查看人员");break;}%></td><tdalign="center"vAlign="center"><ahref="#"onClick="editAdmin('','','','','');">修改</a> <ahref="#"onClick="delAdmin('<%=admin.getAdmin_id()%>',,'<%=PageSize%>');">删除</a></td></tr><%}%><%if(!falg){%><tr><tdcolspan="7"align="center"bgcolor="#EFF3F7"class="TableBody1"onMouseOver="this.bgColor='#DEE7FF';"onMouseOut="this.bgColor='#EFF3F7';">没有找到相应</td></tr><%}%></table><TABLEwidth="778"border=0align=centercellPadding=0cellSpacing=0borderColor=#ffffffstyle="FONT-SIZE:10pt"><TBODY><TR><TDheight=28align=rightvAlign=centernoWrapbackground=images/list_middle.jpg> <!--可以在这里插入分页导航条-->一总有<%=list.size()%>条<ahref="gly_manager.jsp?PageNumber=1">首页</a><ahref="gly_manager.jsp?PageNumber=<%=PageSize-1%>">上一页</a><ahref="${pageUrl}">${pageNumber}</a><ahref="gly_manager.jsp?PageNumber=<%=PageSize+1%>">下一页</a><ahref="gly_manager.jsp?PageNumber=<%=count%>">尾页</a></TD></TR></TBODY></TABLE></center></body></html>
解决方案三：
<%Class.forName("com.mysql.jdbc.Driver").newInstance();Stringurl="jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=gb2312";Stringusername="root";Stringpassword="19870626";Connectionconn=DriverManager.getConnection(url,username,password);intintPageSize;//一页显示的记录数intintRowCount;//记录总数intintPageCount;//总页数intintPage;//待显示的页码StringstrPage;inti;intPageSize=6;strPage=request.getParameter("page");if(strPage==null){intPage=1;}else{intPage=Integer.parseInt(strPage);if(intPage<1)intPage=1;}Statementstmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);Stringsql="select*frombook";ResultSetrs=stmt.executeQuery(sql);rs.last();intRowCount=rs.getRow();intPageCount=(intRowCount+intPageSize-1)/intPageSize;//就是总页数if(intPage>intPageCount){intPage=intPageCount;}if(intPageCount>0){rs.absolute((intPage-1)*intPageSize+1);//将记录指针定位到待显示页的第一条记录i=0;while(i<intPageSize&&!rs.isAfterLast()){%><tr><td><%=rs.getString("book_id")%></td><td><%=rs.getString("book_name")%></td><td><%=rs.getString("book_author")%></td><td><%=rs.getString("book_source")%></td><td><%=rs.getString("book_date")%></td><td><%=rs.getString("book_price")%></td><td><ahref="update.jsp">修改</a> <ahref="delete.jsp">删除</a></td></tr><%rs.next();i++;}}%></table><hrcolor="#999999"><divalign="center">第<%=intPage%>页共<%=intPageCount%>页<%if(intPage<intPageCount){%><ahref="book_mes.jsp?page=<%=intPage+1%>">下一页</a><%}%><%if(intPage>1){%><ahref="book_mes.jsp?page<%=intPage-1%>">上一页</a><%}%><%rs.close();stmt.close();conn.close();%>
解决方案四：
MVC实现的，JSP+Servlet+javabean
解决方案五：
JSP+Servlet+javabean实现分页，急需，谢了，有源代码的给贴出来
解决方案六：
model:你封装你的类就是了把上面的JSP里的分页代码写到你的servlet里然后再在JSP中做些相应的处理就可以了
解决方案七：
<%@pagelanguage="java"contentType="text/html;charset=gbk"pageEncoding="gbk"import="java.sql.*"%><!DOCTYPEhtmlPUBLIC"-//W3C//DTDHTML4.01Transitional//EN""http://www.w3.org/TR/html4/loose.dtd"><html><head><metahttp-equiv="Content-Type"content="text/html;charset=ISO-8859-1"><title>Inserttitlehere</title></head><body><%Stringipage=request.getParameter("page");intpageSize=6;inttotalPage=0;Stringurl="jdbc:odbc:stu";Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");Connectionconn=DriverManager.getConnection(url);Statementstmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);ResultSetrs1=stmt.executeQuery("selectcount(*)fromstudent");intlc=0;if(rs1.next()){lc=rs1.getInt(1);}rs1.close();if(lc%pageSize==0){totalPage=lc/pageSize;}else{totalPage=lc/pageSize+1;}ResultSetrs=stmt.executeQuery("select*fromstudentorderbynumber");if(ipage!=null){intl=(Integer.parseInt(ipage)-1)*pageSize;if(l!=0)rs.absolute(l);}else{ipage="1";}inti=0;while(rs.next()){Stringnum=rs.getString("number");out.println(num+"<br>");i++;if(i==pageSize)break;}rs.close();stmt.close();conn.close();%><br>您当前访问的是第<%=ipage%>页 总共有<%=totalPage%>页 总共有<%=lc%>条<br><ahref="dbv1.jsp?page=1">第一页</a> <%if(ipage.equals("1")){}else{%><ahref="dbv1.jsp?page=<%=Integer.parseInt(ipage)-1%>">上一页</a> <%}%><%if(ipage.equals(String.valueOf(totalPage))){}else{%><ahref="dbv1.jsp?page=<%=Integer.parseInt(ipage)+1%>">下一页</a><%}%><ahref="dbv1.jsp?page=<%=totalPage%>">最后一页</a><br><selectonChange="fun1(this.value)"><%for(intj=1;j<=totalPage;j++){%><optionvalue=<%=j%><%if(ipage.equals(String.valueOf(j))){out.println("selected");}%>><%=j%></option><%}%></select><scripttype="text/javascript">functionfun1(n){window.location.href="dbv1.jsp?page="+n;}</script></body></html>
解决方案八：
樓上正解。不過請把代碼按照相關的格式提出來，這樣看著才不累啊
解决方案九：
haochang
解决方案十：
为什么喜欢直接贴原码？我觉得还是把主要是思想说明白即可。可以稍微附带些代码~~