This is a simple backend repository made with java spring boot
-
Used Thymeleaf for view and still updating
-
Added excel export (checkout service layer for detailed info)
-
Added Spring Security
- Username : user
- Password: will be generated when your run the code , it will appear in terminal
-
Added AOP Logging support
-
For database example you can use this section :
CREATE DATABASE IF NOT EXISTS employee_directory
;
USE employee_directory
;
DROP TABLE IF EXISTS employee
;
CREATE TABLE employee
(
id
int NOT NULL AUTO_INCREMENT,
first_name
varchar(45) DEFAULT NULL,
last_name
varchar(45) DEFAULT NULL,
email
varchar(45) DEFAULT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
INSERT INTO employee
VALUES
(1,'Leslie','Andrews','example.com'),
(2,'Emma','Baumgarten','example.com'),
(3,'Avani','Gupta','example.com'),
(4,'Yuri','Petrov','example.com'),
(5,'Juan','Vega','example.com');
- Also don't forget to change database authorization in application.properties file (username,password etc.)