DDR爱好者之家 Design By 杰米
首先后台分页需要理清分页思路，把数据库里面需要分页的信息放到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"><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"><button><%=j+1%></button></a></li>
<%}%>
<c:choose>
<c:when test="${currentPageIndex+1<=pageNumber}">
<li><a href="${pageContext.request.contextPath}/servlet/SplitPageServlet"><button</button></a></li>
</c:when>
<c:otherwise>
<li><a><button</button></a></li>
</c:otherwise>
</c:choose>
</ul>
</div>
</body>
</html>
xml代码
<"1.0" encoding="UTF-8""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 写一点自己做的东西，代码写的不是很规范，不喜勿喷。
以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持。
DDR爱好者之家 Design By 杰米
广告合作：本站广告合作请联系QQ：858582 申请时备注：广告合作（否则不回）
免责声明：本站资源来自互联网收集,仅供用于学习和交流,请遵循相关法律法规,本站一切资源不代表本站立场,如有侵权、后门、不妥请联系本站删除！
免责声明：本站资源来自互联网收集,仅供用于学习和交流,请遵循相关法律法规,本站一切资源不代表本站立场,如有侵权、后门、不妥请联系本站删除！
DDR爱好者之家 Design By 杰米
暂无评论...
《魔兽世界》大逃杀！60人新游玩模式《强袭风暴》3月21日上线
暴雪近日发布了《魔兽世界》10.2.6 更新内容，新游玩模式《强袭风暴》即将于3月21 日在亚服上线，届时玩家将前往阿拉希高地展开一场 60 人大逃杀对战。
艾泽拉斯的冒险者已经征服了艾泽拉斯的大地及遥远的彼岸。他们在对抗世界上最致命的敌人时展现出过人的手腕，并且成功阻止终结宇宙等级的威胁。当他们在为即将于《魔兽世界》资料片《地心之战》中来袭的萨拉塔斯势力做战斗准备时，他们还需要在熟悉的阿拉希高地面对一个全新的敌人──那就是彼此。在《巨龙崛起》10.2.6 更新的《强袭风暴》中，玩家将会进入一个全新的海盗主题大逃杀式限时活动，其中包含极高的风险和史诗级的奖励。
《强袭风暴》不是普通的战场，作为一个独立于主游戏之外的活动，玩家可以用大逃杀的风格来体验《魔兽世界》，不分职业、不分装备（除了你在赛局中捡到的），光是技巧和战略的强弱之分就能决定出谁才是能坚持到最后的赢家。本次活动将会开放单人和双人模式，玩家在加入海盗主题的预赛大厅区域前，可以从强袭风暴角色画面新增好友。游玩游戏将可以累计名望轨迹，《巨龙崛起》和《魔兽世界：巫妖王之怒 经典版》的玩家都可以获得奖励。
更新日志
2024年11月24日
2024年11月24日
- 凤飞飞《我们的主题曲》飞跃制作[正版原抓WAV+CUE]
- 刘嘉亮《亮情歌2》[WAV+CUE][1G]
- 红馆40·谭咏麟《歌者恋歌浓情30年演唱会》3CD[低速原抓WAV+CUE][1.8G]
- 刘纬武《睡眠宝宝竖琴童谣 吉卜力工作室 白噪音安抚》[320K/MP3][193.25MB]
- 【轻音乐】曼托凡尼乐团《精选辑》2CD.1998[FLAC+CUE整轨]
- 邝美云《心中有爱》1989年香港DMIJP版1MTO东芝首版[WAV+CUE]
- 群星《情叹-发烧女声DSD》天籁女声发烧碟[WAV+CUE]
- 刘纬武《睡眠宝宝竖琴童谣 吉卜力工作室 白噪音安抚》[FLAC/分轨][748.03MB]
- 理想混蛋《Origin Sessions》[320K/MP3][37.47MB]
- 公馆青少年《我其实一点都不酷》[320K/MP3][78.78MB]
- 群星《情叹-发烧男声DSD》最值得珍藏的完美男声[WAV+CUE]
- 群星《国韵飘香·贵妃醉酒HQCD黑胶王》2CD[WAV]
- 卫兰《DAUGHTER》【低速原抓WAV+CUE】
- 公馆青少年《我其实一点都不酷》[FLAC/分轨][398.22MB]
- ZWEI《迟暮的花 (Explicit)》[320K/MP3][57.16MB]