登录
当前位置： 首页 > 编程笔记 >

jsp servlet javaBean后台分页实例代码解析

堵飞鸿
2023-03-14
本文向大家介绍jsp servlet javaBean后台分页实例代码解析，包括了jsp servlet javaBean后台分页实例代码解析的使用技巧和注意事项，需要的朋友参考一下

首先后台分页需要理清分页思路，把数据库里面需要分页的信息放到List集合中，然后按照页面反馈给后台的页码对List集合进行SubList切割把切完的List传到前端进行显示。

1.分页的demo文件结构图

导入的包

2.代码

SplitPageServlet代码

package ActionServlet;

import java.io.IOException;
import java.sql.SQLException;
import java.util.ArrayList;
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 Bean.ProjectBean;
import Service.SplitPage;

/**
 * Servlet implementation class SplitPageServlet
 */
@WebServlet("/SplitPageServlet")
public class SplitPageServlet extends HttpServlet {
 private static final long serialVersionUID = 1L;
  
 /**
  * @see HttpServlet#HttpServlet()
  */
 public SplitPageServlet() {
  super();
  // TODO Auto-generated constructor stub
 }

 /**
  * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
  */
 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  // TODO Auto-generated method stub
  List<ProjectBean>listArr = new ArrayList<ProjectBean>();
  String currrentPageString = request.getParameter("currrentPage");
  String numberForSplitPage = request.getParameter("numberForSplitPage");
  if( currrentPageString ==null){
   currrentPageString = "1";
  }
  if( numberForSplitPage == null){
   numberForSplitPage = "5";
  }
  SplitPage splitPage = new SplitPage();
  try {
   listArr = splitPage.AllSplitPage(numberForSplitPage, currrentPageString);
   request.setAttribute("subResult", listArr);
  } catch (ClassNotFoundException | SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  System.out.println(SplitPage.pageNumber);
  System.out.println(SplitPage.currentPageIndex);
  request.setAttribute("pageNumber", SplitPage.pageNumber);
  request.setAttribute("currentPageIndex", SplitPage.currentPageIndex);
  request.getRequestDispatcher("/servlet/ShowViewIndex").forward(request, response);
  
 }

 /**
  * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
  */
 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  // TODO Auto-generated method stub
  doGet(request, response);
 }

}

ProjectBean代码

package Bean;

public class ProjectBean {
 private String projectId = null;
 private String projectName = null;
 private String projectType = null;
 private String userNo = null;
 private String projectUser = null;
 public String getProjectId(){
  if(projectId==null){
   projectId ="";
  }
  return this.projectId;
 }
 public void setProjectId(String projectId){
  this.projectId = projectId;
 }
 
 public void setProjectName(String projectName){
  this.projectName = projectName;
 }
 
 public String getProjectName(){
  return this.projectName;
 }
 
 public void setType(String projectType){
  this.projectType = projectType;
 }
 
 public String getProjectType(){
  return this.projectType;
 }
 
 public void setUserNo(String userNo){
  this.userNo = userNo;
 }
 
 public String getUserNo(){
  return this.userNo;
 }
 
 public void setProjectUser(String projectUser){
  this.projectUser = projectUser;
 }
 
 public String getProjectUser(){
  return this.projectUser;
 }
 
}

SplitPageBean 代码

package Bean;

public class SplitPageBean {
 private int allitems;//总的记录数
 private int currentRecord;//当前的记录数
 private int lastPageRecord ; //上一页记录数开始数
 private int nextPageRecord;//下一页记录数开始数
 private int lastPageIndex ; //上一页
 private int nextPageIndex;//下一页
 private int currentPageIndex;//当前页
 private int numberForSplitPage;//每页分的数量
 private int allPageNumber;

 public int getAllitems(){
  return this.allitems;
 }
 public void setAllitems(int allitems){
  this.allitems = allitems; 
 }
 
 public int getCurrentRecord(){
  return this.currentRecord;
 }
 public void setCurrentRecord(int currentPageIndex){
  this.currentRecord = currentPageIndex * this.numberForSplitPage; 
 }
 
 public int getlastPageRecord(){
  return this.lastPageRecord;
 }
 public void setLastPageRecord(int lastPageIndex){
  this.lastPageRecord = lastPageIndex * this.numberForSplitPage; 
 }
 
 public int getNextPageRecord(){
  return this.nextPageRecord;
 }
 public void setNextPageRecord(int nextPageIndex){
  this.nextPageRecord = nextPageIndex * this.numberForSplitPage; 
 }
 
 public int getLastPageIndex(){
  return this.lastPageIndex;
 }
 public void setLastPageIndex(int currentPageIndex){
  this.lastPageIndex = currentPageIndex - 1; 
 }
 
 public int getNextPageIndex(){
  return this.nextPageIndex;
 }
 public void setNextPageIndex(int currentPageIndex){
  this.nextPageIndex = currentPageIndex - 1; 
 }
 
 public int getCurrentPageIndex(){
  return this.currentPageIndex;
 }
 public void setCurrentPageIndex(int currentPageIndex){
  this.currentPageIndex = currentPageIndex; 
 }
 
 public int getNumberForSplitPage(){
  return this.numberForSplitPage;
 }
 public void setNumberForSplitPage(int numberForSplitPage){
  this.numberForSplitPage = numberForSplitPage; 
 }
 
 public int getAllPageNumber(){
  return this.allPageNumber;
 }
 public void setAllPageNumber(int allitems){
  this.allPageNumber = allitems / this.numberForSplitPage + 1; 
 } 
 
}

QueryProject代码

package Dao;

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

import Bean.ProjectBean;
import Service.ConnectDataBase;

public class QueryProject {
 private List<ProjectBean> listArr = new ArrayList();
 public List<ProjectBean> QueryAllProject() throws ClassNotFoundException, SQLException{
  Connection conn=null;
  Statement stat=null;
  ResultSet rs=null;
  ConnectDataBase connectDataBase =new ConnectDataBase();
  conn = connectDataBase.connect();
  stat = conn.createStatement();
  rs = stat.executeQuery("select*from project");
  
  while(rs.next()){
   ProjectBean projectBean = new ProjectBean();
   projectBean.setProjectId(rs.getString("projectId"));
   projectBean.setProjectName(rs.getString("projectName"));
   projectBean.setType(rs.getString("projectType"));
   projectBean.setUserNo(rs.getString("UserNo"));
   projectBean.setProjectUser(rs.getString("projectUser"));
   listArr.add(projectBean);
  }
  connectDataBase.close(stat, conn);
  return listArr;
 }
// public static void main(String[] args) throws ClassNotFoundException, SQLException{
//  List<ProjectBean> listArr = new ArrayList();
//  QueryProject queryProject = new QueryProject();
//  listArr = queryProject.QueryAllProject();
//  ProjectBean projectBean = new ProjectBean();
//  projectBean = listArr.get(0);
//  System.out.println(projectBean.getProjectId());
//  projectBean = listArr.get(2);
//  System.out.println(projectBean.getProjectId());
//  System.out.println(listArr.size());
// }
}

ConenctDataBase代码

package Service;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class ConnectDataBase {
 private String url = "jdbc:MySQL://localhost:3306/zhongchuangweb";
 private String user = "root";
 private String password = "12345";
 
 public Connection connect() throws ClassNotFoundException, SQLException{
   Class.forName("com.mysql.jdbc.Driver");
   Connection conn = DriverManager.getConnection(url,user,password); 
   return conn;
 }
 //关闭数据库资源
 public void close(Statement stat,Connection conn) throws SQLException{
  if(stat!=null){
    stat.close();
  }
  if(conn!=null){
    conn.close();
  }
 }
}

SplitPage代码

package Service;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import Bean.ProjectBean;
import Bean.SplitPageBean;
import Dao.QueryProject;

public class SplitPage {
 public static int pageNumber;
 public static int currentPageIndex;
 private List<ProjectBean> splitArr = new ArrayList(); 

 {
  QueryProject queryProject = new QueryProject();
  try {
   splitArr = queryProject.QueryAllProject();
  } catch (ClassNotFoundException | SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
 }
 public List<ProjectBean> AllSplitPage(String numberForSplitPage,String requestPageIndex) throws ClassNotFoundException, SQLException{
  List<ProjectBean> result = new ArrayList<ProjectBean>(); 
  int numberForSplitPageInt = Integer.parseInt(numberForSplitPage);//每页的数量
  int requestPageIndexInt = Integer.parseInt(requestPageIndex);//请求的页码
  SplitPageBean splitPageBean = new SplitPageBean();
  splitPageBean.setAllitems(splitArr.size());//设置总的记录数
  splitPageBean.setNumberForSplitPage(numberForSplitPageInt);//设置每页的记录数量
  splitPageBean.setAllPageNumber(splitArr.size());
  pageNumber = splitPageBean.getAllPageNumber();
  splitPageBean.setCurrentPageIndex(requestPageIndexInt);//设置请求页页码
  currentPageIndex = splitPageBean.getCurrentPageIndex();
  splitPageBean.setLastPageRecord(requestPageIndexInt-1);
  if(splitPageBean.getAllitems()<splitPageBean.getNumberForSplitPage()){
   result = splitArr;
  }else if(splitPageBean.getCurrentPageIndex()*splitPageBean.getNumberForSplitPage() > splitPageBean.getAllitems()){
   result = splitArr.subList(splitPageBean.getlastPageRecord(),splitPageBean.getAllitems());
  }else{
   result = splitArr.subList(splitPageBean.getlastPageRecord(),splitPageBean.getlastPageRecord()+splitPageBean.getNumberForSplitPage());//SubList用法不包含末尾索引
  }
  return result;
 }
 
// public static void main(String[] args) throws ClassNotFoundException, SQLException{
//  List<ProjectBean> TestResult = new ArrayList<ProjectBean>(); 
//  ProjectBean projectBean = new ProjectBean();
//  SplitPage splitPage = new SplitPage();
//  TestResult = splitPage.AllSplitPage("5","1");
//  projectBean = TestResult.get(0);
//  System.out.println(projectBean.getProjectId());
//  projectBean = TestResult.get(1);
//  System.out.println(projectBean.getProjectId());
//  projectBean = TestResult.get(2);
//  System.out.println(projectBean.getProjectId());
//  projectBean = TestResult.get(3);
//  System.out.println(projectBean.getProjectId());
//  projectBean = TestResult.get(4);
//  System.out.println(projectBean.getProjectId());
//  projectBean = TestResult.get(5);
//  System.out.println(projectBean.getProjectId());
//    
// }

}

显示层
ShowViewIndex代码

package View;

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

/**
 * Servlet implementation class ShowViewIndex
 */
@WebServlet("/ShowViewIndex")
public class ShowViewIndex extends HttpServlet {
 private static final long serialVersionUID = 1L;
  
 /**
  * @see HttpServlet#HttpServlet()
  */
 public ShowViewIndex() {
  super();
  // TODO Auto-generated constructor stub
 }

 /**
  * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
  */
 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  // TODO Auto-generated method stub
  request.getRequestDispatcher("/NewFile.jsp").forward(request, response);
 }

 /**
  * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
  */
 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  // TODO Auto-generated method stub
  doGet(request, response);
 }

}

jsp页面代码

<%@ page language="java" contentType="text/html; charset=utf-8"
 pageEncoding="utf-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!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=ISO-8859-1">
<title>数据库内容分页显示</title>
<style type="text/css">
*{ margin:0; padding:0;}
ul li{ width:50px; height:24px; line-height:24px; float:left; margin-left:0px; display:inline; margin-top:5px; overflow:hidden;}
ul li button{width:50px;height:24px;margin:0px;padding:0px;}
</style>
</head>
<body>
 <table>
  <thead>
   <tr>
    <th style="text-align:center;">编号</th>
    <th style="text-align:center;">名称</th>
    <th style="text-align:center;">类型</th>
    <th style="text-align:center;">学号</th>
    <th style="text-align:center;">负责人</th>
   </tr>
  </thead>
  <tbody>
    <c:forEach var="project" items="${subResult}">
     <tr>
      <td><c:out value="${project.projectId}"></c:out></td>
      <td><c:out value="${project.projectName}"></c:out></td>
      <td><c:out value="${project.projectType}"></c:out></td>
      <td><c:out value="${project.userNo}"></c:out></td>
      <td><c:out value="${project.projectUser}"></c:out></td>
     </tr>
    </c:forEach>
  </tbody>
 </table>
 <div align = "center">
    <ul>
    <c:choose>
     <c:when test="${currentPageIndex>1}">
       <li><a href="${pageContext.request.contextPath}/servlet/SplitPageServlet?currrentPage=${currentPageIndex-1}"><button><</button></a></li>
     </c:when>
     <c:otherwise>
       <li><a><button><</button></a></li>
     </c:otherwise>
    </c:choose>
     <%
        int i =(Integer)request.getAttribute("pageNumber");
       for (int j=0;j<i;j++)
       {%>
       <li><a href="${pageContext.request.contextPath}/servlet/SplitPageServlet?currrentPage=<%=j+1%>"><button><%=j+1%></button></a></li>
      <%}%>
     <c:choose>
     <c:when test="${currentPageIndex+1<=pageNumber}">
       <li><a href="${pageContext.request.contextPath}/servlet/SplitPageServlet?currrentPage=${currentPageIndex+1}"><button>></button></a></li>
     </c:when>
     <c:otherwise>
       <li><a><button>></button></a></li>
     </c:otherwise>
    </c:choose>
    </ul> 
   </div> 
</body>
</html>

xml代码

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" version="2.5">
 <display-name></display-name>
 <welcome-file-list>
 <welcome-file>SplitPageServlet</welcome-file>
 </welcome-file-list> 
 <servlet>
 <servlet-name>ShowViewIndex</servlet-name>
 <servlet-class>View.ShowViewIndex</servlet-class>
 </servlet>
 <servlet-mapping>
 <servlet-name>ShowViewIndex</servlet-name>
 <url-pattern>/servlet/ShowViewIndex</url-pattern>
 </servlet-mapping>
 <servlet>
 <servlet-name>SplitPageServlet</servlet-name>
 <servlet-class>ActionServlet.SplitPageServlet</servlet-class>
 </servlet>
 <servlet-mapping>
 <servlet-name>SplitPageServlet</servlet-name>
 <url-pattern>/servlet/SplitPageServlet</url-pattern>
 </servlet-mapping>
</web-app>

运行结果展示


数据库describe


同时在本次demo中认识到了xml的中使用欢迎界面通过  <welcome-file-list>  <welcome-file>静态界面（jsp html）</welcome-file> </welcome-file-list>还可以使用servlet直接用servlet名即可。
初学java和javaee 写一点自己做的东西，代码写的不是很规范，不喜勿喷。

以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持小牛知识库。

 类似资料：
  • Java实现分页的前台页面和后台代码

    本文向大家介绍Java实现分页的前台页面和后台代码，包括了Java实现分页的前台页面和后台代码的使用技巧和注意事项，需要的朋友参考一下 本文实例为大家分享了Java分页展示的具体代码，供大家参考，具体内容如下 先上图吧，大致如图，也就提供个思路（ps：使用了SSH框架） 前台JSP页面 action service dao 以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持呐喊教

  • Json实现传值到后台代码实例

    本文向大家介绍Json实现传值到后台代码实例，包括了Json实现传值到后台代码实例的使用技巧和注意事项，需要的朋友参考一下 1.定义一个键值对对象 2.在点击表单的提交buttom的方法中： 3.把数组转换成json字符串 var postData = JSON.stringify(array); 4.使用ajax提交数据 5.java后端使用request拿到json数据 以上就是本文的全部内容

  • Django框架 Pagination分页实现代码实例

    本文向大家介绍Django框架 Pagination分页实现代码实例，包括了Django框架 Pagination分页实现代码实例的使用技巧和注意事项，需要的朋友参考一下 一、自定义分页 1、基础版自定义分页 2、封装保存版 3、封装保存版使用指南 二、Django内置分页 1、内置分页view部分 2、内置分页HTML部分 以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持呐喊

  • Java List分页功能实现代码实例

    本文向大家介绍Java List分页功能实现代码实例，包括了Java List分页功能实现代码实例的使用技巧和注意事项，需要的朋友参考一下 这篇文章主要介绍了Java List分页功能实现代码实例,文中通过示例代码介绍的非常详细，对大家的学习或者工作具有一定的参考学习价值,需要的朋友可以参考下 今天，工作上，由于业务的一些特殊性，需要拿到数据后在java代码中进行分页。 写了一个工具类，记录如下：

  • php分页函数完整实例代码

    本文向大家介绍php分页函数完整实例代码，包括了php分页函数完整实例代码的使用技巧和注意事项，需要的朋友参考一下 本文分享一例php分页函数完整实例代码，使用此函数实现分页效果很不错。分享给大家供大家参考。 具体功能代码如下： 相信本文所述对大家PHP程序设计的学习有一定的借鉴价值。

  • jQuery Ajax 实现分页 kkpager插件实例代码

    本文向大家介绍jQuery Ajax 实现分页 kkpager插件实例代码，包括了jQuery Ajax 实现分页 kkpager插件实例代码的使用技巧和注意事项，需要的朋友参考一下 代码片段一： 代码片段二： 代码片段三： 下面这段代码：在原版上修改过，由于ajax分页不能及时更新总页数 下面是插件kkpager.js代码： 下面是插件kkpager_blue.css代码： 总结 以上所述是小编

相关阅读

php分页函数完整实例代码jQuery Ajax 实现分页 kkpager插件实例代码ASP.NET和MSSQL高性能分页实例代码springmvc+mybatis 做分页sql 语句实例代码jQuery无刷新分页完整实例代码

相关文章

美团-后台开发实习腾讯后台实习二面[实例]爬虫抓取网页字节后端实习面经（中台）腾讯云智—后台实习面经

相关问答

分页结果上的REST状态代码204代号One-BrowserComponent：使web页面始终在后台工作解析后台网址失败（...）在后台解析Json失败WordPress在短代码中解析短代码

相关工具

摸鱼低代码平台一站式代码示例库悦视频后台md5和sha加密代码实现微软一站式示例代码浏览器

相关文档

及策实时分析平台帮助文档30 秒就能理解的 JavaScript 代码片段Tendermint 源码分析Memcached 源码分析Tornado 源码解析
快捷导航： 新手教程 算法原理 架构设计 Java进阶 数据库进阶 大厂专栏 面试经验 编程笔记 编程问答 所有专题 文档资料 工具软件 电子书籍 小牛导航
在线工具： 房贷计算器 个税计算器 Linux命令查询 Json格式化 正则表达式 颜色转换 AES加解密 SHA1加密 MD5加密 毒鸡汤 字数统计 随机密码生成 进制转换 Base64编解码 励志句子
Copyright © 2019-2024 小牛知识库@xnip.cn. All Rights Reserved.