java 学习笔记-servlet翻页小Demo

package com.j1702.model;

public class BookBean {
    public static final int PAGE_SIZE = 2; // 每页记录数
    private int id;         // 编号
    private String name;    // 图书名称
    private double price;   // 定价
    private int bookCount;  // 数量
    private String author;  // 作者

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public double getPrice() {
        return price;
    }

    public void setPrice(double price) {
        this.price = price;
    }

    public int getBookCount() {
        return bookCount;
    }

    public void setBookCount(int bookCount) {
        this.bookCount = bookCount;
    }

    public String getAuthor() {
        return author;
    }

    public void setAuthor(String author) {
        this.author = author;
    }

}

package com.j1702.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import com.j1702.db.DBUtil;
import com.j1702.model.BookBean;

public class BookDao {

    /**
     * 分页查询所有商品信息
     * @param page 页数
     * @return List<Book>
     */
    public List<BookBean> find(int page) {
        List<BookBean> list = new ArrayList<>(); // 创建List
        Connection conn = DBUtil.geConnection(); // 获取数据库连接
        // 分页查询的SQL语句
        String sql = "select * from Book order by id asc limit ?,?";
        try {
            PreparedStatement ps = conn.prepareStatement(sql); // 获取PreparedStatement
            ps.setInt(1, (page - 1) * BookBean.PAGE_SIZE); // 对SQL语句中的第1个参数赋值
            ps.setInt(2, BookBean.PAGE_SIZE); // 对SQL语句中的第2个参数赋值
            ResultSet rs = ps.executeQuery(); // 执行查询操作
            while (rs.next()) { // 光标向后移动，并判断是否有效
                BookBean b = new BookBean(); // 实例化BookBean
                b.setId(rs.getInt("id")); // 对id属性赋值
                b.setName(rs.getString("name")); // 对name属性赋值
                b.setPrice(rs.getFloat("price")); // 对price属性赋值
                b.setBookCount(rs.getInt("bookCount")); // 对bookCount属性赋值
                b.setAuthor(rs.getString("author")); // 对author属性赋值
                list.add(b); // 将BookBean添加到List集合中
            }
            rs.close(); // 关闭ResultSet
            ps.close(); // 关闭PreparedStatement
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return list;
    }

    /**
     * 查询总记录数
     * @return 总记录数
     */
    public int findCount() {
        int count = 0; // 总记录数
        Connection conn = DBUtil.geConnection(); // 获取数据库连接
        String sql = "select count(*) from Book"; // 查询总记录数SQL语句
        try {
            Statement stmt = conn.createStatement(); // 创建Statement
            ResultSet rs = stmt.executeQuery(sql); // 查询并获取ResultSet
            if (rs.next()) { // 光标向后移动，并判断是否有效
                count = rs.getInt(1); // 对总记录数赋值
            }
            rs.close(); // 关闭ResultSet
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return count; // 返回总记录数
    }
}

package com.j1702.service;

import java.io.IOException;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.j1702.dao.BookDao;
import com.j1702.model.BookBean;

@WebServlet("/") // 配置Servlet为默认执行页
public class FindServlet extends HttpServlet {
    private static final long serialVersionUID = 1L;

    public FindServlet() {
        super();
    }
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        System.out.println("执行GET请求的方法");
        int currPage = 1; // 当前页码
        if (request.getParameter("page") != null) { // 判断传递页码是否有效
            currPage = Integer.parseInt(request.getParameter("page"));// 对当前页码赋值
        }
        BookDao dao = new BookDao(); // 实例化BookDao
        List<BookBean> list = dao.find(currPage); // 查询所有图书信息
        System.out.println(list);
        request.setAttribute("list", list); // 将list放置到request中
        int pages; // 总页数
        int count = dao.findCount(); // 查询总记录数
        if (count % BookBean.PAGE_SIZE == 0) { // 计算总页数,总记录数和每页显示的数
            pages = count / BookBean.PAGE_SIZE; // 对总页数赋值
        } else {
            pages = count / BookBean.PAGE_SIZE + 1; // 对总页数赋值
        }
        StringBuffer sb = new StringBuffer(); // 实例化StringBuffer
        for (int i = 1; i <= pages; i++) { // 通过循环构建分页导航条
            if (i == currPage) { // 判断是否为当前页
                sb.append("『" + i + "』"); // 构建分页导航条
            } else {
                // 构建分页导航条
                sb.append("<a href='FindServlet?page=" + i + "'>" + i + "</a>");
            }
            sb.append("　"); // 构建分页导航条
        }
        request.setAttribute("bar", sb.toString()); // 将分页导航条的字符串放置到request中
        // 转发到bookList.jsp页面
        request.getRequestDispatcher("bookList.jsp").forward(request, response);
    }
}

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ page import="java.util.*"%>
<%@ page import="com.j1702.model.BookBean"%>
<!DOCTYPE HTML>
<html>
<head>
<meta charset="utf-8">
<title>显示图书列表</title>
<style type="text/css">
td,th {
    padding: 5px;
    background-color: #FFFFFF;
}
.div1{
    width:98%;
    text-align: center;
}
.div2{
    width:98%;
    text-align: center;
    padding:10px 0 0 0 ;
}
table{
    width:98%;
    border:0;
    text-align: center;
    background-color: #666666;

}
</style>
</head>
<body>
    <div class="div1">
        <h2>分页显示图书列表</h2>
    </div>
    <table>
        <tr>
            <th>ID</th>
            <th>图书名称</th>
            <th>价格</th>
            <th>数量</th>
            <th>作者</th>
        </tr>
<%
// 获取图书信息集合         
List<BookBean> list = (List<BookBean>)request.getAttribute("list");
// 判断集合是否有效
    if (list == null || list.size() < 1) {
        out.print("<tr><td colspan='5'>没有任何图书信息！</td></tr>");
    } else {
        // 遍历图书集合中的数据
        for (BookBean book : list) {
%>
        <tr align="center">
            <td><%=book.getId()%></td>
            <td><%=book.getName()%></td>
            <td><%=book.getPrice()%></td>
            <td><%=book.getBookCount()%></td>
            <td><%=book.getAuthor()%></td>
        </tr>
<%
    }
}
%>
    </table>
    <div class="div2">
        <%=request.getAttribute("bar")%>
    </div>  
</body>
</html>