hibernate-basic
hibernate-101, basic coding function like CRUD operation with details steps. The Purpose of this project is to understand hibernate with simple and live example.
Feature:
This is basic Java Hibernate project where we have used a table called Student. and we enter and manupulate DB table data by using this code.
Steps to Configure Project:
- Open folder "starter_db_files/"
- Open your MySql Workbench
- open sql file "starter_db_files/01-create-user.sql", to create new user account. If you wish to use your own credentials then you need to change in code.
- Open "starter_db_files/02-student-tracker.sql", this will create Student Table.
- Next Open Eclipse IDE installed in your system.
- Import the Project in to you system.
- Need to add Lib jar into classpath, those Jar files are provided under following folder: "lib".
- Now right click on project root in Eclipse, and go to properties.
- Select "Java Build Path" and the select tab "Libraries"
- Click on "Add JARs..." button and got to project based "lib" folder and select the all the jar files and add., 'Apply and Close'
- Run the project
Explore Project:
All the application are avaiable under package named "crudops".
CRUD ops details :
- CreateStudentsForPrimarykeyDemo.java --> For Create Operation
- DeleteStudent.java --> For Delete Operation
- GetStudent.java --> For Read Operation
- UpdateStudent.java --> For Update Operation
- UpdateBulkStudent.java --> For Bulk Update Operations using Custom Query object
- HBQueryingStudentDemo.java --> Example of using Custom Query Object
Add on feature:
We have added a bonus part. for table Student data manipulation and How to handle SQL Date format using hibenate Code.
Bonus Application :
CreateStudent.java --> This Application will handle SQL Date format as Student DOB.
Note: Note: But to be noted our current student table we have created using "starter_db_files/02-student-tracker.sql" doesn't contain DOB attribute for Student table. Thus we need to import another sql file provide to alter the same table. "starter_db_files/add_DOB_user.sql.sql" .
Only after importing this file run the Application CreateStudent else it'll give you a error.
Bonus:
Our project we have used SQL Auto-increment feature to generate id. but there are 2 questions every programmer ask everytime he used this feature.
- How do I change the auto increment values to any value? 2.How to clean out my database and I want to start the auto increments from 1?
Both of thease question answer can be find under following:
starter_db_files/autoIncrementValueChangeCommand.txt
Creators
Anirban Maiti: