JSP, Servlets and JDBC for Beginners: Build a Database App

JSP, Servlets and JDBC for Beginners: Build a Database App

English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 8.5 Hours | 1.69 GB

JSP: Covers latest versions of JSP 2.3 and Servlets 3.1 – Most Popular JSP/Servlet course

This course is project based and you will build a fully functioning JSP/Servlet web application from scratch.

We start off with a brief overview of JSP and Servlets. Then I show you how to setup your development for JSP by installing Tomcat and Eclipse. Next, I show you how to connect Eclipse and Tomcat for rapid application development.

We cover the key JSP scripting elements: Expressions, Scriptlets and Declaration. For each scripting element, I show you working code examples along with the appropriate use-case and best practices.

You learn about the built-in objects available in JSP. Code examples demonstrate the most common built-in objects.

Next, we cover how to read HTML form data with JSP. This includes reading form data for text fields, drop-down lists, radio buttons and checkboxes.

Then you learn how to manage application state with Sessions and Cookies. You make use of the built-in session object to keep track of actions for a unique user. You also leverage Cookies to personalize a web site for a specific user.

Finally, the course includes JDBC database integration. You learn how to leverage JDBC queries, inserts, updates and deletes in a JSP/Servlet web application.

At the end of this course, you will have a fully functional JSP/Servlet web application that connects to a database. You can use this application as a starting point for your project.

All of the source code and database scripts are provided.

You Will Learn How To

  • Build a fully functioning JSP/Servlet web application from scratch
  • Set up your JSP/Servlet development environment with Tomcat and Eclipse
  • Explore JSP scripting elements: Expressions, Scriptlets and Declarations
  • Read HTML form data with JSP and Servlets
  • Include additional files in your JSP file for a standard look-and-feel
  • Manage application state with Sessions to track unique user actions
  • Leverage Cookies to personalize a web site for a specific user
  • Build a Multi-Lingual app using Internationlization with JSTL
  • Build an MVC application with JSP and Servlets
  • Add database support with JDBC: query, insert, update and delete
  • Build a complete database web app with JDBC
Table of Contents

Course Introduction
1 Introduction
2 Download Source Code and PDFs
3 How To Take This Course – Type the Code with Me
4 How To Get Help
5 Closed Captions and Subtitles Available for English

Getting Started with JSP
6 JSP and Servlets Overview
7 FAQ Are JSP and Servlets still used in 2017 … umm yep
8 Setting Up the Development Environment Overview
9 INSTALL TOMCAT 8 ONLY
10 Installing Tomcat on MS Windows
11 Install Tomcat on Mac
12 Installing Eclipse on MS Windows
13 Install Eclipse on Mac
14 Connecting Eclipse to Tomcat
15 FAQ HELP – Cant Start Tomcat – Ports are in Use

JSP Fundamentals
16 JSP Hello World
17 JSP Expressions
18 JSP Scriptlets
19 JSP Declarations
20 Calling a Java Class from JSP
21 JSP Built-In Objects
22 Including Files in JSP

Reading HTML Form Data with JSP
23 HTML Forms Overview – Part 1
24 HTML Forms Overview – Part 2
25 Drop-Down Lists
26 Radio Buttons
27 Checkboxes – Overview
28 Checkboxes – Write some Code
29 FAQ How to handle when user doesnt select a checkbox

State Management with JSP
30 Tracking user actions with Sessions – Overview
31 Tracking user actions with Sessions – Write some Code
32 FAQ For TO DO list example Im able to enter empty items. How to fix this
33 FAQ Details on PageContext and Session objects
34 Personalize Content with Cookies – Overview
35 Personalize Content with Cookies – App Demo
36 Personalize Content with Cookies – Write some Code
37 FAQ How To Handle White-Space in Cookie Values

JSP Standard Tag Library JSTL – Core Tags
38 JSP Tags Overview
39 Install JSTL JAR files
40 Where can I download the JSTL JAR files from the Internet
41 FAQ Why Two JAR files for JSTL
42 JSTL Core Tags – Looping with forEach – Overview
43 JSTL Core Tags – Project Setup
44 JSTL Core Tags – Looping with forEach – Write some Code
45 JSTL Core Tags – Looping with forEach – Building HTML Tables
46 FAQ Reading Cookies with JSTL
47 JSTL Core Tags – Testing Conditionals with the IF tag
48 JSTL Core Tags – choose Tag

JSP Standard Tag Library JSTL – Function Tags
49 JSTL Function Tags – length toUpperCase and startsWith
50 JSTL Function Tags – split and join

Build a Multi-Lingual App with JSTL – i18n Tags
51 Multi-Lingual Internationalization Overview
52 Multi-Lingual Internationalization Messages
53 Build a Multi-Lingual App with JSTL – Step 1
54 Build a Multi-Lingual App with JSTL – Step 2
55 Build a Multi-Lingual App with JSTL – Step 3

Servlet Fundamentals
56 Hello World Servlet – Overview
57 Hello World Servlet – Lets Write some Code
58 Comparing Servlets and JSP – Whats the Difference
59 Reading HTML Form Data with Servlets – Overview
60 Reading HTML Form Data with Servlets – Lets Write some Code
61 HTML Forms – Difference between GET and POST
62 Reading Servlet Parameters – Overview
63 Reading Servlet Parameters – Lets Write some Code
64 FAQ Can you define per servlet parameters
65 FAQ How To Redirect from JSP to Servlet

MVC – Build an MVC App with Servlets and JSP
66 MVC with Servlets and JSP – Overview
67 MVC with Servlets and JSP – Lets Write some Code
68 MVC with Servlets and JSP – In More Detail
69 MVC with Servlets and JSP – Part 1 – Create Student Class
70 MVC with Servlets and JSP – Part 2 – Create StudentDataUtil
71 MVC with Servlets and JSP – Part 3 – Create MVC Servlet
72 MVC with Servlets and JSP – Part 4 – Create JSP View with HTML Tables

Build A Complete Database Web App with JDBC – Part 1
73 Project Overview and Demo
74 Download JDBC Source Code
75 Installing the MySQL Database on MS Windows
76 Installing the MySQL Database on Mac
77 Setting up our Project Database with Sample Data
78 Setup Tomcat Datasource for Connection Pooling
79 Test Tomcat Connection Pooling
80 Resources Tune and Configure Tomcat JDBC Connection Pool for Production Use
81 MVC Application Architecture

Build A Complete Database Web App with JDBC – Part 2
82 List Students – Overview
83 List Students – Creating the JDBC Code
84 List Students – Building the Servlet
85 List Students – Developing the JSP
86 List Students – Making it Pretty with Cascading Style Sheets CSS
87 List Students – Adding JSTL Functionality
88 List Students – Adding a Welcome File

Build A Complete Database Web App with JDBC – Part 3
89 Add Student – Overview
90 Add Student – Setting up the Button
91 Add Student – Constructing the HTML Form
92 Add Student – Developing the Servlet
93 Add Student – Creating the JDBC Code

Build A Complete Database Web App with JDBC – Part 4
94 Update Student – Overview
95 Update Student – Creating the Update Link
96 Update Student – Prepopulating the HTML Form – Part 1
97 Update Student – Prepopulating the HTML Form – Part 2
98 Update Student – Developing the Servlet
99 Update Student – Creating the JDBC Code

Build A Complete Database Web App with JDBC – Part 5
100 Delete Student – Overview
101 Delete Student – Creating the Delete Link
102 Delete Student – Developing the Servlet and JDBC Code

Summary
103 JDBC Project Review
104 Thank You and Please Leave a Rating for the Course

Bonus – Deploying a WAR file to Tomcat
105 Bonus – Deploying To Tomcat using WAR files

Discount Coupon for More of My Java Training
106 Discount Coupon for More of My Java Training
107 Direct Links to My Java Courses

Appendix
108 FAQ How to Import Eclipse Projects
109 Resolve Issue Clicking RefreshReload button results in adding same student
110 FAQ How to use Bootstrap with JSP
111 How to Secure your Web Application – Security
112 FAQ Sensitive Data in the URL Maybe use POST instead
113 FAQ How to use Maven with JSP-Servlet Projects
114 FAQ How to add Search features to the App