Win a copy of Cross-Platform Desktop Applications: Using Node, Electron, and NW.js this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Problem updating access database from jsp  RSS feed

 
Greg James
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all. I am trying to update a microsoft access database using a couple of JSP forms and a database connector class. In theorey, I have a homepage from which you can select an entry and then the update button, which takes you to the UpdateTeamForm.jsp and displays all the fields in textboxes (This works so far), then I want to be able to change the textfields and click the update button on that form, which should send the information to UpdateTeam.jsp which utilises the updateTeam method from the database connector to execute an SQL statement and update the information in the database. However, for some reason the object isn't being passed. Either between the UpdateTeamForm.jsp and the UpdateTeam.jsp or between the UpdateTeam.jsp and the database connector. I have posted the code for the JSPs and Classes involved below. Can anyone spot anything wrong?


UpdateTeamForm.jsp:


UpdateTeam.Jsp:


Database connector:


Any help would be much appreciated

Thanks,
Greg.



 
Kuldip Shetty
Ranch Hand
Posts: 45
Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Greg, is the database commit missing in the above code after the update operation.

Kuldip
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!