# 怎么使查询数据的数据更快些(2)

www.MyException.Cn  网友分享于：2013-01-29  浏览：9次

<td   width= "62 "   bgcolor= "#F2F4F6 "> <div   align= "center "> 口令 </div> </td>
<td   width= "73 "   bgcolor= "#F2F4F6 "> <div   align= "center "> 性别 </div> </td>
<td   width= "61 "   bgcolor= "#F2F4F6 "> <div   align= "center "> 岗位 </div> </td>
<td   width= "46 "   bgcolor= "#F2F4F6 "   > <div   align= "center "> 生日 </div> </td>
<td   width= "77 "   bgcolor= "#F2F4F6 "   > <div   align= "center "> 学历 </div> </td>
<td   width= "168 "   bgcolor= "#F2F4F6 "   > <div   align= "center "> 描述 </div> </td>
</tr>

<%
int   gopage   =   0;

String   temp=request.getParameter( "gogo ");
if(temp==null||temp.trim().equals( " ")){
gopage=1;
}else{
gopage=Integer.parseInt(temp);
if(gopage   <   1)   {
gopage   =   1;
}
if   (gopage   >   pageCount)   {
gopage   =   pageCount;
}
}

for(int   k=0;k <(gopage-1)*size;k++)
rs.next();

int   i=0;
while(rs.next()){
i++;
if(i> size)break;
%>
<tr     align= "center "   bgcolor= "f5f5f5 "   onMouseOver= "this.style.background= '#EAEAEA ' "   onMouseOut= "this.style.background= '#f5f5f5 ' ">
<td     height= "24 "> <div   align= "center "> <%=rs.getString( "C_Usr_Id ")%> </div> </td>
<td   > <div   align= "center "> <%=rs.getString( "C_Usr_Name ")%> </div> </td>
<td   > <div   align= "center "> <%=rs.getString( "C_Usr_Passwd ")%> </div> </td>
<td   > <div   align= "center "> <%=rs.getString( "C_Sex ")%> </div> </td>
<td   > <div   align= "center "> <%=rs.getString( "C_Degree_Id ")%> </div> </td>
<td   > <div   align= "center "> <%=rs.getDate( "D_Birthday ")%> </div> </td>
<td   > <div   align= "center "> <%=rs.getString( "C_Education ")%> </div> </td>