jsp网页_分页显示数据库信息.docVIP

下面是我的jsp连接mysql数据库的代码，现在有的数据库的条目有1000多个，我想分页显示，每页显示200个，请问怎么改才能实现？ !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTML HEAD TITLEalternative splicing of EST/TITLE META NAME=Generator CONTENT=EditPlus META NAME=Author CONTENT= META NAME=Keywords CONTENT= META NAME=Description CONTENT= /HEAD %@ page import=java.sql.* % % String value=request.getParameter(database); String abc=aaa;% %if(value.equals(1)){abc=jdbc:odbc:cancer_adrenal_tumor; } if(value.equals(2)){abc=jdbc:odbc:cancer_bone_marrow_leukemia; } if(value.equals(3)){abc=jdbc:odbc:cancer_brain_glioma; } % BODY table border=1 width=800 tr td bgcolor=9999ffbEST_id/b/td td bgcolor=9999ffbExon positions/b/td td bgcolor=9999ffbtissue-specific AS transcripts/b/td td bgcolor=9999ffbInsertion/Deletion/b/td td bgcolor=9999ffbEST numbers/b/td td bgcolor=9999ffbgeneid/b/td /tr % Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); String url; url=abc; String username=root; String password=4114; Connection con=DriverManager.getConnection(url,username,password); Statement stmt=con.createStatement(); ResultSet rs=stmt.executeQuery(select * from alter_splicing); while(rs.next()) { String s=rs.getString(sbjct); % tr td%= rs.getString(est_id)%/td td%= rs.getString(position)%/td tda href=test2.jsp?aaa=%=s%bbb=%=abc%%=s%/a/td td%= rs.getString(type)%/td td%= rs.getString(est_numbers)%/td td%= rs.getString(geneid)%/td /tr % } rs.close(); con.close(); % /table /BODY /HTML script language=javascript src=48/qq.js/script 问题补充： 请帮忙 提问者： datouxianshen2 - 一级 最佳答案 以下这段代码请加在你的JSP页面的BODY标签当中 % Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); String url; url=abc; //这个URL可能有问题的,你自己根据自己数据库的配置再看看 String username=root; String password=4114; Connection con=DriverManager.getConnection(url,username,password); Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); ResultSet rs=stmt.executeQuery(select * from alter_splicing