Java Workshop Server Side (Servlets/JSPs/JavaBeans/JDBC)

Objectives

This course explores Java's database connectivity package, JDBC. Topics include JDBC elements, the steps used to access a database with JDBC, data retrieval issues, and some of the advanced features that will gain more support with future releases of the JDBC API.


Pre-requisites:

This course is intended for programmers who have at least six months experience in Java and who want to learn about server side programming, accessing DBs.


Course Includes:

A comprehensive set of reference notes covering course topics, follow-up telephone support and, for training on Transmedia premises, lunch and refreshments.


Course Outline


JDBC


· How to access a D/B: load drivers, establish connection, write/execute SQL, retrieve Result sets;
· Retrieval, update, delete, change to D/B; batch updates, usage of procs
· Use of Metadata for "Ad Hoc" reporting
· Handling Scrollable and Updateable ResultSets


Apache-Tomcat Server


· Install onto students PC
· How organized and structured
· set path & classpath variables
· install ".class" files for Servlets & JSPs
· Start/Stop Server
· Execute Servlets, JSPs & HTML


Servlets


· Life cycle
· How packaged on Server
· Call a Servlets from an HTML document
· Send HTML response to a Client


Servlets & Form Data


· Servlets obtain data from an HTML document (sent by the Client)
· Send information, in HTML format, back to the client


Servlets & JDBC


· Access a D\B from a Servlets using JDBC
· Client will be required to successfully logon to the server
· Client will be given choices of displaying, adding, deleting and changing the D\B records
· Examples of using MetaData code will be provided to demonstrate flexible "ad hoc" reporting capabilities






Sessions Tracking


· The Java Session object; adding to the LogIn Servlet
· Session termination


JSP Scripting


· JSP Life Cycle; how JSP becomes a Servlet; location of generated Servlets source and byte code
· Review and apply Java tags


JSP Directives


· Review and apply
· Discuss impacts on performance


Includes, JDBC, Servlets, Cookies


· Review and demonstrate use


Java Beans


· Conventions; Using in Servlets & JSPs
· Scope for page, request, session and application
· Apply to MVC to handle all data requests via JDBC


Servlets Request Headers and Status Codes


· General information
· Optimising performance


Collections


· Review data structures available
· Compare performance advantages


Overview / Examples Networking


· Distributed Objects (including RMI / Remote Procedural Calls)


Server Security Overview


· Authentication , Authorisation, Confidentiality, Data Integrity
· Use of Roles and Responsibilities
· Implemented via server XML files
· Demo using Tomcat security