Blog
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Java Web JSP / Servlets Development and Database Design
Principles of web development and J2EE
Source code
Introduction to client-server architecture (6:24)
Introduction to JSP, servlet and servlet containers (2:05)
General structure of the Java web project (6:30)
HTTP servlets in details (6:58)
web.xml deployment descriptor and deploying the application to servlet container (6:55)
Using HTTP post methods in JSP and servlet (5:53)
HTTP Methods
HttpServletResponse object and accessing it with scriptlets (5:43)
Request, session and application scopes (5:51)
Demonstration of session scope (1:59)
Request forwarding and request redirection (5:37)
JSP actions (get/set property) to access objects in every scope easily (5:42)
getBean()/setBean() scriptlets and getAttribute()/setAttribute methods in action (3:13)
WORKING WITH DATABASES
Executing DB script and downloading source code
Introduction to database design principles - Database normalization (11:41)
Database Design Basics
select, insert, delete, update queries (17:36)
Database connections, JDBC basics and DB connection pools (4:09)
Database transactions - All or nothing principle (3:08)
ACID properties of database transactions (9:15)
DB table relations - One to many, many to many with example scenario (12:00)
Joining tables - Inner join, outer join with examples (16:57)
CODING OUR QA PLATFORM
Understanding the flow that we will code (6:05)
Get DB connection with JDBC - Use case: User management module (8:44)
Great performance improvement with DB connection pools (2:40)
Statement and PreparedStatement - Use case: User Management Module (17:23)
Select queries, count queries and ResultSet object with examples (10:33)
Initializing DB connection pools on application bootstrapping (17:51)
Database Connection Pools
Showing the results of DB operations to the user (12:17)
Developing complete email validation system (14:36)
Developing complete login system (13:08)
Design Patterns and Applying Them to QA Project
Definition and importance of design patterns (8:43)
Design Patterns
Template pattern and Data Access Object (DAO) pattern (11:32)
DAO pattern and template pattern
Coding DAO pattern, template pattern, dynamic SQL values and row mappers (12:36)
Code walkthrough 1 - Search for a member in member DAO (9:23)
Code walkthrough 2 - Insert a member in member DAO (3:42)
Combining DAO and service layers (11:17)
Combining service layer and view layer (6:29)
Code walkthrough 3 - Integrated view layer, service layer, DAO layer (17:33)
Code walkthrough 4 - Question voting system (17:10)
MAKE THE PROJECT WEB 2.0
USE AJAX FOR ASYNCHRONOUS PROCESS (20:55)
USE BOOTSTRAP FOR MODERN AND RESPONSIVE DESIGN
ADVANCED TOPICS
SERVLET FILTERS FOR SECURITY
ADDING INDEXES TO DATATABASE TABLES
ADDING FOREIGN KEYS TO DATABASE TABLES
ADDING LOGGING MECHANISM
READING TEXTS FROM PROPERTIES
URL REWRITING FOR SEO
Teach online with
Get DB connection with JDBC - Use case: User management module
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock