Java Servlet, JSP and Hibernate: Build eCommerce Website

Understand requirements from the customer: why do they need a website? What do they want their customers to do on the website? What kind of information needs to be managed? 

Use UML use case diagrams to represent user's requirements.

Understand the requirements for user interface of the website that sells books online, via mockup design.

Understand how the database is designed via entity relationship diagram (ERD).

Understand system architecture for the website, application architecture, Java package organization and getting familiar with class diagram, activity diagram and sequence diagram.

Understand the name conventions used in the project: Java code, Java class name, JSP file name, and URL mapping names.

Install Java Development Kit (JDK) and configure JAVA_HOME environment variable.

Install Eclipse IDE for Java EE Developers

Install Apache Tomcat web server (a Java servlet container)

Install MySQL Community Server and MySQL Workbench tool

Create the first table in the database using MySQL Command Line Client program.

Create the second table in the database by executing SQL script in MySQL Workbench program.

Modify the table users using MySQL Workbench

Create the remaining tables using visual design function of MySQL Workbench

Create Java project in Eclipse IDE.

Configure dependencies for Hibernate ORM, MySQL JDBC driver, Java Servlet API, JSP and JSTL.

Create main Java packages and directories for web content.

Configure Apache Tomcat in Eclipse and start the server to make sure it is working.

Get started with Hibernate framework and Java Persistence API (JPA)

Code the first model class manually using JPA annotations.

Create the persistence.xml file and specify database connection properties and persistence unit name.

Code the first test program to insert data into table users with Hibernate/JPA

You will be able to use Hibernate Reverse Engineering tool in Eclipse to generate code for the domain model classes. This will save a lot of time.

Understand the design of DAO classes for the project

Understand the basic concepts in JUnit testing framework

Code the first test class using JUnit - UserDAOTest to test methods of the UserDAO class

Start coding the home page of the website's front-end using JSP and Java Servlet. Header and footer are also created.

Start coding the home page for the website's back-end (admin) using JSP (index.jsp) and Servlet (AdminHomeServlet). Header and footer are also created.

Understand the requirement of the users management module through use case diagrams and mockup design, and understand the implementation through database design and class diagrams.

Update the UserDAO class for the get() and delete() method. Also write unit test methods in the UserDAOTest class.

Understand how to execute a query with JPA and how to write a named query.

Update the UserDAO class for the listAll() and count() method using named query with JPA. Unit test methods also need to be written to test.

Code the list users feature that displays all users from the database. Use JSP and JSTL for the view layer, Java Servlet for the controller layer, UserServices for the service layer and UserDAO for the data access layer.

Understand the create user feature with mockup design, activity diagram (flowchart), and sequence diagrams. You will understand how to implement the create user feature.

Code the JSP page that displays the form to allow the managers to create a new user. Form validation in Javascript.

Write code in the controller layer (Java Servlet) to handle form submission to create a new user, and code the UserServices class for business logic.

Refactor code in the UserServices class to remove redundant code.

Code the findByEmail() method in UserDAO class, that finds a user by email address, using named query with JPA. JUnit test methods are also created.

Code a JSP page to display specific messages to the end users. Test it with the create user feature.

Understand how to implement the edit user feature with mockup design, activity diagram (flowchart) and sequence diagram.

Code a Java Servlet to display the edit user form, using JSP and HTML to display the form.

Code a Java servlet class to handle the request update the user's details and update the UserServices class to implement the business logic, including the call the data access layer to persist the user's details into database.

Understand how to implement the delete user feature with mockup design, activity diagram (flowchart) and sequence diagram. Write code for a Java servlet class to handle request to delete a user and update the UserServices class accordingly.

Understand what needs to do for the category management via use case diagrams and mockup screens, and understand how to implement the features via database design, activity diagram (flowchart), and class diagram.

Code the basic CRUD methods for the CategoryDAO class, and test them with unit test methods.

Understand the requirement and design of the list category feature. Code a Java servlet to handle request to list categories. Code the CategoryServices class to do the business logic, and calls the CategoryDAO class to use Hibernate/JPA to query a list of categories from the database. And finally code a JSP page to display all categories.

Understand the requirement and design of the create category feature.

Code a JSP page to display the new category form with form validation using Javascript.

Code a Java Servlet to handle request to save a new category.

Update the CategoryServices class to call the CategoryDAO to persist the Category object into the database with the help of Hibernate/JPA.

Understand requirement and technical design (UML) for the edit category feature.

Code a Java servlet to get a category from the database.

Update the category form JSP to display the details of the category in edit mode.

Code a Java Servlet to handle the request to update the category.

Update the CategoryServices class to call CategoryDAO to persist the change to the database, thanks to Hibernate and JPA.

Understand requirement and design for the delete category feature, via UML diagrams.

Show delete confirmation dialog using Javascript.

Code a Java Servlet to handle the request to remove a category.

Update the CategoryServices class to invoke CategoryDAO class to remove the selected category from the database, thanks to Hibernate and JPA.

Update the website's home page to display the category names as menu items (book categories).

Update the HomeServlet class to get a list of categories.

Update the header JSP to display categories in menu.

Start using CSS for the website. Add icon images for menu items in the admin.

Specify some rules for hyperlinks, headings, table, form fields, buttons, text.

Update JSP files to use CSS.

Start using jQuery for the project to reduce plain Javascript. Replace Javascript code that validates form input by jQuery validation code.

Review checklist, requirement and workflow for the login/logout features for admin users.

Code the login page for the admin users using JSP, HTML, Javascript and CSS.

Code the checkLogin() method in the UserDAO class using named query in JPA. JUnit tests are also used.

Code the login function on the server side: Write a Java servlet to handle login request and update the UserServices class to use HttpSession to store login status.

Code the logout function for the admin users using Java Servlet and HttpSession.

Code a Java filter servlet to intercept requests in order to require authentication for all features in the back-end.

Understand the need for handling exceptions for the website application to display more user-friendly error messages to the end users.

Understand the 3 ways of handling exceptions for a Java web application.

Code a JSP page that displays a friendly message for HTTP 404 error, also configure exception mapping in the web.xml file.

Code a JSP page that displays a friendly message for HTTP 500 error, also configure exception mapping in the web.xml file.

Understand requirement for the book management module via use case diagram and mockup user interface design.

Understand implementation via database design and class diagram.

Code the create() method of the BookDAO class to persist a Book object into the database. And thanks to Hibernate and JPA that make the code simple. JUnit test is also used.

Code the update() method in the BookDAO class to persist changes made to a Book object. Hibernate and JPA make the code simple. Use JUnit test as well.

Code the delete() method in the BookDAO class to remove a Book object from the database. The code is simple with Hibernate/JPA. Test using JUnit.

Code the get() method in the BookDAO class to retrieve details of a book from the database. Hibernate and JPA make the code simple.

Code the listAll() method in the BookDAO class to list all Books from the database using JPA named query and Hibernate implementation. Test using JUnit methods.

Code the findByTitle() method in the BookDAO class to get the details of a book by its title, using named query in JPA/Hibernate. JUnit test methods are used as well.

Code the count() method in the BookDAO class to count the total number of books, using JPA named query and Hibernate implementation. Test using JUnit methods.