This week's book giveaway is in the Java 8 forum.
We're giving away four copies of Java 8 in Action and have Raoul-Gabriel Urma, Mario Fusco, and Alan Mycroft on-line!
See this thread for details.
The moose likes Servlets and the fly likes Any complete JSP + Servlet + MySql Tutorial Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Java » Servlets
Bookmark "Any complete JSP + Servlet + MySql Tutorial" Watch "Any complete JSP + Servlet + MySql Tutorial" New topic
Author

Any complete JSP + Servlet + MySql Tutorial

Andrew Parker
Ranch Hand

Joined: Nov 12, 2001
Posts: 178
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

Joined: Mar 22, 2000
Posts: 12682
    
    5
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


Java Resources at www.wbrogden.com
Andrew Parker
Ranch Hand

Joined: Nov 12, 2001
Posts: 178
Thanks for your kind advice
Andrew
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Any complete JSP + Servlet + MySql Tutorial
 
Similar Threads
JSP to Bean to Servlet
Help Needed in building my application.
Any complete JSP + Servlet + MySql Tutorial
JSP Basic or MVC question
Any complete JSP + Servlet + MySql Tutorial