数据库信息的web网页化显示——分页

一、Java代码

package com.study.web.servlet;

import com.study.web.entity.Book;
import com.study.web.entity.Student;
import com.study.web.util.JDBCUtil;
import com.study.web.util.PageInfo;
import com.study.web.vo.StudentBanji;
import com.sun.jmx.snmp.SnmpNull;
import com.sun.xml.internal.ws.addressing.WsaTubeHelper;

import javax.print.attribute.standard.Finishings;
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 java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

@WebServlet("/book")
public class BookServlet extends HttpServlet {
   
    // 访问Servlet默认访问service方法
    @Override
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
   
        System.out.println("BookServlet.service");
        // 解决post请求乱码问题
        req.setCharacterEncoding("UTF-8");

        // 把所有和书籍相关的增删改查放到一个Servlet
        //http://localhost:8080/JavaWeb/book?menthod=select
        //http://localhost:8080/JavaWeb/book?menthod=deleteById&id=2
        //http://localhost:8080/JavaWeb/book?menthod=insert
        String method = req.getParameter("method");
        if (method == null || method == "") {
   
            method = "selectByPage";
        }

        switch (method) {
   
            case "selectByPage":
                selectByPage(req,resp);
                break;
        }
    }

    private void selectByPage(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
   
        System.out.println("BookServlet.selectByPage");
        // 得到分页的页数
        String pageNoStr = req.getParameter("pageNo");
        if (pageNoStr == null || pageNoStr.equals("")) {
   
            pageNoStr = "1";
        }
        // 得到每一页存储的数据记录数
        String pageSizeStr = req.getParameter(