jsp中分页显示(含有模糊查询)

1、jsp+oracle分页（含模糊查询）CREATESEQUENCEperson.sequ;CREATETABLEperson(idintnotnul1primarykey?一一sequenceuseridvarchar2(32),namevarchar2(32),passwordvarchar2(20);INSERTINTOperson(id,userid,name,password)(person.sequ.nextVal,zymOU猛哥01，T);INSERTINTOperson(id,userid,name,password)(person.sequ.nextVal,zym02,z猛哥0

2、2，T);INSERTINTOperson(id,userid,name,password)(person.sequ.nextVal,zym03,猛哥03，T);INSERTINTOperson(id,userid,name,password)(person.sequ.nextVal,zym04,f猛哥04，T);INSERTINTOperson(id,userid,name,password)(person.sequ.nextVal,zym05,猛哥05，T);INSERTINTOperson(id,userid,name,password)(person.sequ.nextVal,zym0

3、6,f猛哥06，T);INSERTINTOperson(id,userid,name,password)(person.sequ.nextVal,fym07,猛哥07，T);VALUESVALUESVALUESVALUESVALUESVALUESVALUESINSERTINTOperson(id,userid,name,password)VALUES(person-sequ.nextVal,zym08,猛哥08，T);INSERTINTOperson(id,userid,name,password)VALUES(person-sequ.nextVal,zym09,f猛哥09，T);INSERT

4、INTOperson(id,userid,name,password)VALUES(person-sequ.nextVal,fyml0,猛哥10，T);INSERTINTOperson(id,userid,name,password)VALUES(person-sequ.nextVal,zymll,猛哥11，T);INSERTINTOperson(id,userid,name,password)VALUES(person-sequ.nextVal,zyml2,，/猛哥12，T);INSERTINTOperson(id,userid,name,password)VALUES(person-seq

5、u.nextVal,zyml3,猛哥13，T);INSERTINTOperson(id,userid,name,password)VALUES(person-sequ.nextVal,fyml4,，/猛哥14，T);INSERTINTOperson(id,userid,name,password)VALUES(person-sequ.nextVal,zyml5,猛哥15，T);INSERTINTOperson(id,userid,name,password)VALUES(person-sequ.nextVal,zyml6,猛哥16，T);INSERTINTOperson(id,userid,n

6、ame,password)VALUES(person-sequ.nextVal,zyml7,，/猛哥17，T);INSERTINTOperson(id,userid,name,password)VALUES(person-sequ.nextVal,fyml8,猛哥18，T);INSERTINTOperson(id,userid,name,password)(person-sequ.nextVal,zyml9,，/猛哥19，T);INSERTINTOperson(id,userid,name,password)(person-sequ.nextVal,zym20,，/猛哥20，T);INSERT

7、INTOperson(id,userid,name,password)(person-sequ.nextVal,zym21,，/猛哥21，T);INSERTINTOperson(id,userid,name,password)(person-sequ.nextVal,zym22,，/猛哥22，T);INSERTINTOperson(id,userid,name,password)(person-sequ.nextVal,zym23,，/猛哥23，T);list,jsp分页显示人员列表VALUESVALUESVALUESVALUESVALUES/进行乱码处理requestsetCharacter

8、Encoding(GB2312);%/接收查询关键字keyWord=newString(request.getParameter(kw)getBytes(8859-1)；/keyWord=request.getParameter(nkw);/接收传过来的当前页trycurrentPageInteger.parselnt(request.getParameter(cpn);catch(Exceptione)StringDBDRIVER=oracle,jdbc.driver.OracleDriver;StringDBURL=jdbc:oracle:thin:310:1521:

9、styleerp*;StringDBUSER=nSYSTEM;StringDBPASSWORD=HASDqwel23;Connectionconn=nu11;%tryClass.forName(DBDRIVER);conn=DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);PreparedStatementpstmt=null;Stringsql=nul1;if(keyWord=nul1)/如果为空则没有查询，表示查询出全部sql=SELECTCOUNT(id)fromperson;elsesql=SELECTCOUNT(id)fromp

10、ersonWHEREuseridLIKE?ORnameLIKE?;pstmt=conn.prepaTeStatement(sql);/如果有查询关键字，则进行设置if(keyWord!=nul1)pstmt.setString(1,%+keyWord+n%);pstmt.setString(2,%+keyWord+%);ResultSetrs=pstmt.executeQuery();if(rs.next()alIRecorders=rs.getInt(1);rs.close();pstmt.close();/计算总页数pageSize=(alIRecorders+lineSize-1)/Ii

11、neSize;if(keyWord=nul1)sql=nSELECTid,userid,name,passwordFROMperson;elsesql=SELECTid,userid,name,passwordFROMpersonWHEREuseridLIKE?ORnameLIKE?;pstmt=conn.prepaTeStatement(sql);if(keyWord!=nul1)pstmt.setString(1,%+keyWord+%);pstmt.setString(2,n%n+keyWord+n%n);rs=pstmt.executeQuery();%functionopenPage

12、(curpage)document,spage.cp.value=curpage;/alert(cupage);document,spage.submit();functionselOpenPage()document,spage.cp.valuedocument,spage.selpage.value;document,spage.submit();formname=spageaction=输入查询关键字：inputtype=Mtextname=nkwva1ue=M0)%inputtype=buttonvalue=首页onClick=MopenPage(1)inputtype=Mbutton

13、value=上一页onClick=MopenPage()inputtype=Mbuttonvalue=下一页onClick=MopenPage()inputtype=buttonvalue=尾页onClick=openPage()AA%cuondo、資莫关于二一hpQlos-QXHEbnEdluu.IJny爭-HonleAuo二do)(+XOZ一soMed=:x二Hx-UUJOJ%二(obneduQdoos二Hobnueqouo_oMedos=:2UEU-OCDOS嬴擦謎nuoJ7QZ-s*Ed2_-rsz-s二PQJ1.IOC。1UOJp%登陆名称姓名密码操作%inti=0;for(intx=0;x(current1)*1ineSize;x+)rs.next();/对于输出代