What you'll learn

How to build Web Applications using Java Servlets, JSPs, JSTL and AJAX

Course content

9 sections • 33 lectures • 15h 13m total length

Getting Started with MySQL28:57
How to download and install MySQL
How to create database
How to create tables in a specific database
How to use MySQL Workbench
Getting Started with Eclipse8:00
How to download and install Eclipse
Course Material, Projects at GitHub and Assignments0:19
Here are the resources like Course Material, GitHub Repository and link to Assignments.

Introduction to JDBC9:57
What is JDBC API
What is JDBC Driver
What is Workspace in Eclipse
How to create a new Project in Eclipse
Connecting to MySQL Database40:02
How to connect to MySQL
How to configure project to use MySQL JDBC Driver
How to use Statement to insert row into table
Executing DML commands25:54
How to use a DML command with Statement
How to use PreparedStatement and pass parameters to execute DML commands
Executing Query8:02
How to execute query to retrieve data
How to use ResultSet
JDBC API vs. JDBC Driver21:54
Understanding relationship between JDBC API and JDBC Drivers
JDBC interfaces and Driver classes
Types of JDBC Drivers14:29
What are different JDBC Drivers
Different JDBC Drivers and their characteristics
Transaction Management14:50
What is a Transaction
How to start, commit and rollback a transaction
How to use BatchUpdate to execute multiple DML commands as a batch
Using RowSet35:12
What is a RowSet
How to use CachedRowSet
How to use FilteredRowset
Test Your Knowledge About JDBC

Creating Servlets and receiving data from client53:38
How to create a Servlet
How to read request parameters sent from client
Understanding Http Request and Http Response
How to create HTML form and send data from form to Servlet
Difference between GET and POST requests20:06
How data is sent from client to server in GET request
How data is sent from client to server in POST request
When to use POST request
Servlet API and Servlet Life Cycle42:12
How to use Servlet API
Understanding Servlet Life Cycle
How to create deployment descriptor - web.xml
How to configure Servlet using web.xml
How to pass init parameters to Servlet from web.xml
How to receive init parameters using ServletConfig
Uploading Files from Client to Server39:09
How to upload a file from Client to Server
How to use File Control and Enctype attribute of HTML form
How to receive uploaded files from Client in Servlet using @MultipartConfig and Part API
Accessing File System from Servlet5:08
Understanding the difference between Virtual and Physical Path
How to retrieve Files from File System
How to access uploaded photos and display them using img tag from Servlet
Test Your Knowledge About Java Servlets

Creating JSPs47:20
How to create JSP
How to use JSP Scriptlets and Expressions
How to receive data sent from HTML form in JSP
How to create JSP with both HTML form and Java code to process form data (all-in-one JSP)
Life Cycle of JSP12:55
Understand Life Cycle of JSP
Understand how JSP is converted to class and compiled
Understand importance of _jspService(), jspInit() and jspDestroy()
Accessing MySQL database from JSP37:53
How to use JDBC to access MySQL from JSP
How to make JDBC driver available to Web Application
How to send data retrieved from Database to client as HTML table
How to take data from HTML form and manipulate Database using that data
Using Java Beans50:46
Redirection and Navigation48:42
How to redirect from one JSP to another using client-side redirection with sendRedirect()
What is server-side redirection
Understand the difference between <jsp:include> and <jsp:forward>
How to send data from one page to another using request attributes
Expression Language7:29
What is Expression Language
How to use predefined objects such as requestScope, param and header
How to use Java Beans using Expression Language
Understand different scopes where objects can be stored in Web Applications
Cookies43:15
What is a Cookie
What are different properties of a Cookie
Understand the difference between Persistent and Session Cookie
How to create a Cookie in JSP and send to Client
How to retrieve data from a Cookie and use it in JSP
Sessions47:11
What is a Session
When a Session is created and terminated
How to use Session attributes to store and retrieve data in Server
How to configure Session timeout using web.xml
Test Your Knowledge About Java Server Pages

Listeners20:14
What is a Listener
How to create a Listener
How to use a Listener to handle Application and Session events
How to count number of active sessions using Listener
Filters19:21
What is a Filter
How to create a Filter
How to intercept request with Filter
How to enable and disable a Filter
Deploying Web Application19:11
Understanding the structure of Java EE Web Application
How to use standalone Tomcat
How to prepare Web Application for deployment to Tomcat
How to deploy Web Application to Tomcat
Test Your Knowledge About Miscellaneous Topics

Requirements

Knowledge of Java Language and basics of SQL
Elementary knowledge of HTML, CSS and JavaScript

Description

This course teaches how to build a complete Web Application using JDBC, MySQL, Java Servlets, JSPs, JSTL and AJAX.

It covers every step related to developing a Web Application right from how to install required software (MySQL database and Eclipse IDE for Java Enterprise Developer) to deploying final application to web server (Tomcat).

This course covers the following topics:

JDBC - Java Database Connectivity

Connection to MySQL using different types of drivers
Using Statement and PreparedStatement
Working with ResultSet and ResultSetMetaData
Scrollable and updatable ResultSet
Calling stored procedures using CallableStatement
Understanding relationship between JDBC API and drivers
Transaction management
Batch update
Pros and cons of different types of drivers
RowSets

Java Servlets

Understanding web application structure
Creating a Servlet and calling it
Understanding HTTP methods doGet(), doPost()
Life cycle of servlet and init parameters
File uploading
Working with Listeners
Using filters

JSP (Java Server Pages)

Structure of Java server page
JSP containing code and form
Using implicit objects in JSP
Using JavaBeans with JSP
Accessing database from JSP
Working with expression language
Creating and using Cookies
Creating and using Http sessions
Navigation and Redirection

JSTL (Java Server Pages Tag Library)

Understanding JSTL and including it in the project
Working with Core tags
Working with SQL tags and XML tags

AJAX and jQuery

What is AJAX
Using XMLHttpRequest (XHR) object to make request
Servlet/JSP sending JSON using Gson
Using JavaScript to process JSON
What is jQuery and how to work with selectors in jQuery
Using jQuery to make AJAX request

Who this course is for:

Anyone who wants to build Web Applications using Java EE

What you'll learn

Explore related topics

Course content

Getting Started3 lectures • 37min

Java Database Connectivity (JDBC)8 lectures • 2hr 50min

Introduction to Web Applications and Java EE2 lectures • 1hr 6min

Java Servlets5 lectures • 2hr 40min

JavaServer Pages8 lectures • 4hr 56min

JavaServer Pages Standard Tag Library (JSTL)2 lectures • 1hr 1min

AJAX2 lectures • 1hr 5min

Miscellaneous Topics3 lectures • 59min

Examination0

Requirements

Description

Who this course is for: