Hibernate SQL Query/Native Query
This tutorial describes Hibernate SQL Query, which is also known as Native Query.
Hibernate SQL native Query:
Hibernate facilitates to use SQL queries in your application. It is called
native queries in Hibernate.
It is written like normal query and provide database specific features.
For native query you can use createSQLQuery() method on the Session interface.
public SQLQuery createSQLQuery(String sqlString) throws HibernateException
Hibernate Native Query Example :
Now we are going to describe a simple select native query example. Let employee is our table and we are selecting all emp id ,name and salary.
package net.roseindia.main;
import net.roseindia.util.HibernateUtil;
import java.util.*;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
public class HibernateNativeSQL {
public static void main(String[] args) {
SessionFactory sessionFactory = HibernateUtil.getSessionFactory();
Session session = sessionFactory.openSession();
String sql = "Select * FROM employee";
Query query = session.createSQLQuery(sql);
List<Object> objectList = query.list();
Iterator iterator = objectList.iterator();
System.out.println("Emp Id\t Name\tSalary");
while(iterator.hasNext()){
Object []obj = (Object[])iterator.next();
System.out.print(obj[0]);
System.out.print("\t"+obj[1]);
System.out.print("\t"+obj[2]);
System.out.println();
}
}
}
Output:
Hibernate: Select * FROM employee Emp Id Name Salary 1 Mandy 20000 2 Som 20000 3 Mac 15000 4 Roxi 220000 14 Rowdy 20000