Java hibernate select multiple rows from a table and assign the result in a list

Question

I want to select multiple rows/records from a table, and then put the result into a "variable". Then I want to print each row's content.

If I use hibernate with Java, how can I do that?

For example, I have a student table and I want to get all the rows of the tables. I know each row is an instance of the table/entity class/bean. (assume I have an entity class-student )

The table is like (assume I have a table in database with data):

table name: sutdent

with four colums

id, lname, fname, sex

I remember I can do something like:

List<student> stlist=HibernateUtil.getSession().createQuery("select*from student").list();

//here I want to print the lname of the first row/object
System.out.println(stlist.get(0).getLname(););

Why I get error with message "unexpectesd token * " ?

I cannot use * ? if I cannot use *, if I want to get everything (all the attributes/columns) of a record, what can I do?

or is there any other error? what I should do? Thanks!!

Don't use * in production code. Also, you shouldn't make any assumption about the order of columns in the result set when using *. — dschulz
– dschulz, Commented Mar 12, 2013 at 3:26
While using hibernate better to use Student object for fetching recoreds.if u use raw SQL u need to typecast fields in the student object. — swamy
– swamy, Commented Mar 12, 2013 at 5:36

MRX · Accepted Answer · 2013-03-12 03:44:51Z

7

You can do it by two ways.

1. HQL query
2. SQL query

1. HQL Query

- you are using hibernate that means you have done mapping to Student table and Student class.
 you just need to change following line.

List<student> stlist=HibernateUtil.getSession().createQuery("from student").list();

and you will get all records from Student table.

2. SQL Query

- you can do by providing SQL query

     List<Object> stlist=HibernateUtil.getSession().createSQLQuery("select * from student").list();

you will get all records as Object so you need to manually cast to Student.

answered Mar 12, 2013 at 3:44

MRX

1,6518 gold badges33 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rahul · Accepted Answer · 2013-03-12 03:41:28Z

5

In HQL, this is how you write a query to get the list of all objects:-

List<student> stlist = HibernateUtil.getSession().createQuery("select s from student s").list();

or even this is allowed, if you want to fetch all the columns.

List<student> stlist = HibernateUtil.getSession().createQuery("from student s").list();

answered Mar 12, 2013 at 3:41

Rahul

45.2k11 gold badges89 silver badges108 bronze badges

Comments

Ren · Accepted Answer · 2013-04-22 11:17:40Z

0

In above so many examples are placed. That are some correct just simply you can follow this one. I think this one is good for your requirement.

First you can open the session:

Session session = HibernateUtil.getSessionFactory().openSession();

If you already opened session in util, you can follow this one:

Session session = HibernateUtil.getCurrentSession();

If you want to fetch the records from a database table try this simple query:

List<Object> slist = session.createQuery("from Student").list();

Here Hibernate Query Language (HQL) removes the burden on the programmer. No need to write the entire query here.

Here you can remember one thing. The first letter of the table name must be a capital letter otherwise sometimes an exception will be raised.

edited Apr 22, 2013 at 11:17

Ren

1,1095 gold badges15 silver badges24 bronze badges

answered Apr 22, 2013 at 10:57

SubbaReddy

294 bronze badges

Collectives™ on Stack Overflow

Java hibernate select multiple rows from a table and assign the result in a list

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related