Hibernate is a Object relational mapping framework. What it will help us is in saving the objects into the relational world.
Employee.java
public class Employee {
private String Name;
private int Emp_Id;
private String Designation;
private String Reportee;
private int Access_Carad_No;
public String getName() {
return Name;
}
public void setName(String name) {
Name = name;
}
public int getEmp_Id() {
return Emp_Id;
}
public void setEmp_Id(int emp_Id) {
Emp_Id = emp_Id;
}
public String getDesignation() {
return Designation;
}
public void setDesignation(String designation) {
Designation = designation;
}
public String getReportee() {
return Reportee;
}
public void setReportee(String reportee) {
Reportee = reportee;
}
public int getAccess_Carad_No() {
return Access_Carad_No;
}
public void setAccess_Carad_No(int access_Carad_No) {
Access_Carad_No = access_Carad_No;
}
}
Now we have the domain class definition with us. Now we will put a mapping file which will map this class to the data model in the database. We are not creating the table in the database as we will use hibernate to generate the data model. Though in real life application you would have your data model already created and placed in the database.
Employee.hbm.xml
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="Employee.java" table="Employee" schema="hiberpract">
<id name="Emp_Id" column="EMP_ID">
<generator class="increment"></generator>
</id>
<property name="Name" column="NAME"></property>
<property name="Designation" column="DESIGNATION"></property>
<property name="Reportee" column="REPORTEE"></property>
<property name="Access_Carad_No" column="ACCCESS_CARD_NO"></property>
</class>
</hibernate-mapping>
Now we will provide hibernate the details to connect to the database. Similar to JDBC coding, the connection details and drivers need to be provided to Hibernate. This is done in a XML file
Hibernate.cfg.xml
<?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>
<!-- Database connection settings -->
<property name="connection.driver_class">com.mysql.jdbc.Driver </property>
<property name="connection.url">jdbc:mysql://localhost:3306/Hiberpract </property>
<property name="connection.username">root</property>
<property name="connection.password">root</property>
<!-- JDBC connection pool (use the built-in) -->
<property name="connection.pool_size">1
</property>
<!-- SQL dialect - This tells the SQL grammer to be used -->
<property name="dialect">org.hibernate.dialect.HSQLDialect
</property>
<!-- Enable Hibernate's automatic session context management -->
<property name="current_session_context_class">thread</property>
<!-- Disable the second-level cache -->
<property name="cache.provider_class">org.hibernate.cache.NoCacheProvider
</property>
<!-- Log out all the sql that hibernate is issuing to datbase.
This is very useful for debugging -->
<property name="show_sql">true</property>
<!-- Create the table looking at class and mapping. Very useful in development
Use validate in production environments. -->
<property name="hbm2ddl.auto">create</property>
<property name="format_sql">true</property>
<!-- Mapping file. -->
<mapping resource="Employee.hbm.xml"/>
</session-factory>
</hibernate-configuration>
Now we will write a utility class which will start the session factory of hibernate, if it is not started and will return the Session factory. This is the most used pattern of boot strapping Hibernate. Session factory contains all the configuration information at runtime. A Session is retrieve from the Session factory. A session is a light weight object which provide services to interact with database. You can think of Session like JDBC connection, thought it may not open the database connection if not required.
HiberUtil.java:
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
public class HiberUtil
{
private static SessionFactory sessionFactory;
static{
try{
//By default it will look for hibernate.cfg.xml in the class path
sessionFactory=new Configuration().configure().buildSessionFactory();
}catch(Throwable ex){
throw new ExceptionInInitializerError(ex);
}
}
public static SessionFactory getSessionFactory(){
return sessionFactory;
}
public static void shutdown(){
//Close caches and connection pool
getSessionFactory().close();
}
}
Now Let's create the base class having main method..
HiberBase.java
import org.hibernate.Session;
import org.hibernate.Transaction;
public class HiberBase {
public static void main(String[] args) {
//Get the session from the Session factory
Session session = HiberUtil.getSessionFactory().openSession();
Transaction tx= session.beginTransaction();
Employee Emp = new Employee();
Emp.setName("Utkarsh");
session.save(Emp);
//System.out.println(studentId);
tx.commit();
session.close();
}
}
In the above example we saw how to configure hibernate using XML mapping.