分页显示数据库表中的记录.doc

利用以下技术来实现对Oracle数据库中的表Emp中的全部记录实行分页显示。技术点:(JSP+Servlet+JavaBean+c3p0+Oracle).:.;;;lassEmpimplementsSerializable{privatestaticfinallongserialVersionUID=1L;privateIntegerempno;//员工编号privateStringename;//员工姓名privateStringjob;//工种privateIntegermgr;//上级经理编号privateDatehiredate;//入职日期privateDoublesal;//m;//津贴privateIntegerdeptno;//部门编号publicEmp(){//noop}publicIntegergetEmpno(){}publicvoidsetEmpno(Integerempno){}publicStringgetEname(){}publicvoidsetEname(Stringename){}publicStringgetJob(){}publicvoidsetJob(Stringjob){}publicIntegergetMgr(){}publicvoidsetMgr(Integermgr){returnmgr;=job;returnjob;=ename;returnename;=empno;returnempno;}=mgr;publicDategetHiredate(){}publicvoidsetHiredate(Datehiredate){}publicDoublegetSal(){}publicvoidsetSal(Doublesal){}m(){}m(m){}publicIntegergetDeptno(){}returndeptno;m;m;=sal;returnsal;=hiredate;returnhiredate;}publicvoidsetDeptno(Integerdeptno){}=deptno;2、.;;/*******@authorAdministrator**/***@SuppressWarnings("unchecked")lassPager{privatestaticfinalintsize=5;//设置每页显示几行privateinttotalpage;//设置总页数--即(表的记录数/行数)+1或者(表的记录数/size)privateListlist;//设置把分页后的数据放到此List集合/*******@return返回每页显示几行*/publicstaticintgetSize(){returnsize;}/*******@return返回的总页数*/publicintgetTotalpage(){returntotalpage;}/***设置总页数--