By
Guillaume Billès | Guillaume Farge | Morgan Wolf | Vincent Roche | Claire Huang
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
- A click on Delete will remove the selected member from the database and will reload the updated list of employees
- A selection of one member and a click on Details will send the user to the Member details page
- A click on Add will redirect the user to an empty Member details page
- If you delete all the members the following message is displayed (in blue & bold) : The club has no member!
Employees Details Page
- A click on Save will update the information about the current member and will redirect to the list page
- 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:
- "Your session is active"
- The icon that allows the user to logout (leave the session)
- Good bye page
- Constants are in the utils folder, in the file Constants.java
- Our database if configured as
Base : PROJET
User : adm
Password : adm
- We have a script with 10 employees
Version 1 (https://github.com/VincentRoche/JEE)
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 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 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 file is located in the src/java/utils folder
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 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
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).
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. In order to respect the MVC model, you can find our javaBeans in the source package, folder : group2jee.projet2.jee.model Those servlet, will help us to treat the request and redirect the client through the different JSP You can find our Persistance file at this path : src/main/resources/META-INF
This Persistance file will be used by EmployeesSessionBean.java
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). 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)