Deleting row from Java ResultSet and not from underlying database

Is there a way in Java to delet开发者_如何转开发e a row just from a result set and not from underlying database? Thanks.

---

Take a look at the CachedRowSet. It allows you to create a disconnected ResultSet and operate without affecting the database.

---

It sounds like you're iterating through your ResultSet and filtering rows as you go?

I would say either move the filtering to the SQL statement if you can, otherwise copy the ResultSet into a List, either of objects of rowtype or just Map's if you'd rather not, then call list.remove(row) as you go.

You can't remove rows or update a ResultSet, you'd have to use a CachedRowSet like VAShhh suggests.

---

You can solve that problem by setting setAutoCommit() on your connection object to false, e.g conn.setAutoCommit(false).

Then perform all your deletes, after which you call rollback() on the connection object: conn.rollback(). This will reverse all the delete that you made and keep your database at the original state.