Originally posted by Kevin Chapple:
but I want to be able to change this data if required and saved back into the same bean.
This is also a viable approach (but not without its own set of issues), but you need a way to maintain the list across requests and not just recreate it each time a button is clicked,Originally posted by Kevin Chapple:
My thoughts were to extract all the records of of the database using a resultSet and working with the records in an array before saving the entire array of records back to the database.
Yes. In my approach, only a single record at a time is read from the DB. This is a much simpler approach that I would advise unless you have good reasons otherwise,In the approach you describe should I access the database everytime I want a particular record?
I am Arthur, King of the Britons. And this is a tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
|