SpringMVCHibernateMSSQL

This project is a n-tier web application that demonstrates the CRUD operations using Spring MVC, Hibernate and MSSQL.

Requirements

• Java 8
• MSSQL
• Hibernate 5.4
• Spring Web MVC 5.1.6
• mssql-jdbc
• jinq
• javafaker
• Bootstrap 4

Getting Started

1. Clone or download the project

2. Create MsSql database

CREATE DATABASE SpringMvcHibernateTest;

• Through Hibernate, tables will be automatically generated according to entity classes.

• While the project is first opened, fake data is produced with javafaker and sample data is added to the database.

3. Import the project as a maven project.

4. Change mssql username, password and servername as per your installation

• open src/main/resources/META-INF/persistence.xml

• change jdbc:sqlserver, javax.persistence.jdbc.user and javax.persistence.jdbc.password as per your mssql installation

5. Build and run the app project

Demo