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/進(jìn)行亂碼處理requestsetCharacter

8、Encoding(GB2312);%/接收查詢關(guān)鍵字keyWord=newString(request.getParameter(kw)getBytes(8859-1)；/keyWord=request.getParameter(nkw);/接收傳過來的當(dāng)前頁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);/如果有查詢關(guān)鍵字，則進(jìn)行設(shè)置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();/計算總頁數(shù)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=輸入查詢關(guān)鍵字：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、資莫關(guān)于二一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();/對于輸出代