Question

jdbc连接oracle,只有一条结果集，rs.next()值为false!

Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
Class.forName("oracle.jdbc.driver.OracleDriver");
jdbcUrlThird = method.getString("jdbc.properties", "dbThird.url");
usernameThird = method.getString("jdbc.properties","dbThird.username");
passwordThird = method.getString("jdbc.properties","dbThird.password");
conn = DriverManager.getConnection(jdbcUrlThird,usernameThird, passwordThird);

String sql = "select * from test";
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
while(rs.next()){
}
rs.next()一直读取的是第二条数据，当结果集只有一条数据的时候，就会报错！
需要大家帮忙解决，不管rs有一条还是多条结果集都能循环取数据！

Answer 1

用debug调试一下，会不会加断点，看rs为不为空啊

Answer 2

while(rs.hasNext()){
Object object = rs.next();
}

直接上代码，简单错误就不细说了

Answer 3

你代码没贴全吧
是不是有 rs.next用了两次啊。