jsp取数据后如何分页?
jsp取数据后如何分页
举一个实际的例子
我的jsp是这样的:
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="java.sql.*"%>
<%@ page language="java"%>
<jsp:useBean id="Displaybean" scope="page" class="mypackage.DbUtils"/>
<html>
<head>
<title>²¿ÃŹÜÀí</title>
</head>
<body bgcolor="#FFFFFF" text="#000000">
<table align="center">
<table border="0" align="center" width="550">
<tr bgcolor="#558493">
<td colspan="2">
<div align="center"><strong><font color="#FFFFFF">²¿ÃÅÐÅÏ¢±í</font></strong></div>
</td>
</tr>
</table>
<table border="0" align="center" width="550">
<tr bgcolor="#558493">
<td>
<div align="center"><font size="2" color="#FFFFFF">²¿ ÃÅ ±à ºÅ</font></div>
</td>
<td>
<div align="center"><font size="2" color="#FFFFFF">²¿ ÃÅ Ãû ³Æ</font></div>
</td>
<td>
<div align="center"><font size="2" color="#FFFFFF">²¿ ÃÅ ¼ò ½é</font></div>
</td>
<td>
<div align="center"><font size="2" color="#FFFFFF">Éϼ¶²¿ÃűàºÅ</font></div>
</td>
</tr>
</table>
<%
String Dcode="";
String Dname="";
String Descrip="";
String SDcode="";
String sql="select * from department order by ordercode(departmentcode)";
//String sql="select * from Department order by DepartmentCode asc";
ResultSet rs=null;
rs=Displaybean.executeQuery(sql);
while(rs.next())
{
Dcode=rs.getString("DepartmentCode");
Dname=rs.getString("DepartmentName");
Descrip=rs.getString("Description");
SDcode=rs.getString("SuperDepartmentCode");
%>
<table border=0 cellpadding="0" cellspacing="0" align="center">
<tr>
<td>
<input type="text" name="Dcode" value="<%=Dcode%>" size="10" style="border-style: groove">
<input type="text" name="Dname" value="<%=Dname%>" size="15" style="border-style: groove">
<input type="text" name="Descrip" value="<%=Descrip%>" size="30" style="border-style: groove">
<input type="text" name="SDcode" value="<%=SDcode%>" size="5" style="border-style: groove">
</td>
</tr>
</table>
<% }%>
<table align="center">
<tr>
<td>
<table align="left">
<form name="form2" method="post" action="rework1.jsp" align="right">
<input type="submit" value="Ð޸IJ¿ÃÅÐÅÏ¢" style='border:1 solid #619CE7;border-top:2 solid white;border-left:2 solid white;background-color:f5f5f5'>
</form>
</table>
</td>
<td>
<table align="center">
<form name="form3" method="post" action="add.html">
<input type="submit" value=" Ìí¼Óв¿ÃÅ " style='border:1 solid #619CE7;border-top:2 solid white;border-left:2 solid white;background-color:f5f5f5'>
</form>
</table>
</td>
<td>
<table align="right">
<form name="form1" method="post" action="deletepart.jsp">
<input type="submit" value="ɾ³ý²¿ÃÅÐÅÏ¢" style='border:1 solid #619CE7;border-top:2 solid white;border-left:2 solid white;background-color:f5f5f5'>
</form>
</table>
</td>
</tr>
</table>
</table>
</body>
</html>