Overview
 |
Three Tiers for J2EE |
|
|
Three Tiers for J2SE |
|
|
The Case Study |
|
|
Design Patterns |
|
|
Domain and Service Models |
Database and SQL Fundamentals
|
Relational Databases and SQL |
|
|
Database, Schema, Tables, Columns and Rows |
|
|
DDL-Creating and Managing Database Objects |
|
|
DML-Retrieving and Managing Data |
|
|
Sequences , Stored Procedures |
|
|
Using SQL Terminals |
JDBC Fundamentals
|
What is the JDBC API? |
|
|
JDBC Drivers |
|
|
Making a Connection |
|
|
Creating and Executing a Statement |
|
|
Retrieving Values from a ResultSet |
|
|
SQL and Java Datatypes |
|
|
Creating and Updating Tables |
|
|
Handling SQL Exceptions and Proper Cleanup |
|
|
Handling SQLWarning |
Advanced JDBC
|
SQL Escape Syntax |
|
|
Conditional (if) Statements |
|
|
Using Prepared Statements |
|
|
Using Callable Statements |
|
|
Scrollable Result Sets |
|
|
Updatable Result Sets |
|
|
Transactions , Commits, Rollbacks, and Savepoints |
|
|
Batch Processing |
Introduction to Row Sets
|
Row Sets in GUI and J2EE programming |
|
|
Advantages of RowSets , RowSet Specializations |
|
|
Use of CachedRowSets |
JDBC classes and the java.sql
|
DriverManager and DataSource Connection |
|
|
Statement, PreparedStatement, and CallableStatement |
|
|
ResultSet |
|
|
javax.sql package |
|
|
Rowsets |
Connecting to databases
|
Selecting and installing a database driver |
|
|
Connecting to the database via a network address |
|
|
Connecting to the database based on information supplied by JNDI (the Java Naming and Directory Interface) |
|
|
Using the java.sql.DataSource class |
|
|
Increasing performance with connection pooling |
|
|
Opening and closing the connection |
|
|
Handling ClassNotFoundException and SQLException |
JDBC design patterns
|
Overview of client tier, presentation tier, business tier, and resource tier patterns |
|
|
The data access object pattern |
|
|
The value object pattern |
|
|
The model-view-controller pattern |
Servlet
|
HTML Forms |
|
|
Servlets Overview |
|
|
Servlet Lifecycle: init(), service(), destroy() |
|
|
GenericServlet, ServletRequest, and ServletResponse |
|
|
HttpServletRequest, HttpServletResponse and HttpServlet |
|
|
Request-response, headers, GET, POST |
|
|
Accessing Parameters |
Additional Servlet Capabilities
|
HTTP headers and MIME types |
|
|
RequestDispatcher: Including and forwarding |
|
|
Sharing data with the request object attributes |
|
|
Sharing data with ServletContext attributes |
|
|
Error Handling |
JavaServer Pages
|
Basics and Overview |
|
|
JSP architecture , JSP tags and JSP expressions |
|
|
Fixed Template Data , Lifecycle of a JSP |
|
|
Model View Controller (MVC |
|
|
Model 1/Model 2 Architecture |
|
|
Data Sharing among servlets & JSP |
|
|
Request, application, session and page scope |
|
|
JSP implicit objects |
Session Management
|
HTTP as a stateless protocol |
|
|
Hidden form fields |
|
|
Cookies |
|
|
session tracking |
|
|
HttpSession |
|
|
Exception handling and error pages |
|
|
Directives |
|
|
SingleThreadModel interface |