Building Web Applications with Servlets, JDBC and JSP (5 days)

Building Web Applications with Servlets, JDBC and JSP Course Overview

This practical, application-oriented Java training course teaches Java Servlets, JDBC and JSP and shows how to use it to develop simple to complex database-driven Web applications. It is intended for experienced Java (J2SE) programmers who want to build Web applications or J2EE components and systems.

Building Web Applications with Servlets, JDBC and JSP Course Goals

• Understand and appreciate the role of Java Servlets in the overall Java 2 Enterprise Edition architecture, and as the best Java solution to HTTP application development
• Use request and response objects provided to a servlet to read CGI parameters and to produce an HTML response
• Develop interactive Web applications using HTML forms and servlets
• Manage complex conversations with HTTP clients using session attributes
• Understand the role of JDBC in Java persistence code, and use JDBC for persistence in servlet applications
• Preserve portability and ease of administration for a servlet application by parameterizing servlet code, using initialization parameters, properties files, and JNDI
• Use JavaBeans classes to share complex business data between components
• Implement filters to adapt existing servlets with new features, and to maximize the decomposition of logic between vertical business functions and horizontal facilities
• Gain an in-depth understanding of database programming in Java using JDBC
• Learn the details of SQL programming through the JDBC interface
• Describe JavaServer Pages and their relationship to servlets and J2EE generally
• Describe how a JSP is translated into a servlet and processed at runtime
• Explain the use of directives on JSPs and outline the principal directives
• Implement simple JSPs that use Java code in declarations, expressions and scriptlets
• Enumerate and use the implicit objects available to scripting elements
• Implement an interactive Web application using HTML forms and JSP
• Use Java exception handling and JSP error pages to handle errors in JSP applications
• Implement session management for a JSP application
• Manage cookies to store client-specific information at various scopes and durations
• Use JavaBeans to implement effective interactive JSP applications
• Describe custom tags in JSP and explain how they are implemented, both using Java and JSP itself, and how they are used
• Discuss threading issues in JSP and describe the use of directives to control how threading is handled
• Describe the various uses of XML in JSP applications
• Deploy a logical Web application to a Web server in a WAR file

Building Web Applications with Servlets, JDBC and JSP Course Prerequisites

Experience in the following areas is required:

• Java

Experience in the following areas would be beneficial.

• HTML
• XML

Building Web Applications with Servlets, JDBC and JSP Course Outline

1. Web Applications
   1. Server-Side Programming
   2. Web Protocols and Web Applications
   3. Role of Web Servers
   4. Java Servlets
   5. Using Tomcat Web server
   6. Structure of a Java Servlet
2. Servlets Architecture
   1. Servlets Architecture
   2. Servlet and HttpServlet
   3. Request and Response
   4. Reading Request Parameters
   5. Producing an HTML Response
   6. Redirecting the Web Server
   7. Deployment Descriptors
   8. Servlets Life Cycle
   9. Relationship to the Container
3. Interactive Web Applications
   1. Building an HTML Interface
   2. HTML Forms
   3. Handling Form Input
   4. Application Architecture
   5. Single-Servlet Model
   6. Multiple-Servlet Model
   7. Routing Servlet Model
   8. Template Parsers
4. Session Management
   1. Managing Client State
   2. Sessions
   3. Session Implementations
   4. HttpSession
   5. Session Attributes
   6. Session Events
   7. Invalidating Sessions
5. Configuration and Context
   1. The Need for Configuration
   2. Initialization Parameters
   3. Properties Files
   4. JNDI and the Component Environment
   5. JDBC Data Sources
   6. Working with XML Data
6. Filters
   1. Servlet Filters
   2. Uses for Filters
   3. Building a Filter
   4. Filter Configuration and Context
   5. Filter Chains
   6. Deploying Filters
7. Database and SQL Fundamentals
   1. Relational Databases and SQL
   2. SQL Versions and Code Portability
   3. Database, Schema, Tables, Columns and Rows
   4. DDL - Creating and Managing Database Objects
   5. DML - Retrieving and Managing Data
   6. Sequences
   7. Stored Procedures
   8. Result Sets and Cursors
   9. Using SQL Terminals
8. JDBC Fundamentals
   1. What is the JDBC API?
   2. JDBC Drivers
   3. Making a Connection
   4. Creating and Executing a Statement
   5. Retrieving Values from a ResultSet
   6. SQL and Java Datatypes
   7. SQL NULL Versus Java null
   8. Creating and Updating Tables
   9. Handling SQL Exceptions and Proper Cleanup
   10. Handling SQLWarning
9. Advanced JDBC
   1. SQL Escape Syntax
   2. Using Prepared Statements
   3. Using Callable Statements
   4. Scrollable Result Sets
   5. Updatable Result Sets
   6. Transactions
   7. Commits, Rollbacks, and Savepoints
   8. Batch Processing
   9. Alternatives to JDBC
10. Introduction to Row Sets
    1. Row Sets in GUI and J2EE programming
    2. Advantages of RowSets
    3. RowSet Specializations
    4. Using CachedRowSets
11. JSP Architecture
    1. JSP Containers
    2. Servlet Architecture
    3. Page Translation
    4. Types of JSP Content
    5. Directives
    6. Content Type
    7. Buffering
    8. Scripting Elements
    9. JSP Expressions
    10. Standard Actions
    11. Custom Actions and JSTL
    12. Objects and Scopes
    13. Implicit Objects
    14. JSP Lifecycle
12. Scripting Elements
    1. Translation of Template Content
    2. Scriptlets
    3. Expressions
    4. Declarations
    5. Dos and Don'ts
    6. Implicit Objects for Scriptlets
    7. The request Object
    8. The response Object
    9. The out Object
13. Interactive JSP Applications
    1. HTML Forms
    2. Reading CGI Parameters
    3. JSPs and Java Classes
    4. Error Handling
    5. Session Management
    6. The Session API
    7. Cookies and JSP
14. Using JavaBeans
    1. Separating Presentation and Business Logic
    2. JSP Actions
    3. JavaBeans
    4. Working with Properties
    5. <jsp:useBean>
    6. <jsp:getProperty> and <jsp:setProperty>
    7. Using Form Parameters with Beans
    8. Objects and Scopes
    9. Working with Vectors
15. The Expression Language and the JSTL
    1. Going Scriptless
    2. The JSP Expression Language
    3. EL Syntax
    4. Type Coercio
    5. Error Handling
    6. Implicit Objects for EL
    7. The JSP Standard Tag Library
    8. Role of JSTL
    9. The Core Actions
    10. Using Beans with JSTL
    11. The Formatting Actions
    12. Scripts vs. EL/JSTL
16. Advanced JSP Features
    1. Web Components
    2. Forwarding
    3. Inclusion
    4. Passing Parameters
    5. Custom Tag Libraries
    6. Tag Library Architecture
    7. Implementing in Java or JSP
    8. Threads
    9. Strategies for Thread Safety
    10. XML and JSP
    11. JSP for Web Services

Building Web Applications with Servlets, JDBC and JSP Course Materials

Each student will receive a comprehensive set of materials, including course notes and all the programming examples.

Building Web Applications with Servlets, JDBC and JSP Course Technical Requirements and Setup Instructions

Click here for technical requirements and setup instructions