用尽的Resultset

今天用JDBC联ORACLE遇到了一个常见的问题，用尽的resultset，发现了一个有意思的现像，把只要判断rset!=null && rset.next()

然后再定义  String mc=rset.getString("gzmc");并且定义要写在while循环里面，这样就不会报了

代码如下

 Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ORCL", "gzgl", "gzgl");
                Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
                ResultSet rset = stmt.executeQuery("select gzmc from g4 where gzmc is not null");
                int rowCount = 1;
                while(rset!=null && rset.next()) {
                 String mc=rset.getString("gzmc");
                 System.out.println("-->>>"+rset.getString("gzmc"));
                   rowCount++;
                }