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);
System.out.println(student);
}
}
| Previous | Home | Next |