com.microsoft.sqlserver.jdbc.SQLServerException:结果集没有当前行

2015-07-24 08:14:33 · 作者: · 浏览: 4
java获取结果集,if(rs!=null),和while(rs.next())区别


com.microsoft.sqlserver.jdbc.SQLServerException: 结果集没有当前行。
st = conn.createStatement();
ResultSet rs = st.executeQuery(sql);
if(rs!=null) {//rs.next(); 报错
System.out.println(rs.getRow());
System.out.println(rs.getString("name"));

}
st = conn.createStatement();
ResultSet rs = st.executeQuery(sql);
while(rs.next()) {//rs.next(); OK
System.out.println(rs.getRow());
System.out.println(rs.getString("name"));


}

?