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
264
33
TAKE THIS COURSE