I am using jquery/jsp/java ejb3.0/sql server.
The User interface requirement (a jsp page) is a grid of checkboxes, ~10 rows high and up to about ~30 rows wide (this varies), it represents a linker table for a many-to-many table relationship.
The checkboxes will be populated from the database (if row present in linker table, checkbox checked).
user can then check/uncheck whichever, as many times as possible. On submit any changes should be saved to db. The changes will consist of deleting a row if unchecked(and if checked/row present before), and inserting a row if checked (and unchecked/no row present before).
My problem is, what is the best way to implement this ? Using ajax to update database using checkbox onchange event is not appropriate. Has to be a submit form event.
Hopefully this is clear, and I realize I have many possible options. Any input is gratefully and humbly received.