java.sql.SQLException : Exhausted Resultset error 异常

Question

我在以下代码中遇到此异常 java.sql.SQLException: Exhausted Resultset 的问题。我确信我的查询只返回一个值。即使我不使用 rs.next();，它也会抛出错误 java.sql.SQLException: ResultSet.next was not called。你能帮忙吗？

仅供引用，我在 main 中使用另一个结果集，其中调用了另一个类的这个方法。会影响吗？

谢谢

public static String getdispname(Connection conn, String resname) 
throws SQLException, Exception {

            //String resname = "";
            String returnValue = "";
            String querystring = "";

            //Query to select the displayname from resid

            querystring += "select distinct display_name";
            querystring += " from cust_rally_team_member";
            querystring += " where display_name like '%"+ resid +"%'";

            // Create select statement
            Statement stmt = conn.createStatement();

            try {
                // Execute statement
                ResultSet rs = stmt.executeQuery(querystring);
                if (rs!= null) { 
            while (rs.next()) {
            returnValue = rs.getString("display_name");
            } catch (SQLException ex) {
                throw new SQLException(ex);
            } catch (Exception ex) {
                throw new Exception(ex);
            }
            // Close statement
            finally {
                stmt.close();
            }

            return returnValue;

Answer 1

尝试作为

if (rs! = null) { 
 while (rs.next()) {
  returnValue = rs.getString("display_name");
}
......