使用javabean實現(xiàn)分頁技術(shù)

使用javabean實現(xiàn)分頁技術(shù)結(jié)構(gòu):執(zhí)行過程：Index調(diào)用javabean中的getrowcount方法獲?。罕硇袛?shù)Index調(diào)用javabean中的getpagecount方法獲取：頁面數(shù)量調(diào)用getcontent方法獲取表中數(shù)據(jù)并顯示操作：新建一個index.jsp頁面新建包javabean_pagckag在包中新建t_conn類用于連接數(shù)據(jù)庫packagejavabean_package;importjava.sql.*;publicclasst_conn{//連接對象

privateConnectioncon=null;//獲取連接的方法publicConnectiongetcon(){try{Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();con=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0?0?1:1433;DatabaseName=test",e=test","saITIT}catch(Exceptione){e.printStackTrace();}returncon;}}4.新建javabean(userbean)packagejavabean_package;publicclassuserbean{publicuserbean(){}privateintid;privateStringusername;privateStringuserpwd;privateStringuseremail;privateStringusergrade;publicintgetId(){returnid;}publicvoidsetId(intid){this.id=id;}publicStringgetUsername(){returnusername;}publicvoidsetUsername(Stringusername){this.username=username;}publicStringgetUserpwd(){returnuserpwd;}publicvoidsetUserpwd(Stringuserpwd){this.userpwd=userpwd;}publicStringgetUseremail(){returnuseremail;}publicvoidsetUseremail(Stringuseremail){this.useremail=useremail;}publicStringgetUsergrade(){returnusergrade;}publicvoidsetUsergrade(Stringusergrade){this.usergrade=usergrade;}}5.新建一個usercl類introwcount;Connectionconn=null;Statementstmt=null;ResultSetrs=null;intpagesize=10;//每頁顯示行數(shù)intpagecount=0;//頁面數(shù)量編寫關(guān)閉數(shù)據(jù)方法//關(guān)閉方法privatevoidclose(){try{if(rs!=null){rs.close();}if(stmt!=null){stmt.close();}if(conn!=null){conn.close();}}catch(Exceptione){e.printStackTrace();}}查詢表中記錄數(shù)方法publicintgetrowcount(){t_connt=newt_conn();conn=t.getcon();try{stmt=conn.createStatement();rs=stmt.executeQuery("selectcount(*)fromusertest");if(rs.next()){rowcount=rs.getInt(1);}}catch(Exceptione){e.printStackTrace();}finally{this.close();}returnrowcount;}計算分頁數(shù)方法publicintgetpagecount(){if(rowcount%pagesize==0){pagecount=rowcount/pagesize;}else{pagecount=rowcount/pagesize+1;}returnpagecount;封裝Arraylist方法//查詢數(shù)據(jù)庫封裝到arraylist中publicArrayListgetcontent(intpagenow){//根據(jù)傳入內(nèi)容查詢t_connt=newt_conn();conn=t.getcon();ArrayListal=newArrayList();//rowcount=this.getrowcount();try{stmt=conn.createStatement();Stringsql="selecttop"+pagesize+"*fromusertestwhereuseridnotin(selecttop"+pagesize*(pagenow-1)+"useridfromusertest)";rs=stmt.executeQuery(sql);while(rs.next()){ //將數(shù)據(jù)封裝到al中：通過javabeanuserbeanub=newuserbean();ub.setId(rs.getInt(1));ub.setUsername(rs.getString(2));ub.setUserpwd(rs.getString(3));ub.setUseremail(rs.getString(4));ub.setUsergrade(rs.getString(5));al.add(ub);//arraylist獲取javabean內(nèi)容添加一條記錄}}catch(Exceptione){e.printStackTrace();}returnal;}6.在index中調(diào)用<%introwcount=0;//表中記錄數(shù)intpagenow=1;//用戶點擊頁碼intpagecount=0;userclc=newusercl();rowcount=c.getrowcount();pagecount=c.getpagecount();//獲取pagenowStrings=request.getParameter("pagenow");//out.println(s);if(s!=null){pagenow=Integer.parseInt(s);}//out.println(pagecount);//out.println(rowcount);//調(diào)用arraylsit(usercl中的getconetnt方)獲取內(nèi)容并顯示ArrayListal=c.getcontent(pagenow);%>循環(huán)顯示<%out.println(al.size());for(inti=0;i<al.size();i++){userbeanub=(userbean)al.get(i);%><tr><td><%=ub.getId()%></t