List Students - Creating the JDBC Code | luv2code

Autoplay
Autocomplete

Previous Lesson Complete and Continue

JSP and Servlets for Beginners: Build a Database App

Course Introduction

Introduction (1:39)
Download Source Code and Slide PDFs
Closed Captions / Subtitles Available
JSP and Servlets Overview (4:15)

Set Up Development Environment

Overview (1:27)
Install Tomcat on Windows (5:06)
Install Eclipse on Windows (4:48)
Install Tomcat on Mac (5:46)
Install Eclipse on Mac (4:06)
Connect Eclipse to Tomcat (2:47)

JSP Fundamentals

JSP Hello World (7:45)
JSP Expressions (7:24)
JSP Scriptlets (5:17)
JSP Declarations (5:22)
Calling Java Class from JSP (7:02)
JSP Built-In Objects (5:21)
Including Files (5:24)
HTML Forms Overview - Part 1 (4:21)
HTML Forms Overview - Part 2 (4:26)
Drop-Down Lists (7:26)
Radio Buttons (7:16)
Checkboxes - Part 1 (3:27)
Checkboxes - Part 2 (6:55)

State Management with JSP

JSP Sessions - Overview (8:18)
JSP Sessions - Write Some Code! (10:35)
Cookies - Overview (12:21)
Cookies - App Demo (3:03)
Cookies - Write Some Code (11:50)

JSP Standard Tag Library (JSTL) - Core and Function Tags

JSTL Tags Overview (5:10)
Installing JSTL JAR Files (5:27)
JSTL Core Tags - Looping with forEach - Overview (5:19)
JSTL Core Tags - Looping with forEach - Write Some Code! (3:19)
JSTL Core Tags - Looping with forEach - Overview - Building HTML Tables (11:07)
JSTL Core Tags - Testing Conditionals with the IF tag (5:08)
JSTL Core Tags - choose tag (3:58)
JSTL Function Tags - length, upperCase and startsWith (6:12)
JSTL Function Tags - split and join (6:48)

Build a Multi-Lingual App with JSTL - i18n Tags

Internationalization Overview (5:35)
Internationalization Messages (9:03)
Build a Multi-Lingual App with JSTL - Step 1 (7:17)
Build a Multi-Lingual App with JSTL - Step 2 (3:40)
Build a Multi-Lingual App with JSTL - Step 3 (7:58)

Servlet Fundamentals

Hello World Servlet - Overview (3:47)
Hello World Servlet - Write Some Code (8:32)
Comparing Servlets and JSP (3:21)
Reading HTML Form Data with Servlets - Overview (2:29)
Reading HTML Form Data with Servlets - Write Some Code (7:23)
HTML Forms - Difference between GET and POST (4:33)
Reading Servlet Parameters - Overview (4:19)
Reading Servlet Parameters - Write Some Code (7:57)

MVC - Build an MVC app with Servlets and JSP

MVC with Servlets and JSP - Overview (5:19)
MVC with Servlets and JSP - Write Some Code (8:58)
MVC with Servlets and JSP - In More Detail (2:04)
MVC with Servlets and JSP - Part 1 - Create Student Class (3:27)
MVC with Servlets and JSP - Part 2 - Create StudentDataUtil (3:59)
MVC with Servlets and JSP - Part 3 - Create MVC Servlet (4:35)
MVC with Servlets and JSP - Part 4 - Create JSP View with HTML (7:41)

Build A Complete Database Web App with JDBC - Part 1

Project Overview and Demo (3:56)
Download JDBC Source Code (3:23)
Install MySQL Database (4:41)
Setting up Project Database with Sample Data (4:56)
Setting up Tomcat DataSource for Connection Pooling (7:11)
Test Tomcat Connection Pooling (13:46)
MVC Application Architecture (2:18)

Build A Complete Database Web App with JDBC - Part 2

List Students - Overview (5:36)
List Students - Creating the JDBC Code (11:51)
List Students - Building the Servlet (11:03)
List Students - Developing the JSP (9:00)
List Students - Making it Pretty with Cascading Style Sheets (CSS) (3:59)
List Students - Adding JSTL Functionality (7:44)
List Students - Adding a Welcome File (6:46)

Build A Complete Database Web App with JDBC - Part 3

Add Student - Overview (3:32)
Add Student - Setting up the Button (4:19)
Add Student - Constructing the HTML Form (8:57)
Add Student - Developing the Servlet (9:47)
Add Student - Creating the JDBC Code (7:28)

Build A Complete Database Web App with JDBC - Part 4

Update Student - Overview (4:33)
Update Student - Creating the Update Link (5:54)
Update Student - Prepopulating the HTML Form - Part 1 (13:52)
Update Student - Prepopulating the HTML Form - Part 2 (6:12)
Update Student - Developing the Servlet (6:41)
Update Student - Creating the JDBC Code (9:45)

Build A Complete Database Web App with JDBC - Part 5

Delete Student - Overview (3:16)
Delete Student - Creating the Delete Link (7:35)
Delete Student - Developing the Servlet and JDBC Code (11:33)
JDBC Project Review (1:10)

Bonus

FAQ: How do I import Eclipse projects?
FAQ: How to use Maven with JSP-Servlet Projects
Resolve Issue: Clicking Refresh/Reload button results in adding same student
FAQ: How to use Bootstrap with JSP
FAQ: How to add Search features to the App?

Teach online with

List Students - Creating the JDBC Code

Complete and Continue

Discussion

3 comments