EmployeeRegister

A Employee Register written in Java as part of our course in Java Enterprise Edition (JavaEE). This project is intended to (as the name suggests) manage Employees and any relevant data attached to it. The main purpose of this project is to create a connection between a client and Servlets to manage Java Beans with the help of Hibernate(ORM).

Getting Started

These instructions will get you a copy of the project up and running on your local machine for development and testing purposes.

Prerequisites

• Java 8
• Maven 3
• Eclipse Enterprise Edition (Oxygen) (if you use another IDE it's alright but the experience may differ)
• XAMPP (7.1.12) (or any other program/method for managing a SQL database)
• TomEE-Plus (v7.0.2) (or any other Application Servers with the support of EE)

Installation & Setup

1. Before you begin we have to make sure that:

   • your system is running Java 7 or higher. For information regarding the installation of Java, go here.
   • you have Maven 3 installed. Maven Installation Guide
   • you have a working installation of Eclipse Enterprise Edition. Download Eclipse
   • XAMPP is installed and that the SQL database is created based on this script.
   • TomEE-Plus is downloaded to a folder of your choosing. Link
   • this repository is cloned to a local folder on you computer (How-To) and then to be imported into Eclipse Workspace as a "General Project".

2. Seeing as you now got everything up and running it's time to setup TomEE-Plus as well as the project itself. In Eclipse, do as follows:

   • In the navigation-bar up top Select "File" -> "New" -> "Other" -> Search for "Server" in the searchbar and then "next". -> Select "Apache" and scroll down till you see "Tomcat v8.5 Server" -> "Add..." select the location where you downloaded and unpackaged the "TomEE-Plus" folder and press "Finish".
   • Right-click on your Eclipse Project and select "Properties" -> "Project Facets" and check "Dynamic web Module" in order to make this project into a Dynamic Web Project.
   • Right-click your project again and locate "Configure" and "Convert to Maven Project".

3. Now, all you need to do is to:

   • Right-click on "QuickPasswordEncodingGenerator" Class in "src\main\java\com\jensen\employeeregister\util" and "Run as" -> "Java Application" and then grab the encoded password and insert it into your 'password' column in TABLE 'users' in your SQL DB.
   • Now right-click on the project again and select "Run as" -> "Run on Server" and select your Tomcat v.8.5 Server.

4. That's it! Visit: http://www.localhost:8080/EmployeeRegister/ to interact with the application.

SQL Script

Database: company

CREATE DATABASE 'company';

Select 'company'

USE 'company';

Tablestructure employees

CREATE TABLE `employees` (
  `employee_id` int(11) NOT NULL,
  `fname` varchar(32) NOT NULL,
  `lname` varchar(32) NOT NULL,
  `location` varchar(32) NOT NULL,
  `role` varchar(32) NOT NULL,
  `registration_date` date NOT NULL
);

Mock-Data to table employees

INSERT INTO `employees` (`employee_id`, `fname`, `lname`, `location`, `role`, `registration_date`) VALUES
(1, 'John', 'Doe', 'New Doeland', 'Master of John', '1888-01-01'),
(2, 'Jane', 'Doe', 'The Other Doeland', 'Master of Jane', '1812-12-21'),
(3, 'Aaron', 'Talker', 'Somewhere', 'Retired Salesman', '2017-12-11');

Trigger employees

DELIMITER $$
CREATE TRIGGER `generate_reg_date` BEFORE INSERT ON `employees` FOR EACH ROW BEGIN
    SET NEW.registration_date = NOW();
END
$$
DELIMITER ;

Tablestructure users

CREATE TABLE `users` (
  `user_id` int(11) NOT NULL,
  `username` varchar(32) NOT NULL,
  `password` varchar(64) NOT NULL
);

Mock-Data to table users (NOTE: Change the 'password' column value to the generated PasswordEncoded password from the Util-Package included in this project)

INSERT INTO `users` (`user_id`, `username`, `password`) VALUES
(1, 'username', 'changetoencodedpasswordviautilityclassandplaceithere');

Index for table employees

ALTER TABLE `employees`
  ADD PRIMARY KEY (`employee_id`);

Index for table users

ALTER TABLE `users`
  ADD PRIMARY KEY (`user_id`),
  ADD UNIQUE KEY `username` (`username`);

AUTO_INCREMENT for table employees

ALTER TABLE `employees`
  MODIFY `employee_id` int(11) NOT NULL AUTO_INCREMENT;

AUTO_INCREMENT for table users

ALTER TABLE `users`
  MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT;

Built With

• TomEE-Plus - An embedded/remote EE Application Server.
• Thymeleaf - Server-side Java template engine.
• Maven - Dependency Management.
• Spring 4 (MVC, Security & ORM) - Framework for modern Java-based enterprise applications.

Authors

• Gustav Malm - Programmer | GitHub
• Kami Hassanzadeh - Programmer | GitHub

See also the list of contributors who participated in this project.

Acknowledgements

• ConcretePage - For helping us to see and understand the overall picture of Enterprise Edition Services.
• Baeldung - For giving us a better understanding of Spring Security and the power of Spring overall.
• JournalDev - Helped us grasp how to implement our Hibernate-installation from an earlier project into Spring 4 MVC.