Simple Program of Select Query
Previous Home Next

First of all we need to create a database and a table also. Because in the Hibernate we can't do anything without using Database.

          create database R4R;
          use database R4R;
          create table AddData
          id int not null primary key auto_increment,
          fname varhcar(50),
          lname varchar(50)

Now it code will be written into the java file for performing the action. Below given code is the simple example of the Hibernate.

import java.util.List;
import org.hibernate.Query;
import org.hibernate.Session;
import com.javacodegeeks.utils.HibernateUtil;

public class App
    public static void main( String[] args )
        Session session = HibernateUtil.getSessionFactory().openSession();
        Query query = session.createQuery("from AddData where id = :id ");
        query.setParameter("id", 5);
        // You can replace the above to commands with this one
        // Query query = session.createQuery("from Student where studentId = 1 ");
        List<?> list = query.list();
        Student student = (Student)list.get(0);

Previous Home Next