Hibernate Query with AND condition

[Rohit Kumar]

Hi,

New to Hiebrnate..


I have normal sql query like...

select * from emplyee where emp_id='1' and emp_name='2'

I want to oass both values of emp_id and emp_name as parameters.Could you help me this..

Thanks,
livefree

[Jaikiran Pai]

"live free"

Welcome to JavaRanch

Please check your private message, for a message from JavaRanch.

[Jaikiran Pai]

Originally posted by live free:
I have normal sql query like...

select * from emplyee where emp_id='1' and emp_name='2'

I want to oass both values of emp_id and emp_name as parameters.Could you help me this..

It would be something like:

//get the hibernate session
Session sess = sessionFactory.openSession();
Query query = sess.createSQLQuery("SELECT * FROM emplyee WHERE emp_id=? and emp_name=?");
//set the parameter values
query.setString(0, "1");
query.setString(1,"2");
//fire the query and get the result
List result = query.list();
 

Also, have a look at Chapter-16 Native SQL in Hibernate.

Originally posted by live free:
Hi,

New to Hiebrnate..

This will get you started.