In the first part we built a simple web application with Servlets and
JSP. We skipped over some of the finer details, specifically accessing
the database using Servlets. In this part we will modify our Login
Servlet to validate the userid and password with those from the
database.
What will we Cover:
- JDBC a brief introduction
- Retrieving Data - a simple JDBC example
- STEP 1: Make a connection
- STEP 2: Use this Connection to access the Database
- The complete ValidateUser method
- Overview of JDBC 2.0
- Connection pooling and introduction to application servers
What you should know:
- RDBMS Concepts
- Basic SQL commands
Also the assumption is that you understood the
sample application
we built in part 1.
Contents:
JDBC a Brief Introduction
Retrieving Data - a Simple JDBC Example
STEP 2: Use This Connection to Access the Database
The Complete ValidateUser Method
JDBC 2.0
Connection Pooling and Introduction to Application Servers
Appendix
New on the Java Boutique:
New Review:
Time Management Made Easy with the Quartz Enterprise Job Scheduler
Why not just use the Java timer API? This open source scheduling
API boasts simplicity, ease-of-integration, a well-rounded feature
set, and it's free!
New Applet:
Reverse Complement
Reverse Complement is a simple applet that converts DNA or RNA
sequences into three useful formats.
Elsewhere on internet.com:
WebDeveloper Java
Lots of Java information on webdeveloper.com
WDVL Java
Thorough Java resource at the Web Developer's Virtual Library.
ScriptSearch Java
Hundreds of free Java code files to download.
jGuru: Your View of the Java Universe
Customizable portal with online training, FAQs, regular news updates, and tutorials.