Simple Spring Hibernate Application Using Annotations

In this project i have integrate Spring with Hibernate using annotation based configuration. I have developed a simple CRUD oriented web application containing a form asking user input, saving that input in MySQL database using Hibernate, retrieving the records from database and updating or deleting them within transaction, all using annotation configuration.

Testing I have added unit and integration test using TestNG, mockito, spring-test, DBUnit & H2 database

Following technologies being used

• Spring 4.0.6.RELEASE
• Hibernate Core 4.3.6.Final
• Validation-api 1.1.0.Final
• Hibernate-validator 5.1.3.Final
• MySQL Server 5.6
• Maven 3
• JDK 1.8
• Tomcat 9.0.0.M21
• Eclipse JUNO Service Release 2
• TestNG 6.9.4
• Mockito 1.10.19
• DBUnit 2.2
• H2 Database 1.4.187

Following is the final project structure

Create Schema in database

 CREATE TABLE EMPLOYEE(
    id INT NOT NULL auto_increment, 
    name VARCHAR(50) NOT NULL,
    joining_date DATE NOT NULL,
    salary DOUBLE NOT NULL,
    ssn VARCHAR(30) NOT NULL UNIQUE,
    PRIMARY KEY (id)
);