Java Advanced Course Outline

JDBC

• Introduction to JDBC/ODBC
• Introduction to RDBMS
• Creating DSN’s and using ODBC drivers
• java.sql package
• Database connection object
• Statement objects
• Prepared Statement objects
• Stored Procedures
• Callable Statements
• Result Set objects
• Selecting and querying the database
• Inserting and Updating RDBMS

Servlets

• Introduction to Web Development
• JSDK 2.1 kit installation and configuration
• Servlets and Servlet API basics
• Writing first servlet
• Running and debugging servlets
• Understanding doGet() and doPost() methods
• Request and response objects
• Writing thread safe servlets
• Session and state management
• Understanding and using cookies for session management
• JDBC architecture
• Database access with JDBC

JSP (Java Server Pages)

·         Introduction to Java Server Pages

·         JSP, JSP API

·         Installing and configuring web servers (Jakarta Tomcat 3.2)

·         Writing first JSP code

·         Writing scriptlets in JSP

·         Creating custom tags

·         Variable declaration in JSP

·       Setting and getting properties in JSP