/JEE2

JEE Project Version 2

Primary LanguageJava

JEE Project

By
Guillaume Billès | Guillaume Farge | Morgan Wolf | Vincent Roche | Claire Huang

Application features

Login Page

  • Connection of a user
  • Error message if incorrect login or password
  • Error if login or password not entered

The default login : admin | password : admin

Employees List Page

  1. A click on Delete will remove the selected member from the database and will reload the updated list of employees
  2. A selection of one member and a click on Details will send the user to the Member details page
  3. A click on Add will redirect the user to an empty Member details page
  4. If you delete all the members the following message is displayed (in blue & bold) : The club has no member!

Employees Details Page

  1. A click on Save will update the information about the current member and will redirect to the list page
  2. A click on Cancel will redirect to the list page without updating information about the current member

General functionalities
On the upper right of each page (except the login page obviously) show:

  1. "Your session is active"
  2. The icon that allows the user to logout (leave the session)

  1. Good bye page
  2. Constants are in the utils folder, in the file Constants.java
  3. Our database if configured as
    Base : PROJET
    User : adm
    Password : adm
  1. We have a script with 10 employees

How to launch Version 1?

After cloning the project from this address : https://github.com/VincentRoche/JEE.git
Step 1 : Create a JavaDB database (name=PROJET, username=adm, password=adm)
Step 2 : Fill the database by executing sqlScript.sql (https://github.com/VincentRoche/JEE/blob/master/web/WEB-INF/sqlScript.sql)
Step 2 : Clean and build the project
Step 3 : Run the project

Features

In this version, you have the following features:
o JSP (scriptlets accepted) + Java Beans + Servlet + JDBC
o db.properties file to store information about the database
o SQL script in /WEB-INF
o All the JSPs in /WEB-INF
o SGBD = Java DB

Jsp, java beans, servlet, jdbc

Jsp are located in the web/WEB-INF folder
Java beans are located in the jee/model folder
In this version, the database used is JavaDB from NetBeans

db.properties

db.properties file is located in the src/java/utils folder

Version 2 (this one)

How to launch Version 2?

After cloning the project from this address : https://github.com/ClaireH97/JEE2.git
Step 1 : create a MySQL database named "PROJET"
Step 2 : create an user "adm" with password "adm" (if you want to use different credentials, edit WEB-INF/glassfish-resources.xml)
Step 3 : execute the SQL script to fill the database (https://github.com/ClaireH97/JEE2/blob/master/MavenPROJECT/src/main/webapp/WEB-INF/mysqlScript.sql)
Step 4 : Clean and build the project
Step 5 : Run the project

Features

In this version, you have the following features:
o Maven project
o JSP (EL et JSTL only / no Java code in JSPs)
o Java Beans
o Servlet
o Persistance with JPA
o SGBD : MySQL
o Continuous delivery pipeline with Jenkins using that version

Maven project :

This project has been created as a Maven Project in order to have a build automation.
Maven project is a little bit different compared to a webApplication.
Indeed, here, we can see how the software is built and all its dependencies (in Pom.xml).

JSP, java server pages

In order to give access to the user to the different contents of our web application, all the pages are .jsp are presented in the WEB-INF folder.

JavaBeans

In order to respect the MVC model, you can find our javaBeans in the source package, folder : group2jee.projet2.jee.model

Servlet

Those servlet, will help us to treat the request and redirect the client through the different JSP

Persistance with JPA

You can find our Persistance file at this path : src/main/resources/META-INF
This Persistance file will be used by EmployeesSessionBean.java

SGBD : MySQL

In order to use the MySQL Connection, please follow steps 1 and 2 above.
If you check your Glassfish-ressources.xml, you will see the new jdbc connection pool that we have created in order to connect this maven project to MySQL (all params are here).

Continuous delivery pipeline with Jenkins

Please follow the different steps presented in the file "How to create the pipeline.pdf" (https://github.com/ClaireH97/JEE2/blob/master/How%20to%20create%20the%20pipeline.pdf)