JDBC command to insert/delete/update multiple records?

suppose I have a table that has the following keys:

1
2
3

and then I get a new request (JSON list) to update that table with开发者_运维问答:

2
4

The user wants me to delete 1 and 3. Keep (possibly update) 2 and add 4. I can write a bunch of code t loop and perform this operation but is there some automated JDBC command that will perform the merge for me?

Thanks.

my suggestion is to delete all previous rows and insert new rows. you just need to write 2 queries. 1) delete all previous rows 2) Insert new rows

You could use an ORM library like sormula that would do all of the work for you with deleteAll and insertAll methods.

Include deletes and inserts within a transaction if more than one thread may perform this at the same time.

If you wanted the "union" of old and new, sormula has save and saveAll methods.