I want to know how to write hibernate select query with where clause.


public String hibSelect(User tblObj, String sqlInsert) {


//sqlInsert = "SELECT * FROM mst_user WHERE user_id=?"

Session session = null;
String temp = "";
System.out.println(1);

AnnotationConfiguration ac = new AnnotationConfiguration();
session = ac.configure().buildSessionFactory().openSession();
if(session != null)
{
System.out.println("not null");
}
System.out.println(2);

SQLQuery query = session.createSQLQuery(sqlInsert);
System.out.println(3);

String name = tblObj.getUser_id();

query.setString(0, "ann");


System.out.println(4);

String q = query.toString();


Iterator iterator = query.iterate();

while(iterator.hasNext())
{
Object[] row = (Object[]) iterator.next();
temp = temp+":"+row[0];
}




return temp;
}

I wrote like this but this is not working.

1) Is there any reason you use SQL and not HQL which is objectoriented and much easier?
2)I hope this just a testMethod and you don't create a new SessionFactory (and Configuration) every time you call your other methods.
3)you should close the session at the end.
4) you should probably use a transaction

5)named queries ("...where user_id=:id") are much more readable than indexed queries ("...where user_id=?")
6)-If you try to get the one instance of User with this user_id, use

-If user_id is not the primary id but denotes an association and you want all Users associated with the instance with that id, use this HQL-Querry:

Hey Thanks Friend, It is really well explained.

Thank you again 'simon.void'.......

regards
Dilan Silva.

I create a sessionFactory in every method which is for insert, update, delete and select.

As you say it is not suitable.

But If I created a sessionFactory in every method, I close them at the end of the method. so is there any wrong?

to 'simon.void'

one line solved every problems

User user = (User)session.get( User.class,tblObj.getUser_id() );

really appreciate your help....

regards
Dilan

How do I apply this method to composite primary key ?

If you want to load an object with the composite id you just need to create new such object, define composite id properties and use it as an identifier.

For example if you have a class like


with the mapping like



You can perform lookup by the following code: