Hello, I'm new to JSP and I'm trying to figure out how do I extract data from a table and display it in a form, so for example it can be edited by a user and then resubmitted with changes. Any help will be appreciated. Thanks
Thanks for being so prompt. Can we get some info on the application server and database you intend to use? Have you set things up already? Do you have sample JSPs running yet? Also, do you have any stand-alone JDBC apps running yet? It's easier to so some JDBC stuff and some JSP stuff separately then merge the two rather than learn them both at once. Dave.
Joined: Mar 06, 2001
I'm using Tomcat and for now I have a Microsoft Access file with an employee table that I'm using. I know how to run stand-alone JSPs, know already about how to set up a connection, and etc. I know how to get data from a database and display it in a table (I've tried it and it works), but I don't know how to put it in a form, so it can be edited further and updated. thanks
Since you already know how to put it in a table, you just have to do something similar for a form. Just create your textboxes and other form elements dynamically (depending on the data)i.e if you have a yes/no DB field you will create a checkbox, and you will create textboxes for textfields, etc. As usual, you will have beginning and ending form tags.
Bosun (SCJP, SCWCD)
So much trouble in the world -- Bob Marley
subject: how to grab data from a database and display it in a form