今天用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++;
}