Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Any complete JSP + Servlet + MySql Tutorial

 
Andrew Parker
Ranch Hand
Posts: 178
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I created a mysql db to store user info. I want to create a jsp page to let user submit info and create a servlet to get the parameters from the jsp page and then store into the mysql db. The servlet should support connection pool to let concurrent users submit data simultaneously.
Moreover, there will be another jsp page to retrieve data from servlet which get data from mysql db in order to present the info in a browser.
Are there any complete tutorial or source code to teach this skill?
Thanks for any kind help.
Andrew
 
William Brogden
Author and all-around good cowpoke
Rancher
Posts: 13056
6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Just about any servlet/JSP/J2EE book will talk about this common situation. Also there are plenty of tutorials at java.sun.com and other places - just do a search on Yahoo.
You should plan on putting all database access in a "JavaBeans" style class, NOT in the body of the servlet or JSP. That way you can test the code off-line first. The connection pool will also be handled outside the body of the servlet or JSP.
Bill
 
Andrew Parker
Ranch Hand
Posts: 178
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for your kind advice
Andrew
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic