爱在月光下通过本文主要向大家介绍了jsp servlet javabean,javabean和servlet,servlet调用javabean,jsp中javabean,jsp调用javabean等相关知识,希望对您有所帮助,也希望大家支持linkedu.com www.linkedu.com
首先后台分页需要理清分页思路，把数据库里面需要分页的信息放到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);
}
}
</div>
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;
}
}
</div>
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;
}
}
</div>
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()