java中如何将网页中的分页数据打印出来
展开全部
我写过的代码，仅供参考
类：package action;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import data.User;
public class UserListAction extends HttpServlet {
private static final long serialVersionUID = 1L;
public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
response.setContentType("text/html;charset=UTF-8");
String sql = " SELECT COUNT(*) AS RECORD_COUNT FROM (SELECT * FROM system_user) AS RECORD_TABLE ";
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
int showPage = 1;
int pageSize = 3;
int recordCount = -1;
int pageCount = -1;
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
if(rs.next()) {
recordCount = rs.getInt(1);
}
pageCount=(recordCount + pageSize -1) / pageSize;//总页数
String strShowPage = request.getParameter("showPage");
if(null!= strShowPage && !"".equals(strShowPage.trim())) {
showPage = Integer.parseInt(strShowPage.trim());
}
if(showPage <= 1) {
showPage = 1;
} else if(showPage >= pageCount) {
showPage=pageCount;
}
String querySql = "SELECT T1.* FROM system_user T1";
rs = stmt.executeQuery(querySql + " LIMIT " +( showPage - 1) * pageSize + " , " + pageSize);
List<User> userList = new ArrayList<User>();
while(rs.next()) {
userList.add(new User(rs.getInt(1),rs.getString(2),rs.getString(3)));
}
request.setAttribute("userList",userList);
request.setAttribute("showPage",showPage);
request.setAttribute("pageSize",pageSize);
request.setAttribute("recordCount",recordCount);
request.setAttribute("pageCount",pageCount);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
if(null !=rs && ! rs.isClosed()) {
rs.close();
}
if(null !=stmt && ! stmt.isClosed()) {
stmt.close();
}
if(null !=conn && ! conn.isClosed()) {
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
request.getRequestDispatcher("page03.jsp").forward(request, response);
}
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
this.doPost(request, response);
}
}
JavaBean:package data;
public class User {
private Integer userid;
private String username;
private String password;
public User() {
super();
}
public User(Integer userid, String username, String password) {
super();
this.userid = userid;
this.username = username;
this.password = password;
}
public Integer getUserid() {
return userid;
}
public void setUserid(Integer userid) {
this.userid = userid;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}
数据库分页：<%@ page language="java" contentType="text/html; charset=UTF-8"pageEncoding="UTF-8"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.ResultSet"%>
<!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=UTF-8">
<title>数据库分页</title>
</head>
<body>
<%
String strShowPage = request.getParameter("showPage");
String sql = "SELECT T1.* FROM system_user T1";
String countSql = "SELECT COUNT(*) AS RECORD_COUNT FROM (SELECT T1.* FROM system_user T1) AS RECORED_TABLE";
int recordCount = 0;
int pageSize = 3;
int showPage = -1;
%>
<%
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");
Statement stmt = conn.createStatement();
//获取总记录数
ResultSet countRS = stmt.executeQuery(countSql);
if(countRS.next()){
recordCount = countRS.getInt(1);
}
//计算总页数
int pageCount = (recordCount + pageSize - 1) / pageSize;
if(null == strShowPage || "".equals(strShowPage)){
showPage = 1;
} else {
showPage = Integer.parseInt(strShowPage);
if(showPage<=1){
showPage = 1;
}else if(showPage >= pageCount){
showPage = pageCount;
}
}
//获取当前页记录信息
ResultSet rs = stmt.executeQuery(sql + " LIMIT " + (showPage - 1) * pageSize + " , " + pageSize);
%>
<table border="1">
<tr><td>编号</td><td>用户名</td><td>密码</td></tr>
<%while(rs.next()){%>
<tr><td><%=rs.getInt(1)%></td><td><%=rs.getString(2)%></td><td><%=rs.getString(3)%></td></tr>
<%}%>
</table>
共<%=recordCount%>条记录
有<%=pageSize%>条记录
当前第<%=showPage%>页 共<%=pageCount%>页
<%if(showPage == 1){%>
首页 上一页
<%}else{%>
<a href="page.jsp?showPage=1">首页</a>
<a href="page.jsp?showPage=<%=showPage-1%>">上一页</a>
<%}%>
<%if(showPage == pageCount){%>
下一页 尾页
<%}else{%>
<a href="page.jsp?showPage=<%=showPage+1%>">下一页</a>
<a href="page.jsp?showPage=<%=pageCount%>">尾页</a>
<%}%>
<%conn.close();%>
</body>
</html>
分页：<%@ page language="java" contentType="text/html; charset=UTF-8"pageEncoding="UTF-8"%>
<%@page import="java.util.List" %>
<%@page import="data.User"%>
<!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=UTF-8">
<title>分页</title>
</head>
<body>
<%List<?> userList = (List<?>)request.getAttribute("userList");%>
<table border="1">
<tr><td>编号</td><td>用户名</td><td>密码</td></tr>
<%for(int i = 0; i < userList.size(); i++){ %>
<tr><td><%=((User)userList.get(i)).getUserid()%></td><td><%=((User)userList.get(i)).getUsername()%></td><td><%=((User)userList.get(i)).getPassword()%></td></tr>
<%}%>
</table>
<%
int showPage = (Integer)request.getAttribute("showPage");
int pageSize = (Integer)request.getAttribute("pageSize");
int recordCount = (Integer)request.getAttribute("recordCount");
int pageCount = (Integer)request.getAttribute("pageCount");
%>
<%if(showPage == 1){%>
首页 上一页
<%}else{%>
<a href="UserList.steven?showPage=1">首页</a>
<a href="UserList.steven?showPage=<%=showPage-1%>">上一页</a>
<%}%>
<%if(showPage == pageCount){%>
下一页 尾页
<%}else{%>
<a href="UserList.steven?showPage=<%=showPage+1%>">下一页</a>
<a href="UserList.steven?showPage=<%=pageCount%>">尾页</a>
<%}%>
</body>
</html>
类：package action;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import data.User;
public class UserListAction extends HttpServlet {
private static final long serialVersionUID = 1L;
public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
response.setContentType("text/html;charset=UTF-8");
String sql = " SELECT COUNT(*) AS RECORD_COUNT FROM (SELECT * FROM system_user) AS RECORD_TABLE ";
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
int showPage = 1;
int pageSize = 3;
int recordCount = -1;
int pageCount = -1;
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
if(rs.next()) {
recordCount = rs.getInt(1);
}
pageCount=(recordCount + pageSize -1) / pageSize;//总页数
String strShowPage = request.getParameter("showPage");
if(null!= strShowPage && !"".equals(strShowPage.trim())) {
showPage = Integer.parseInt(strShowPage.trim());
}
if(showPage <= 1) {
showPage = 1;
} else if(showPage >= pageCount) {
showPage=pageCount;
}
String querySql = "SELECT T1.* FROM system_user T1";
rs = stmt.executeQuery(querySql + " LIMIT " +( showPage - 1) * pageSize + " , " + pageSize);
List<User> userList = new ArrayList<User>();
while(rs.next()) {
userList.add(new User(rs.getInt(1),rs.getString(2),rs.getString(3)));
}
request.setAttribute("userList",userList);
request.setAttribute("showPage",showPage);
request.setAttribute("pageSize",pageSize);
request.setAttribute("recordCount",recordCount);
request.setAttribute("pageCount",pageCount);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
if(null !=rs && ! rs.isClosed()) {
rs.close();
}
if(null !=stmt && ! stmt.isClosed()) {
stmt.close();
}
if(null !=conn && ! conn.isClosed()) {
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
request.getRequestDispatcher("page03.jsp").forward(request, response);
}
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
this.doPost(request, response);
}
}
JavaBean:package data;
public class User {
private Integer userid;
private String username;
private String password;
public User() {
super();
}
public User(Integer userid, String username, String password) {
super();
this.userid = userid;
this.username = username;
this.password = password;
}
public Integer getUserid() {
return userid;
}
public void setUserid(Integer userid) {
this.userid = userid;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}
数据库分页：<%@ page language="java" contentType="text/html; charset=UTF-8"pageEncoding="UTF-8"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.ResultSet"%>
<!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=UTF-8">
<title>数据库分页</title>
</head>
<body>
<%
String strShowPage = request.getParameter("showPage");
String sql = "SELECT T1.* FROM system_user T1";
String countSql = "SELECT COUNT(*) AS RECORD_COUNT FROM (SELECT T1.* FROM system_user T1) AS RECORED_TABLE";
int recordCount = 0;
int pageSize = 3;
int showPage = -1;
%>
<%
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");
Statement stmt = conn.createStatement();
//获取总记录数
ResultSet countRS = stmt.executeQuery(countSql);
if(countRS.next()){
recordCount = countRS.getInt(1);
}
//计算总页数
int pageCount = (recordCount + pageSize - 1) / pageSize;
if(null == strShowPage || "".equals(strShowPage)){
showPage = 1;
} else {
showPage = Integer.parseInt(strShowPage);
if(showPage<=1){
showPage = 1;
}else if(showPage >= pageCount){
showPage = pageCount;
}
}
//获取当前页记录信息
ResultSet rs = stmt.executeQuery(sql + " LIMIT " + (showPage - 1) * pageSize + " , " + pageSize);
%>
<table border="1">
<tr><td>编号</td><td>用户名</td><td>密码</td></tr>
<%while(rs.next()){%>
<tr><td><%=rs.getInt(1)%></td><td><%=rs.getString(2)%></td><td><%=rs.getString(3)%></td></tr>
<%}%>
</table>
共<%=recordCount%>条记录
有<%=pageSize%>条记录
当前第<%=showPage%>页 共<%=pageCount%>页
<%if(showPage == 1){%>
首页 上一页
<%}else{%>
<a href="page.jsp?showPage=1">首页</a>
<a href="page.jsp?showPage=<%=showPage-1%>">上一页</a>
<%}%>
<%if(showPage == pageCount){%>
下一页 尾页
<%}else{%>
<a href="page.jsp?showPage=<%=showPage+1%>">下一页</a>
<a href="page.jsp?showPage=<%=pageCount%>">尾页</a>
<%}%>
<%conn.close();%>
</body>
</html>
分页：<%@ page language="java" contentType="text/html; charset=UTF-8"pageEncoding="UTF-8"%>
<%@page import="java.util.List" %>
<%@page import="data.User"%>
<!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=UTF-8">
<title>分页</title>
</head>
<body>
<%List<?> userList = (List<?>)request.getAttribute("userList");%>
<table border="1">
<tr><td>编号</td><td>用户名</td><td>密码</td></tr>
<%for(int i = 0; i < userList.size(); i++){ %>
<tr><td><%=((User)userList.get(i)).getUserid()%></td><td><%=((User)userList.get(i)).getUsername()%></td><td><%=((User)userList.get(i)).getPassword()%></td></tr>
<%}%>
</table>
<%
int showPage = (Integer)request.getAttribute("showPage");
int pageSize = (Integer)request.getAttribute("pageSize");
int recordCount = (Integer)request.getAttribute("recordCount");
int pageCount = (Integer)request.getAttribute("pageCount");
%>
<%if(showPage == 1){%>
首页 上一页
<%}else{%>
<a href="UserList.steven?showPage=1">首页</a>
<a href="UserList.steven?showPage=<%=showPage-1%>">上一页</a>
<%}%>
<%if(showPage == pageCount){%>
下一页 尾页
<%}else{%>
<a href="UserList.steven?showPage=<%=showPage+1%>">下一页</a>
<a href="UserList.steven?showPage=<%=pageCount%>">尾页</a>
<%}%>
</body>
</html>
本回答由提问者推荐
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
|
广告 您可能关注的内容 |
