In my application, I want to display all the rows from a table in a JSP.
The data that is to be shown should be populated in text boxes.
A user when successfully logs into the application will be able to view the Database table contents in the JSP Page, he can also modify the values from the Text boxes.
On clicking submit, the user should be able to post the whole of the Form will all the values altogether and the new values should be updated in the database.
Can you suggest a suitable approach for the same?
illustration :-
lets say we have an Employee table
table contents:-
EmpId Name Address Phone
--------------------------------------------------------------
231312 xyz213123 dasdas 0909090
324234 abc213123 asdas 0990898
now we need to display all the data (note the no. of rows are not constant) in the JSP inside the text boxes.
The user will be able to modify the data that is being displayed and on clicking submit the new data will be updated in the database.
I have build the application using Struts 1.2.7 and Hibernate 3.0.