Dear All:
    The following is my problem, I want to change rs's Column1 of last
record,
but when I update the Column1 to "123" and refreshRow, I try to get the
value
again, it doesn't get the real value "123", please tell me how to get the
real
"123", my DB is SQL 2000.

ps. if I using updateRow it will update in DB, but I don't want to update
DB.

Source Code

============================================================================
=
         Connection conn = xxxx;
         Statement stmt =
conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
                                               ResultSet.CONCUR_UPDATABLE);
         ResultSet rs = null;
         rs = stmt.executeQuery(
             "Select * from Table_Name");
         rs.last();
         // get the Column1 value of last record
         String first = rs.getString("Column1");
         System.out.println(first);
         // update to 123
         rs.updateString("Column1","123");
         rs.refreshRow();
         // reget the Column1 value of last record after update
         String second = rs.getString("Column1");
         System.out.println(second);
         rs.close();
         conn.close();

Regards. Ahan