Practical task

Employee CRUD App

Project description:

Simple web application, that realizes an employee database with "CRUD" operations. The application has the next architecture:

The technologies are used in the app:

• Backend part ("Main app"):
  • Java 8;
  • Spring Boot (WEB, JDBC, TEST Starters)
  • Tomcat 9 embedded (as a servlet container)
• Frontend part ("UI"):
  • HTML (a bit);
  • Javascript (JQuery, AJAX) (for the DOM manipulating and requests to the backend part).
• Database ("DB"):
  • PostgreSQL ("production");
  • H2 in embedded mode (tests).
• Build tool:
  • Maven

Launch instructions:

1. The first step is to set up PostgreSQL database:
   • Database schema should be created according to this script;
   • Optional: you can fill up db by this filler script;
   • The configuration for the database is located under "src/main/resources/db.properties" path.
2. Launch application by "mvn tomcat7:run" (maven plugin) command in the source directory.

Visual part of the application (Screenshots)

1. Root view:
   
2. Find by id section:
3. See all section:
   
4. Add new section:
   

Optional: also available operations upon employees (REST API):

• GET /employees (return all available employees from the database);
• GET /employees/{id} (return employee by ID);
• POST /employees (saves a new employee, object transfers in the request body as JSON);
• PUT /employees/{id} (updates an existed employee by ID, object transfers in the request body as JSON);
• DELETE /employees/{id} (deletes an employee by ID)/