基于Mysql的分页显示

来源：互联网发布：js input不可编辑状态编辑：程序博客网时间：2024/05/18 16:18

代码写在了下面，可以将Java代码进行封装，然后直接页面调用就行了，这样直接写在jsp页面中显得比较混乱，不过写下来防止忘记，方便查阅！！

<%@ page language="java" import="java.util.*" pageEncoding="GB18030"%>

<%@ page import="java.sql.*;"%>

String path = request.getContextPath();

String basePath = request.getScheme() + "://"

+ request.getServerName() + ":" + request.getServerPort()

+ path + "/";

<%!boolean flag = false;

String str = "";%>

String login = (String) session.getAttribute("login");

if (login != null && login.equals("true")) {

flag = true;

}

int pageSize = 3; //每页记录的条数

int pageNo = 0; //第几页

int tolPage = 0; //共几页

Class.forName("com.mysql.jdbc.Driver");

String url = "jdbc:mysql://localhost/bbs?user=root&password=wangkang";

Connection conn = DriverManager.getConnection(url);

Statement stmt = conn.createStatement();

ResultSet rs = null;

//关于分页的算法--计算总页数

Statement stmt1 = conn.createStatement();

rs = null;

rs = stmt1

.executeQuery("selectcount(*) from article where pid = 0");

rs.next();

int tolNum = rs.getInt(1);

stmt1.close();

//计算总页数

if (tolNum % pageSize == 0) {

tolPage = tolNum / pageSize;

} else {

tolPage = tolNum / pageSize + 1;

}

/**

*分页算法

String pageStr = request.getParameter("pageNo");

if (pageStr == null || pageStr.equals("")) {

pageNo = 1;

} else {

if (Integer.parseInt(pageStr) <= 0) {

pageNo = 1;

} else if (Integer.parseInt(pageStr) >= tolPage) {

pageNo = tolPage;

} else {

pageNo = Integer.parseInt(pageStr);

}

int pagePos = (pageNo - 1) * pageSize; //起始记录位置

//Mysql中关于分页的sql语句

rs = stmt

.executeQuery("select* from article where pid=0 order by pdate desc limit "

+ pagePos + "," + pageSize);

String strLogin = "";

String fStr = "";

while (rs.next()) {

if (flag) {

fStr = "<ahref='Delete.jsp?pid=" + rs.getInt("pid")

+ "&id=" + rs.getInt("id") + "'>删除</a>";

}

str += "<tr><td>" + rs.getInt("id") + "</td><td>"

+ "<ahref='ShowDetail.jsp?id=" + rs.getInt("id")

+ "'>" + rs.getString("title") + "</a>" + "</td><td>"

+ fStr + "</td></tr>";

}

//关于分页的算法--计算总页数

Statement stmt1 = conn.createStatement();

rs = null;

rs = stmt1

.executeQuery("selectcount(*) from article where pid = 0");

rs.next();

int tolNum = rs.getInt(1);

stmt1.close();

if (tolNum % 3 == 0) {

tolPage = tolNum / 3;

} else {

tolPage = tolNum / 3 + 1;

}

if (pageStr == null || pageStr.equals("")) {

pageNo = 1;

} else {

if (Integer.parseInt(pageStr) <= 0) {

pageNo = 1;

} else if(pageNo >= tolPage){

pageNo = tolPage;

} else {

pageNo = Integer.parseInt(pageStr);

}

rs.close();

stmt.close();

conn.close();

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>

<title>My JSP'ShowArticleTree.jsp' starting page</title>

<!--

-->

</head>

<body>

<a href="Post.jsp">增加新话题</a>

<%=str%>

str = "";

flag = false;

</table>

共<%=tolPage%>页  第<%=pageNo%>页

<br>

<br>

for (int i = 1; i <= tolPage; i++) {

第<%=i%>页

}

</select>

</form>

<input type="text" size=4 value=<%=pageNo%> name="pageNo">

</form>

</body>

</html>