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.