如果数据库里有几百万条数据,请问将如何修改下面分页代码,多谢了
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=stmt.executeQuery("select a1,a2,a3 from aa where a1='"+a1+"');int intPageSize;
int intRowCount;
int intPageCount;
int intPage;
String strPage;
int i;
intPageSize = 20;
strPage = request.getParameter("page");
if(strPage==null){
intPage = 1;
}else{
intPage = Integer.parseInt(strPage);
if(intPage<1){ intPage = 1;}
}
rs.last();
intRowCount = rs.getRow();
intPageCount =(intRowCount+intPageSize-1) / intPageSize;
if(intPage>intPageCount) intPage = intPageCount;
if(intPageCount<=0){
%>
没有数据!
<%
}else{
rs.absolute((intPage-1) * intPageSize+1);
i = 0;
while(i< intPageSize && !rs.isAfterLast()){
%>
<%=rs.getString(a1")%>
<%=rs.getString(a2")%>
<%=rs.getString(a3")%>
<%
rs.next();
i++;
}
}
%>
<%if(intPage>1){%>
<a href="aa.jsp?page=<%=intPage-1%>" >上一页</a>
<%}else{%>
上一页
<%}%>
<%if(intPage<intPageCount){%>
<a href="aa.jsp?page=<%=intPage+1%>" >下一页</a>
<%}else{%>
下一页
<%}%>
<%=intPage%>/<%=intPageCount%> 页
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=stmt.executeQuery("select a1,a2,a3 from aa where a1='"+a1+"');int intPageSize;
int intRowCount;
int intPageCount;
int intPage;
String strPage;
int i;
intPageSize = 20;
strPage = request.getParameter("page");
if(strPage==null){
intPage = 1;
}else{
intPage = Integer.parseInt(strPage);
if(intPage<1){ intPage = 1;}
}
rs.last();
intRowCount = rs.getRow();
intPageCount =(intRowCount+intPageSize-1) / intPageSize;
if(intPage>intPageCount) intPage = intPageCount;
if(intPageCount<=0){
%>
没有数据!
<%
}else{
rs.absolute((intPage-1) * intPageSize+1);
i = 0;
while(i< intPageSize && !rs.isAfterLast()){
%>
<%=rs.getString(a1")%>
<%=rs.getString(a2")%>
<%=rs.getString(a3")%>
<%
rs.next();
i++;
}
}
%>
<%if(intPage>1){%>
<a href="aa.jsp?page=<%=intPage-1%>" >上一页</a>
<%}else{%>
上一页
<%}%>
<%if(intPage<intPageCount){%>
<a href="aa.jsp?page=<%=intPage+1%>" >下一页</a>
<%}else{%>
下一页
<%}%>
<%=intPage%>/<%=intPageCount%> 页
几百万下用过的