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