Hibernate CRUD operations with example

Read this article to know what is CRUD and how to do CRUD operations in hibernate with example. CRUD stands for Create, Read, Update and Delete. As part of hibernate learning CRUD operations are the most basic operations. In previous examples, I have explained by using the MySQL configuration in Hibernate. But, in the current example, I am explaining by using Oracle as well as MySQL configuration. The choice is yours, use at your convenience.

As of you people already know if we have to change the Database vendors no need to rewrite the entire code, it’s just a configuration file change. So, except the hibernate.cfg.xml file remaining all files logic will be common for both of the databases like Oracle or MySQL.

Before going to write the hibernate logic, we have small work with the databases either Oracle or MySQL. Execute the below query to create the table in the database. Before going to execute the below query make sure you have connected with the specific Schema in the database.

CREATE TABLE USER_HIBERNATE(
USER_ID NUMBER,
FIRST_NAME VARCHAR(20),
LAST_NAME VARCHAR(20),
EMAIL VARCHAR(50),
ORGANIZATION VARCHAR(30));

Here, I have taken a User with the properties of user_id, first_name, last_name, email and organization. Below is the User POJO class with getter and setter methods.

User.java:
package com.jtb.sample;


import java.io.Serializable;

public class User implements Serializable {
 private static final long serialVersionUID = 6143302925040278901L;
 private int user_id;
 private String first_name;
 private String last_name;
 private String email;
 private String organization;

 public int getUser_id() {
  return user_id;
 }

 public void setUser_id(Integer user_id) {
  this.user_id = user_id;
 }

 public String getFirst_name() {
  return first_name;
 }

 public void setFirst_name(String first_name) {
  this.first_name = first_name;
 }

 public String getLast_name() {
  return last_name;
 }

 public void setLast_name(String last_name) {
  this.last_name = last_name;
 }

 public String getEmail() {
  return email;
 }

 public void setEmail(String email) {
  this.email = email;
 }

 public String getOrganization() {
  return organization;
 }

 public void setOrganization(String organization) {
  this.organization = organization;
 }

 public User(int user_id, String first_name, String last_name, String email,
   String organization) {
  super();
  this.user_id = user_id;
  this.first_name = first_name;
  this.last_name = last_name;
  this.email = email;
  this.organization = organization;
 }

 public User() {

 }

}

User.hbm.xml:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
 <class name="com.jtb.sample.User" table="USER_HIBERNATE">
  <id name="user_id" type="int">
   <column name="user_id" />
   <generator class="assigned" />
  </id>
  <property name="first_name" type="string">
   <column name="first_name" length="20" not-null="true" />
  </property>
  <property name="last_name" type="string">
   <column name="last_name" length="20" not-null="false" />
  </property>
  <property name="email" type="string">
   <column name="email" length="50" not-null="true" />
  </property>
  <property name="organization" type="string">
   <column name="organization" length="30" not-null="true" />
  </property>
 </class>
</hibernate-mapping>

This hbm file will contain all the properties which are matching with the java properties as well as Database table columns. <id> tag specifies that is the primary key column of the table. <generator> tag will specify that the primary key column value as manually assigned or system will take care of by declaring the type as increment,…, etc.

HibernateUtil.java:
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;

public class HibernateUtil {

 private static final SessionFactory sessionFactory = buildSessionFactory();

 private static SessionFactory buildSessionFactory() {
  try {
   return new Configuration().configure().buildSessionFactory();
  } catch (Throwable ex) {
   System.err.println("SessionFactory creation failed." + ex);
   throw new ExceptionInInitializerError(ex);
  }
 }

 public static SessionFactory getSessionFactory() {
  return sessionFactory;
 }

 public static void shutdown() {
  getSessionFactory().close();
 }

}

HibernateUtil the file will help us to build and return SessionFactory by using the buildSessionFactory() method from Configuration class.

Hibernate.cfg.xml: 
This file will contain the logic to configure with the databases by reading hibernate properties values. Here, I declare two different logics that will support the Oracle as well as MySQL databases.

For Oracle Database Configuration: 
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
 <session-factory>
  <property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
  <property name="hibernate.connection.url">jdbc:oracle:thin:@ localhost:1521:XE</property>
  <property name="hibernate.connection.username">jtb</property>
  <property name="hibernate.connection.password">jtb</property>
  <property name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</property>
  <property name="hibernate.default_schema">JTB</property>
  <property name="show_sql">true</property>
  <property name="hibernate.hbm2ddl.auto">update</property>
  <mapping resource="com/jtb/sample/User.hbm.xml"></mapping>
</session-factory>
</hibernate-configuration>

For MySQL Database Configuration: 
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
     <session-factory>
          <property name="hibernate.connection.driver_class"> com.mysql.jdbc.Driver </property>
          <property name="hibernate.connection.url"> jdbc:mysql://localhost:3306/JTB </property>
          <property name="hibernate.connection.username"> root </property>
          <property name="hibernate.connection.password"> root </property>
          <property name="hibernate.dialect"> org.hibernate.dialect.MySQLDialect</property>
          <property name="show_sql">true</property>
          <property name="hibernate.hbm2ddl.auto">update</property>

          <mapping resource= "com/jtb/sample/User.hbm.xml"
              package="com.jtb.sample.User" />
     </session-factory>
</hibernate-configuration>

Now, we have to write the logic for CRUD operations. First will see about the Create operation. Create us nothing but Insert. Will you see how to insert a record in a Database table by using hibernate?

CreateUser.java:
import org.hibernate.Session;

import com.jtb.sample.User;
import com.jtb.util.HibernateUtil;

public class CreateUser {

 public static void main(String[] args) {
  Session session = HibernateUtil.getSessionFactory().openSession();
  session.beginTransaction();
  
  User user = new User();
  user.setUser_id(123);
  user.setFirst_name("Subbaiah");
  user.setLast_name("Nallamachu");
  user.setEmail("admin@javatbrains.com");
  user.setOrganization("JavaTBrains");
  
  session.save(user);
  session.getTransaction().commit();
 }

}

The above CreateUser.java file contains the logic of inserting the record into the database. By using the save() method from the Session interface will save the record into the database. Until it executes the commit() method which is present in the Transaction interface the changes will not reflect in the database table.

 RetrieveUser.java:
import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.Session;

import com.jtb.sample.User;
import com.jtb.util.HibernateUtil;

public class RetrieveUser {

 public static void main(String[] args) {
  Session session = HibernateUtil.getSessionFactory().openSession();
  session.beginTransaction();
  Criteria ctr = session.createCriteria(User.class);
  List<User> userList = ctr.list();
  if (userList.size() > 0 && userList != null) {
   for (User user : userList) {
    System.out.println("User Id: " + user.getUser_id());
    System.out.println("Name: " + user.getFirst_name() + " "
      + user.getLast_name());
    System.out.println("Email: " + user.getEmail());
    System.out.println("Oraganization: " + user.getOrganization());
    if (userList.size() > 1) {
     System.out.println();
    }
   }
  }
 }
}

To retrieve the information from the database table by using hibernate we have a different set of ways like using Query, Criteria interfaces as well as get and load methods. Query and Criteria interface will use to fetch a bunch of records from a database table and get and load methods are using to fetch specific records from the table. If it doesn’t contain any records from the table it will not execute inside the IF() condition. So, it will not show any information on the console.

UpdateUser.java:
import org.hibernate.Session;

import com.jtb.sample.User;
import com.jtb.util.HibernateUtil;

public class UpdateUser {

 public static void main(String[] args) {
  Session session = HibernateUtil.getSessionFactory().openSession();
  session.beginTransaction();
  User user = (User) session.createQuery("from User").list().get(0);
  
  if(user!=null){
   user.setFirst_name("Subba Reddy");
   session.update(user);
   session.getTransaction().commit();
  }
 }
}

The above UpdateUser.java will contains the logic for updating the specific column in a database column. Before going to update the specific column in a record we need to fetch the specific record for that I have used here is HQL query. To update the record into the table I have used the update() method from the Session interface. Until we commit transaction the changes will not reflect into the database table.

 DeleteUser.java: 
import org.hibernate.Query;
import org.hibernate.Session;

import com.jtb.util.HibernateUtil;

public class DeleteUser {

 public static void main(String[] args) {
  Session session = HibernateUtil.getSessionFactory().openSession();
  session.beginTransaction();
  String qryStr = "delete USER_HIBERNATE where user_id=?";
  Query query = session.createSQLQuery(qryStr);
  query.setParameter(0, 123);
  int noOfRecords = query.executeUpdate();
  if(noOfRecords>0){
   System.out.println(noOfRecords+" record(s) deleted from table.");
  } 
  session.getTransaction().commit();
 }
}

Finally, we are into the situation to delete the record from the table. To achieve that I have used the normal SQL Query in hibernate.

In this CRUD example, I have covered most of the normal Session methods and HQL queries and normal SQL queries and using Query and Criteria interfaces. 

Location: Bengaluru, Karnataka 560017, India

Comments

Post a Comment

Popular posts from this blog

Hibernate auto increment with example

In previous example we learn how to map java object with database table for manually(not using auto increment) assigned all the values.  To create primary key auto increment application by using hibernate mapping(hbm.xml) or using annotations continue reading this article.  W e need to create a database and create an employee table by using the below query. Table: CREATE table EMPLOYEE( eid integer ( 10 ) primary key not null , firstname varchar ( 30 ), lastname varchar ( 30 ), designation varchar ( 30 ), salary double( 10 , 2 )); Here, we will create a bean/POJO (Plain Old Java Object) class of employee. Employee.java: package com . javatbrains . hibernate ; import java.io.Serializable ; /*This is the POJO class. It contains only Getter and Setter methods*/ public class Employee implements Serializable { private static final long serialVersionUID = - 75885815725314443L ; private int eid ; ...
Read more

how to count the page views by using JSP

To count no.of page's are viewed by user in your application is a challenge in real time application. In this page we will see how to count the page views when user has viewed the page.           Here, we will do one example how many times user has visited each page in our application. In this post we will come to know, how to count the total application page views as well as individually each pages count.           Let us assume my web application name is "Page Counter". For creating the web application in eclipse IDE, Click here . This Page Counter contains three pages, assume that are the different pages in an application. But, there is the link between each other files for navigating from one page to another. Also it will show the total pages view count and individual page view count in all the pages. Let us see, below is my first jsp file,         ...
Read more

Multithreading in java with example

Multithreading  is one of the most important concept in core java. In this article we will learn what is multithreading? , what is the use of it? and What is the use of Synchronization and when to use it?  with detailed examples. At a time, two or more threads are accessing the same object is called as Multithreading  in Java .  First, we will create two threads for two objects. It is also possible to run two or more threads on a single class object. In this case, there is a possibility to get unreliable results. If the two threads are perform same task, then they need same object to be executed each time. For your better understanding, take an example of any reservations like, railway, movie ticket booking,etc. Let us think only one berth is available in a train and two passengers are asking for that berth. The first person has sent a request to allocate that ticket/berth to him. At the same time, the second person also sent a request to allocate that ...
Read more

How to retrieve data from table by using JDBC with example

To retrieve data from mysql data table by using jdbc, we need to confirm weather which table data we need to retrieve. To confirm open your mysql and view all database names by using the ' show databases ' commands in mysql. Then select which is your database name from showing list of database names, by using the ' use <database name> ' command in mysql. Then we need to see all your existing tables by executing the ' show tables ' command. This command gives you the list of existing tables in your selected database. You need to use existing table only you can follow with that. But, here we will see with entirely new which is not existing in mysql database. Now, We will create simple mysql table with minimal columns. create table emp(eno integer(10), ename varchar(30), sal float); The above command creates a new table, we will move further to insert records into emp table by executing the insert which we mentioned in the below. ...
Read more

Prime, Fibonacci and Factorial number with example in java

Prime number, Fibonacci series and Factorial number programs are most commonly asked questions in interview. Read this article to know what is and how to write programs for prime number, fibonacci series and factorial number. Prime Number: prime number is natural number greater than 1 that has no positive divisor other than 1 and itself. A natural number greater than 1 is not a prime number, is called Composite number . For example, 7 is a prime number. Because it can divide with 1 and 7 only. Where as 8 is composite number. Since it has the divisor 2 and 4 in addition to the 1 and 8. The below example represents the finding the passing number is prime number or not. If the passing number is prime number it will print true otherwise it will print false. package com . javatbrains . practice ; public class PrimeNumber { public boolean isPrimeNumber ( int number ) { if ( number <= 1 ) return false ; // There's only one ...
Read more

How to insert images into database using JDBC?

How to insert images into database table by using JDBC? To know about these topic follow the below lines,           Before going to write a JDBC program for inserting images into database table, we need to create a specific table for inserting images column datatype. For creating the database table, execute the below command in MySQL command prompt. 1 2 3 4 CREATE TABLE ` images ` ( ` image_id ` int ( 11 ) NOT NULL AUTO_INCREMENT, ` image_flag ` int ( 11 ) NOT NULL , ` image ` longblob NOT NULL , PRIMARY KEY ( ` image_id ` ));           After executing the above query in MySQL command prompt, execute the below query to know weather the above table query is created or not. 1 Show tables;            When you have executed the above query that will show you the list of table which all exists in the current database. Current tab...
Read more

How to sort list of objects in java with examples

We could achieve list of objects sorting in java by using sort() method which is available under Collections class as well as by using Comparable and Comparator  interfaces. Comparable and Comparator are two interfaces in java used to sort list of objects. These interfaces are available under java.util package along with Collections  class and other classes and interfaces. Comparable interface contains the method of       public int compareTo(Object obj) Comparator interface contains the method of       public int compare(Object obj1, Object obj2) The compare() and compareTo() methods will return negative integer(-1), or zero(0) or positive integer(1). When the first obj1 is less than obj2 method will return negative integer. When obj1 is equals to obj2 will return zero and when obj1 is grater than obj2 it will return positive integer. If it's objects are stored in any Collection classes like ArrayList, H...
Read more

String interview questions and answers

String interview questions and answers are placed the current post as of my experience in interviews. This will helps who are trying to attend interview as fresher as well as experience. If any one is facing any other questions which are not present in the current page, please drop me an email to " subbareddynallamachu@gmail.com ".  Q1:  String is a class or data type? A: String is a class in java.lang package. But, in java, all classes are also are considered as data types. So we can take String as data type also. Q2:  What is the difference between == and equals() methods in java? A: == operator compares the references of the String object. It does not compare the content of the object. equals() method compares the contents. While comparing the Strings, equals method should be used as it yields the correct result. Q3:  What is String constant pool? A: String constant pool is a separate block of memory where the String objects are held by JVM....
Read more

Exception in thread "main" java.lang.NoClassDefFoundError: javax/transaction/SystemException

Exception in thread "main" java.lang.NoClassDefFoundError: javax/transaction/SystemException error we got in Hibernate 4.3 to work with my MySQL database. We are using hibernate code generation tool in Eclipse and we are able to connect to the database using the Hibernate configuration file. When we try to run code in my Main class application is connecting to the database, but transaction is failing and we got the following error: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 Exception in thread "main" java . lang . NoClassDefFoundError : javax / transaction / SystemException at java . lang . Class . forName0 ( Native Method ) at java . lang . Class . forName ( Unknown Source ) at org . jboss . logging . Logger . getMessageLogger ( Logger . java : 2248 ) at org . jboss . logging . Logger . getMessageLogger ( Logger . java : 2214 ) at org . hibernate . cfg . Configuration .< clinit >( Configuration . java : 184 ) at be . comp . permanenti...
Read more

Store file into table by using JDBC with example

To store large data files or text files into database table, we will use CLOB (Charecter Large Object) datatype of SQL . By using CLOB it is possible to save entire text book or a file or resume into a column of data table. If your using MySQL database instead of CLOB use LONGTEXT to save file into datatable. For saving files into a data table, we need to create one table which will contains a column type as CLOB to store files. Here, is the query to create a data table. 1 2 3 4 create table myfiles( file_id int ( 10 ), file_name varchar ( 30 ), file_type LONGTEXT); Once table creation completes, these table contains the 3 columns one is file_id represents the file id, file_name represents the name of the file and finally file_type will get save entire file into the table column. Now, we will move to write a JDBC program which will saves the file into the newly creating table. Here is the JDBC program, 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16...
Read more