Updating a mysql table using a servlet table
Ive got a table on a servlet which has received data values from a select statement which joins 3 mysql tables.
I want to edit the data on this table and transport the data to just one of these mysql tables.
I dont really know how to do this.
Ive used non_increment count values to try and transport data from a servlet html table to a mysql table but it was just one table and so was fairly basic.
But now Ive got values in this html table which are a join of 3 tables and I need to get the data into one of these tables and there is no direct mapping between rows of the html table and the mysql table where the data is gonna be updated and stored.
I know I need to use an update statement to update the mysql table data but how am I gonna find where to update in the mysql table when the html table is edited(and submit button is pressed)?
Also is it possible to display more than one jdbc mysql resultset on a servlet page and how?
