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 organised 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
