我在原来的程序中加了这段代码后就出现CPU利用率100%的情况!怎么解决<%
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:myconn";
Connection con=DriverManager.getConnection(url,"","");
String sql="select * from tc_article";
Statement Stmt=null;
Stmt=con.createStatement(); //注意
ResultSet rs=Stmt.executeQuery(sql);
int i=0;
while(i<=2)
{
if(rs.next())
{
String title=new String(rs.getString("title").getBytes("GB2312"));
session.putValue("bbstitle",title);
out.print(title);
out.print("<br>");
i++;
}
}
con.close();
}catch(Exception e)
{
out.println(e);
}
%>
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:myconn";
Connection con=DriverManager.getConnection(url,"","");
String sql="select * from tc_article";
Statement Stmt=null;
Stmt=con.createStatement(); //注意
ResultSet rs=Stmt.executeQuery(sql);
int i=0;
while(i<=2)
{
if(rs.next())
{
String title=new String(rs.getString("title").getBytes("GB2312"));
session.putValue("bbstitle",title);
out.print(title);
out.print("<br>");
i++;
}
}
con.close();
}catch(Exception e)
{
out.println(e);
}
%>
while(rs.next())
{
String title=new String(rs.getString("title").getBytes("GB2312"));
session.setAttribute("bbstitle",title);
out.print(title);
out.print("<br/>");
i++;
if(i>2)break;}