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) );