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

时间：2021-09-14 来源：互联网编辑：宝哥软件园浏览：次

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

1.分页的演示文件结构图

导入的包

2.代码

SplitPageServlet代码

包操作Servlet导入Java。io。ioexception导入Java。SQL。SqLexception导入Java。乌提尔。ArrayList导入Java。乌提尔。列表；导入javax。servlet。servletexception导入javax。servlet。注释。webservlet导入javax。servlet。http。HttpServlet导入javax。servlet。http。HttpServletrequest导入javax。servlet。http。HttpServletResponse导入比恩.ProjectBean进口服务SplitPage/** * Servlet实现类SplitPageServlet */@ WebServlet(“/SplitPageServlet”)公共类SplitPageServlet扩展了HttpServlet {私有静态最终长串行版本id=1L；/* * * @参见httpersvlet # httpersvlet()*/public splitPageServlet(){ super()；//TODO自动生成的构造函数存根}/* * * @请参见httpersvlet # Doget(httpersvletrequest请求，HttpServletResponse响应)*/受保护的void Doget(HttpServletrequest请求，HttpServletResponse响应)引发ServletException，IOException { //TODO自动生成的方法存根list project beanstar=new Arraylistproject bean()；string currentpage string=请求。getparameter(' current page ')；string numberForSplitPage=请求。getparameter(' numberForSplitPage ')；if(CurrentPageString==null){ CurrentPageString=' 1 '；} if(numberForSplitPage==null){ numberForSplitPage=' 5 '；} SplitPage SplitPage=new SplitPage()；请尝试{ listArr=splitPage .所有splitpage(numberForSplitPage，currentpage字符串)；请求。setattribute(' subResult '，listArr)；} catch(class notfoundexception | SQLException e){//TODO自动生成的捕捉块e . print stack trace()；}系统。出去。println(splitpage。页码)；系统。出去。println(splitpage。CurrentPageIndex)；请求。setattribute('页码'，splitpage。页码)；请求。setattribute(' currentPageIndex '，splitpage。currentPageIndex)；请求。get request dispatcher('/servlet/showviewnindex ').转发（请求、响应);}/* * * @参见httpersvlet # DoPost(httpersvletrequest请求，httpersvletresponse响应)*/受保护的void doPost(httpersvletrequest请求，httpersvletresponse响应)抛出ServletException，IOException { //TODO自动生成的方法存根doGet(请求，响应);}}ProjectBean代码

包豆；公共类项目Bean {私有字符串项目=null私有字符串项目名称=null私有字符串项目类型=null私有字符串用户号=空；私有字符串项目用户=空；public String getproject id(){ if(项目id==null){项目id=}返回this . PROJECt id } public void set PROJECt id(字符串项目id){ this。项目id=项目id；} public void setProjectName(字符串项目名){ this。项目名称=项目名称；}公共字符串getproject name(){ 0返回this . project name } public void setType(String项目类型){ this。项目类型=项目类型；}公共字符串GetProjectType(){ 0返回this . project type } public void setUserNo(String userNo){ this。用户号=用户号；}公共字符串getUserNo(){ 0返回this.userNo}公共void set project user(String project user){ this。项目用户=项目用户；} public String getproject user(){返回此。项目用户；} }SplitPageBean代码

包豆；公共类SplitPageBean { private int allitems；//总的记录数私人国际货币记录；//当前的记录数private int lastPageRecord//上一页记录数开始数private int nextPageRecord//下一页记录数开始数private int lastPageIndex//上一页private int nextPageIndex//下一页private int currentPageIndex//当前页private int numberForSplitPage//每页分的数量private int all page number public int GetalItems(){返回此。allitems} public void setAllitems(int allitems){ this。allitems=allitems} public int getCurrentRecord(){返回此。电流记录；} public void set current record(int current page index){ this。当前记录=当前页面索引*此。numberforsplitpage} public int getlastPageRecord(){返回此。lastpagerecord} public void setLastPageRecord(int lastPageIndex){ this。lastpagerecord=lastPageIndex * this。numberforsplitpage} public int getnext page record(){返回此。下一页记录；} public void setnext page记录(int next page index){ this。下页记录=下页索引*这个。numberforsplitpage} public int getLastPageIndex(){返回此。lastpageindex} public void setLastPageIndex(int CurrentPageindex){ this。lastpageindex=CurrentPageindex-1；} public int getNextPageIndex(){返回此。nextpageindex} public void setNextPageIndex(int currentPageIndex){ this。next page index=CurrentPageindex-1；} public int getCurrentPageIndex(){返回此。currentpageindex} public void setCurrentPageIndex(int currentPageIndex){ this。currentPageIndex=currentPageIndex；} public int getNumberForSplitPage(){返回此。numberforsplitpage} public void setNumberForSplitPage(int numberForSplitPage){ this。numberForSplitPage=numberForSplitPage；} public int getallpage number(){返回此。所有页码；} public void setall页码(int allitems){ this。所有页码=allitems/this。numberforsplitpage 1；} }QueryProject代码

包刀；导入Java。SQL。连接；导入Java。SQL。resultset导入Java。SQL。SqLexception导入java.sql。语句；导入Java。乌提尔。ArrayList导入Java。乌提尔。列表；导入比恩.ProjectBean进口服务连接数据库.公共类查询项目{ private ListProjectBean listArr=new ArrayList()；公共列表项目Bean查询项目()抛出ClassNotFoundException，SQLException { Connection conn=null；语句stat=NullResultSet RS=null connect数据库连接数据库=new connect数据库()；conn=connectdatabase。connect()；stat=conn . create statement()；rs=stat.executeQuery('从项目中选择* ');而(RS。next()){ PROJECt BEAN PROJECt BEAN=new PROJECt BEAN()；project BEAN。设置项目标识。getStrIng(' PROJECt id ')；工程豆。设置项目名称。GetString(' project name ')；project BEAN。设置类型。getStrIng(' PROJECt TYPe ')；工程豆。setuserno(RS。GetString(' UserNo ')；工程豆。设置项目用户。GetString(' project user ')；利斯特拉尔。添加(ProjectBean)；} connectDataBase.close(stat，conn)；返回listArr }//公共静态void main(String[]args)引发ClassNotFoundException，SQLException {//ListProjectBean listArr=new ArrayList()；//查询项目查询项目=新建查询项目()；//listArr=queryProject .查询AlpProject()；//PROJECt bean PROJECt bean=new PROJECt bean()；//ProjectBean=ListArr。get(0)；//系统。出去。println(项目bean。getproject id())；//ProjectBean=ListArr。get(2)；//系统。出去。println(项目bean。getproject id())；//系统。出去。println(listarr。size())；//} } ConEntDatabaSe代码

一揽子服务；导入Java。SQL。连接；导入Java。SQL。Drivermanager导入Java。SQL。SqLexception导入java.sql。语句；公共类连接数据库{私有字符串URL=' JDBC : MySQL ://本地主机：3306/zhon创web '；私有字符串用户=' root私有字符串密码=' 12345 ';公共连接连接()抛出ClassNotFoundException，SQLException { class。FOrname(' com。MySQL。JDBC。驱动程序')；connection conn=Drivermanager。获取连接(网址、用户、密码);返回conn} //关闭数据库资源公共空隙关闭(语句统计，连接conn)抛出SQLException{ if(stat！=null){ stat。close()；} if(conn！=null){ conn . close()；} }}SplitPage代码

一揽子服务；导入Java。SQL。SqLexception导入Java。乌提尔。ArrayList导入Java。乌提尔。列表；导入比恩.ProjectBean导入比恩.SplitPageBean进口刀QueryProjectpublic类SplitPage { public static int页码；公共静态int currentpageindex private ListProjectBean splitArr=new ArrayList()；{查询项目查询项目=新建查询项目()；请尝试{ splitArr=queryProject .查询AlpProject()；} catch(class notfoundexception | SQLException e){//TODO自动生成的捕捉块e . print stack trace()；} } public ListProjectBean all split page(split page的字符串编号，String requestPageIndex)引发ClassNotFoundException，SQLException { ListProjectBean结果=new ArrayListProjectBean()；int numberForSplitPageInt=整数。parsent(numberForSplitPage)；//每页的数量int requestPageIndexInt=整数。解析器(RequestPageIndex)；//请求的页码SplitPageBean SplitPageBean=new SplitPageBean()；splitpagebean。setallitems(splitarr。size())；//设置总的记录数splitpagebean。setnumberforsplitepage(numberforsplitepageint)；//设置每页的记录数量splitpagebean。setallpagenumber(splitarr。size())；页码=splitpagebean。GetAllPageNumber()；splitpagebean。setcurrentpageindex(RequestPageindexint)；//设置请求页页码currentPageIndex=splitpagebean。getcurrentpageindex()；splitpagebean。setlastpagerecord(RequestPageIndexint-1)；if(splitpagebean。getallitems()。splitpagebean。getnumberforsplitpage()){ result=splitArr；} else if(splitpagebean。getcurrentpageindex()* splitpagebean。getnumberforsplitepage()splitpagebean。getallitems()){ result=splitarr。子列表(splitpagebean。getlastpagerecord()、splitpagebean。getallitems())；} else { result=split arr。子列表(splitpagebean。getlastpagerecord()、splitpagebean。getlastpagerecord()、splitpagebean。getnumberforsplitpage())；//子列表用法不包含末尾索引}返回结果；}//公共静态void main(String[]args)引发ClassNotFoundException，SQLException {//ListProjectBean测试结果=new ArrayListProjectBean()；//PROJECt bean PROJECt bean=new PROJECt bean()；//SplitPage SplitPage=new SplitPage()；//TestResult=splitPage .AllSplitPage('5 '，' 1 ')；//ProjectBean=TestResult。get(0)；//系统。出去。println(项目bean。getproject id())；//ProjectBean=TestResult。get(1)；//系统。出去。println(项目bean。getproject id())；//ProjectBean=TestResult。get(2)；//系统。出去。println(项目bean。getproject id())；//ProjectBean=TestResult。get(3)；//系统。出去。println(项目bean。getproject id())；//ProjectBean=TestResult。get(4)；//系统。出去。println(项目bean。getproject id())；//ProjectBean=TestResult。get(5)；//系统。出去。println(项目bean。getproject id())；////}}显示层显示视图索引代码

包视图；导入Java。io。ioexception导入javax。servlet。servletexception导入javax。servlet。注释。webservlet导入javax。servlet。http。HttpServlet导入javax。servlet。http。HttpServletrequest导入javax。servlet。http。HttpServletResponse/** * Servlet实现类showviewnindex */@ WebServlet("/showviewnindex ")公共类showviewnindex扩展了HttpServlet {私有静态最终长串行版本id=1L；/* * * @参见httpersvlet # httpersvlet()*/public showviewnindex(){ super()；//TODO自动生成的构造函数存根}/* * * @请参见httpersvlet # Doget(httpersvletrequest请求，HttpServletResponse响应)*/受保护的void Doget(HttpServletrequest请求，HttpServletResponse响应)抛出ServletException，IOException { //TODO自动生成的方法存根请求。getrequest dispatcher('/new file。JSP ').转发（请求、响应);}/* * * @参见httpersvlet # DoPost(httpersvletrequest请求，httpersvletresponse响应)*/受保护的void doPost(httpersvletrequest请求，httpersvletresponse响应)抛出ServletException，IOException { //TODO自动生成的方法存根doGet(请求，响应);}}jsp页面代码

% @ page语言=' Java ' ContentType=' text/html；charset=utf-8 '页面编码=' utf-8 ' % @ taglib前缀=' c ' uri=' http://Java。星期日com/JSP/JSTL/core“%！DOCTYPE HTML PUBLIC '-//W3C//DTD HTML 4.01 Transitional//EN ' ' http://www .w3。org/TR/HTML 4/松散。DTD ' HTML hearteta http-equiv=' Content-Type ' Content=' text/HTML；字符集=国际标准化组织8859-1 '标题数据库内容分页显示/title style type=' text/CSS ' * { margin :0；划水：0;} ul Li { width :50 px h8 :24 px线高：24 pxfloat:left边距-左侧：0像素；display : inlinemargin-top :5 px；飞越：隐藏；}ul li按钮{ width :50 pxheat :24 pxmargin :0 pxpadding :0 px }/style/head dy表和tr th style=' text-align : center；'编号/th style=' text-align : center；'名称/th style=' text-align : center；'类型/th style=' text-align : center；'学号/th style=' text-align : center；'负责人/th/tr/ad t body c : for each var=' project ' items=' $ { subResult } ' tr TDC : out值='${project。项目id } '/c : out/TD TDC : out值=' $ { project。项目名称} '/c : out/TD TDC : out值=' $ { project。项目类型} '/c :输出/TD TDC :输出值=' $ { project current page=$ { CurrentPageIndex-1 } '按钮/按钮/a/Li/c :当c :否则为Li按钮/按钮/a/Li/c :否则为/c :选择% int I=(整数)请求。getattribute('页码')；for(int j=0；冀；j){ % lia href=' $ { page context。请求。上下文路径}/servlet/SplitPageServlet？current page=%=j 1% ' button %=j 1%/button/a/Li % } % c :选择c :当test=' $ { currentpage index 1=页码} ' lia href=' $ { page context。请求。上下文路径}/servlet/SplitPageServlet？当前页面=$ {当前页面索引1 } '按钮/按钮/a/Li/c :当c :其他lia按钮/按钮/a/Li/c :其他/c :选择/ul/div/body/html XML代码

？可扩展标记语言版本='1.0 '编码='UTF-8 '？web-app xmlns : xsi=' http://www。w3。org/2001/XMLSchema-实例' xmlns=' http://Java。星期日com/XML/ns/javaee ' xsi :架构位置=' http://Java。星期日http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd'版本=' 2.5 '显示名称/显示名称-欢迎文件-列表欢迎文件/欢迎文件-文件运行结果展示