This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
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
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