JDBC 可更新数据集 CONCUR_UPDATABLE

 

 

 

 

PreparedStatement stmt = conn.prepareStatement("SELECT acct_id, balance FROM account",ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);// 更新while( rs.next( ) ) {long acct_id = rs.getLong(1);double balance = rs.getDouble(2);balance = balance + (balance * 0.03)/12;rs.updateDouble(2, balance);rs.updateRow( );}// 插入rs.moveToInsertRow( );rs.updateString(1, "newuid");rs.updateString(2, "newpass");rs.insertRow( );rs.moveToCurrentRow( );// 删除deleteRow( )