Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to display fields retrieved from a database in Editable mode?

 
Vineet Sharma
Ranch Hand
Posts: 51
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have a servlet that uses JDBC to connect to Access and reads a table. I need to display the data retrieved from the table on an HTML screen in editable mode. In othe words, the user should be able to change the data that I display on the screen, eg., updating user profile.
I am doing the following but it's not working:
htmlString +="TD>" + dbRS.getString(1) = "</TD>";
I would appreciate any feedback.
Thanks,
Vineet
 
Marius Holm
Ranch Hand
Posts: 84
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Vineet,
Then you must use a HTML Element that is editable, as an 'INPUT' element.
htmlString +="TD>" + dbRS.getString(1) = "</TD>";
should be replaced with:
htmlString +="INPUT TYPE='TEXT' NAME='"+ dbRS.getString(x) +"' VALUE='"+ dbRS.getString(1) + "' />";
I've also added a NAME attribute to the INPUT element, as you will need this to update your db when the form is sent.
Good luck,
Marius
 
Vineet Sharma
Ranch Hand
Posts: 51
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Marius for your help. I will try implementing your suggestion.
-Vineet

Originally posted by Vineet Sharma:
I have a servlet that uses JDBC to connect to Access and reads a table. I need to display the data retrieved from the table on an HTML screen in editable mode. In othe words, the user should be able to change the data that I display on the screen, eg., updating user profile.
I am doing the following but it's not working:
htmlString +="TD>" + dbRS.getString(1) = "</TD>";
I would appreciate any feedback.
Thanks,
Vineet

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic