JSP Servlet and JDBC Build a Database App Workshop

Module 1: Getting Started with JSP

• JSP and Servlets Overview
• Setting Up the Development Enviroment
• Installing Tomcat on MS Windows
• Installing Tomcat on Mac
• Installing Eclipse on MS Windows
• Install Eclipse on Mac
• Connectin Eclipse on Tomcat

Module 2: JSP Fundamentals

• JSP Hello World
• JSP Expressions
• JSP Scriptlets
• JSP Declarations
• Calling a Java Class from JSP
• JSP Built-In Object
• Including Files in JSP

Module 3: Reading HTML Form Data with JSP

• HTML Forms Overview
• Drop-Down Lists
• Radio Buttons
• Checkboxes - Overview
• Checkboxes - Write som Code

Module 4: State Management wit JSP

• Tracking user actions with Sessions Overview
• Tracking user actions with Sessions Write Code
• Personalize Content with Cookie Overview
• Personalize Content with Cookies App
• Personalize Content with Cookies Write Code

Module 5: JSP Standard Tag Library (JSTL) - Core Tags

• JSP Tags Overview
• Install JSTL JAR files
• JSTL Core Tags - Looping with forEach Overview
• JSTL Core Tags Project Setup
• JSTL Core Tags Looping with forEach - Write Code
• JSTL Core Tags Looping with for Each Building HTML Tables
• Reading Cookies with JSTL
• JSTL Core Tags Testing Conditionals with the IF tag
• JSTL Core Tags choose Tag

Module 6: JSP Standard Tag (JSTL) - Function Tags

• JSTL Function Tags length toUpperCase and startsWith
• JSTL Function Tags split and join

Module 7: Build a Multi-Lingual App with JSTL i18n Tags

• Multi-Lingual / Internationalization Overview
• Multi-Lingual / Internationalization Message
• Build a Multi - Lingual App with JSTL

Module 8: Servlet Fundamentals 

• Hello World Servlet Overview
• Hello World Servlet Let's Write some code
• Comparing Servlets and JSP What's the Difference
• Reading HTML Form Data with Servlets Overview
• HTML Forms Difference between GET and POST
• Reading Servlet Parameter
• Reading Servlet Parameter Write some Code

Module 9: MVC- Build and MVC App with Servlets and JSP

• MVC with Servlets and JSP
• MVC with Servlets and JSP In More Detail
• MVC with Servlets and JSP Create Student Class
• MVC with Servlets and JSP Create StudentDataUtil
• MVC with Servlets and JSP Create MVC Servlet
• MVC with Servlets and JSP Create JSP View with HTML Tables

Module 10: Build A Complete Database Web App with JDBC - Live workshop part 1

• Project Overview and Demo
• Download JDBC Source Code
• Installing the MySQL Database on MS Windows
• Installing the MySQL Database on Mac
• Setting up our Project Database with Sample Data
• Setup Tomcat Datasource for Connection Pooling
• Test Tomcat Connection Pooling
• Tune and Configure Tomcat JDBC Connection Pool for Production Use
• MVC Application Architecture

Module 11: Build A Complete Database Web App with JDBC - Live workshop part 2

• List Students - Overview
• List Students - Creating the JDBC Code
• List Students - Building the Servlet
• List Students - Developing the JSP
• List Students - Making it Pretty with Cascading Style Sheets (CSS)
• List Students - Adding JSTL Functionality
• List Students - Adding a Welcome File
• Add Student - Overview
• Add Student - Setting up the Button
• Add Student - Constructing the HTML Form
• Add Student - Developing the Servlet
• Add Student - Creating the JDBC Code

Module 12: Build A Complete Database Web App with JDBC - Live workshop part 3

• Update Student - Overview
• Update Student - Creating the Update Link
• Update Student - Prepopulating the HTML Form - Part 1
• Update Student - Prepopulating the HTML Form - Part 2
• Update Student - Developing the Servlet
• Update Student - Creating the JDBC Code
• Delete Student - Overview
• Delete Student - Creating the Delete Link
• Delete Student - Developing the Servlet and JDBC Code

Module 13: Deploying a WAR file to Tomcat

• Deploying To Tomcat using WAR files