ca_roland
asked on
JSP delima --- can not use JavaBean/Servlet
Hi, experts
I am in a delima here. I have to developed something solely JSP without any java classes (Servelt/JavaBean) because the stupid development evnironment I am in right now. No access to server, any class/jar deploy /test will take years....
Anyway, my task is I have to bring back from oracle DB up to 100 rows of data and force user give a setting for the last field of each row and click a submit to do a batch update to the table.
Each row can be identified by a composit key of several fields.
How can I do this. the best way I can figure out is through (preparedStatement and do a addbatch ) in a loop on the action page, then do a executeUpdate().
If I am right on the above. How can I pass the data to the action page? I am thinking I can somehow prepare a serializable Collection object with the resultset data on the first web page and pass it to the action page....
Please let me know your precious idea. just forget about my stupid thought as the above...
Thanks....................
I am in a delima here. I have to developed something solely JSP without any java classes (Servelt/JavaBean) because the stupid development evnironment I am in right now. No access to server, any class/jar deploy /test will take years....
Anyway, my task is I have to bring back from oracle DB up to 100 rows of data and force user give a setting for the last field of each row and click a submit to do a batch update to the table.
Each row can be identified by a composit key of several fields.
How can I do this. the best way I can figure out is through (preparedStatement and do a addbatch ) in a loop on the action page, then do a executeUpdate().
If I am right on the above. How can I pass the data to the action page? I am thinking I can somehow prepare a serializable Collection object with the resultset data on the first web page and pass it to the action page....
Please let me know your precious idea. just forget about my stupid thought as the above...
Thanks....................
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
>>if I am right on the above. How can I pass the data to the action page? I am thinking I can somehow prepare a >>serializable Collection object with the resultset data on the first web page and pass it to the action page....
if I am right on the above. How can I pass the data to the action page? I am thinking I can somehow prepare a serializable Collection object "POPULATED BY" the resultset data on the first web page and pass it to the action page....