Need Help with selecting a value from DB

vyrav · **Joined:** Wed Jun 25, 2008 5:24 am **Posts:** 7

Hi All,

I tried to retrieve a value from DB using session.get(), but in session.get we can pass only the id of the table and we can retrieve according to table's id, but in my case i want to retrieve value by passing a string which is not the id, how can i do this without writing query.

Thanks,
vyrav.

kukudas · **Joined:** Wed Apr 09, 2008 10:28 am **Posts:** 52

if you want to fetch for e.g. a person from a db without knowing it's id but knowing it's name you have to write a query for this.
something like this probably will do

Code:

Query query=session.createQuery("select p FROM Person p where p.name=?");

Cameron McKenzie · **Posted:** Fri Jul 04, 2008 11:08 am

Indeed, you'll want to look at the Hibernate Query Language HQL:

http://jpa.ezhibernate.com/Javacode/learn.jsp?tutorial=08masteringhqlandnamedqueries

Code:

Session session = HibernateUtil.beginTransaction();
String hql="from User where loginName = 'mj' ";
Query query = session.createQuery(hql);
Object o  = query.uniqueResult();
User u = (User)o;
System.out.println(u.getLoginName());
System.out.println("\n\n");
HibernateUtil.commitTransaction(); 

You could also look at the Hibernate Criteria API for more complex queries as well:

http://jpa.ezhibernate.com/Javacode/learn.jsp?tutorial=09howtousethecriteriaapi