实现一个新闻列表的功能，并且具有分页的功能

最新推荐文章于 2023-05-13 11:22:46 发布

原创最新推荐文章于 2023-05-13 11:22:46 发布 · 875 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#分页 #新闻列表

经验积累专栏收录该内容

7 篇文章

订阅专栏

本文介绍如何实现一个新闻列表展示，并集成分页功能，允许用户浏览不同页面的内容。文章提供了一个基本的实现思路和最终的效果图。

<%@page import="java.sql.Date"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!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>
<table border="1" spacing="2" width="80%">
<%!public static final String DRIVER = "com.mysql.jdbc.Driver";
public static final String USER = "root";
public static final String PASS = "123456";
public static final String URL = "jdbc:mysql://localhost:3306/abc?useUnicode=true&characterEncoding=UTF-8";
public static final int PAGESIZE = 10;
int pageCount;
int curPage = 1;%>
<%
//一页放5个
String user = null;
String pass = null;
try {
Class.forName(DRIVER);
Connection con = DriverManager.getConnection(URL, USER, PASS);
String sql = "select * from taolun";
PreparedStatement stat = con
.prepareStatement(sql, ResultSet.TYPE_FORWARD_ONLY,
ResultSet.CONCUR_READ_ONLY);
ResultSet rs = stat.executeQuery();
rs.last();
int size = rs.getRow();
pageCount = (size % PAGESIZE == 0) ? (size / PAGESIZE) : (size
/ PAGESIZE + 1);
String tmp = request.getParameter("curPage");
if (tmp == null) {
tmp = "1";
}
curPage = Integer.parseInt(tmp);
if (curPage >= pageCount)
curPage = pageCount;
boolean flag = rs.absolute((curPage - 1) * PAGESIZE + 1);
out.println(curPage);
int count = 0;

do {
if (count >= PAGESIZE)
break;
String content = rs.getString(2);
Date date = rs.getDate(3);
count++;
%>
<tr>
<td><%=content%></td>
<td><%=date%></td>
</tr>
<%
} while (rs.next());
con.close();
} catch (Exception e) {

}
%>
</table>
<a href="taolun.jsp?curPage=1">首页</a>
<a href="taolun.jsp?curPage=<%=curPage - 1%>">上一页</a>
<a href="taolun.jsp?curPage=<%=curPage + 1%>">下一页</a>
<a href="taolun.jsp?curPage=<%=pageCount%>">尾页</a> 第<%=curPage%>页/共<%=pageCount%>页

</body>

</html>

以上便可以实现类列表+分页，以下是效果图样式可以自己控制：