conn.executeQuery为自己写的处理数据库的类,如下:
public ResultSet executeQuery(String strSql){
try
{
PreparedStatement preStmt = conn.prepareStatement(strSql);
rs = preStmt.executeQuery(strSql);
rs.next();
System.out.println("query");
}
catch(SQLException ex)
{
System.err.println("DBMag.executeQuery:" + ex.getMessage());
}
return rs;
}
public ResultSet executeQuery(String strSql){
try
{
PreparedStatement preStmt = conn.prepareStatement(strSql);
rs = preStmt.executeQuery(strSql);
rs.next();
System.out.println("query");
}
catch(SQLException ex)
{
System.err.println("DBMag.executeQuery:" + ex.getMessage());
}
return rs;
}
把它拿到rs循环的外面。
还有一种办法是你再编写一个executeQueryOther,里面不要用rs