java - Java中的用尽结果集异常

Question

有人可以告诉我如何摆脱 Exhausted Resultset 异常。我曾尝试查看此网站上发布的其他问题，但似乎没有任何帮助。即使在使用 .next() 方法后，我也会收到错误消息。顺便说一句，sql 代码确实返回行，并且它不是一个空集。这是我的代码：

package jdbcManabu;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;

public class TwoTables
{

    public static void main(String[] args)
    {
        try
        {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            Connection tsunagu = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "hr", "hr");  
            Statement gyo = tsunagu.createStatement(); 
            String sql1 =
                    "SELECT e1.salary, e2.salary FROM employees e1 INNER JOIN employees e2 ON e1.employee_id = e2.employee_id WHERE e1.salary > 20000";

            ResultSet set1 = gyo.executeQuery(sql1);
            ResultSetMetaData  meta1 = set1.getMetaData(); 

            for(int i=1; i <= meta1.getColumnCount(); i++)
                System.out.print(meta1.getColumnName(i) + "=" + meta1.getColumnTypeName(i));

            int clmns = meta1.getColumnCount();
            while(set1.next());
            {
                for(int i = 1; i <= clmns; i++)
                {
                  System.out.print( set1.getInt(i) + " ");
                }
                System.out.println();
            }


            tsunagu.close();


        }
        catch (Exception e)
        {
            e.printStackTrace();
        }
    }

}

标签： javaoracle11g