原代码段:
PreparedStatement prep = null;
String sql = "select * from t_users where userID = ? and password = ? ";
prep = conn.prepareStatement(sql);
如果用结果集保存执行得到的结果,然后用结果集的方法first()、beforeFirst()等都会报错:对只转发的结果集的无效操作
Caused by: java.sql.SQLException: 对只转发结果集的无效操作: first
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.BaseResultSet.first(BaseResultSet.java:74)
at com.lingnan.usersys.usermgr.business.dao.UserDAOImpl.login(UserDAOImpl.java:45)
... 25 more
解决方法 :
PreparedStatement prep = null;
String sql = "select * from t_users where userID = ? and password = ? ";
prep = conn.prepareStatement(sql, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
在初始化PreparedStatemen对象时,加上参数ResultSet.TYPE_SCROLL_INSENSITIVE和ResultSet.CONCUR_UPDATABLE;
ResultSet.TYPE_SCROLL_INSENSITIVE 表示结果集的游标可以上下移动,当数据库变化时,当前结果集不变
ResultSet.CONCUR_UPDATABLE 表示能用结果集更新数据库中的表