1.首先创建一个对象 UserData,用以保存从数据库中获取的数据。
[url=css.css]</head>
<body>
<div style="margin-top: 15%; margin-left: 25%">
<table>
<caption>SCOTT用户,EMP表中的数据</caption>
<%! int curPage,maxPage; %>
<% curPage =Integer.parseInt(request.getAttribute("curPage").toString()); %> <!--取得当前页-->
<% maxPage =Integer.parseInt((String)request.getAttribute("maxPage").toString()); %> <!--取得总页数-->
<%if (request.getAttribute("dataList") == null){
%>
<tr>
<td colspan="8">没有数据</td>
</tr>
<%
}else {
%>
<tr>
<!--表头-->
<th>EMPNO</th>
<th>ENAME</th>
<th>JOB</th>
<th>MGR</th>
<th>HIREDATE</th>
<th>SAL</th>
<th>COMM</th>
<th>DEPTNO</th>
</tr>
<%
List list = (List) request.getAttribute("dataList");
for (Object aList : list) {
UserData userData = (UserData) aList;
%>
<tr>
<!--取得表中数据-->
<td><%= userData.getEmpno() %></td>
<td><%= userData.getEname() %></td>
<td><%= userData.getJob() %></td>
<td><%= userData.getMgr() %></td>
<td><%= userData.getHireDate() %></td>
<td><%= userData.getSal() %></td>
<td><%= userData.getComm() %></td>
<td><%= userData.getDeptno() %></td>
</tr>
<%
}
}
%>
</table>
</div>
<div style="margin-top: 8%; margin-left: 29%">
第<%= curPage %>页,共<%= maxPage %>页
<%if (curPage > 1){
%>
<a href="Servlet?page=1">首页</a>
<a href="Servlet?page=<%=curPage - 1%>">上一页</a>
<%
}else {
%>
首页 上一页
<%
}%>
<%if (curPage < maxPage){
%>
<a href="Servlet?page=<%=curPage + 1%>">下一页</a>
<a href="Servlet?page=<%=maxPage %>">尾页</a>
<%
}else {
%>
下一页 尾页
<%
}%>
转至第 <form name="form1" action="Servlet" method="get">
<label>
<select name="page" onchange="document.form1.submit()">
<%for ( int i = 1; i <= maxPage; i++){
if (i == curPage){
%>
<!--当前页页码默认选中-->
<option selected value="<%= i%>"><%= i %></option>
<%
}else {
%>
<option value="<%= i %>"><%= i %></option>
<%
}
}%>
</select>
</label>
</form> 页
</div>
</body>
</html>
web.xml 中的配置文件为:
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
version="3.0">
<servlet>
<servlet-name>Servlet</servlet-name>
<servlet-class>com.servlet.Servlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>Servlet</servlet-name>
<url-pattern>/Servlet</url-pattern>
</servlet-mapping>
</web-app>
把项目部署到 Tomcat 服务器上,输入地址:http://localhost:8080/Servlet 这样就可以看到效果