hibernate - How we can Query object in hibernateTemplate -

hibernate - How we can Query object in hibernateTemplate -

i want utilize query object in hibernatetemplate. can utilize query object hibernatetemplate deprecated spring.

if 1 using other way please guide me

thanks in advance

dharmendra

you can utilize either pure sql or can writing simplified queries like:

session session = sessionfactory.getcurrentsession(); query query = session.createquery("from tablename id=:userid"); query.setstring("userid", userid); //userid of string type or can utilize userid+"" convert string list<myentitypojoname> result = query.list(); //this homecoming list of myentitypojoname objects

or can write pure sql within createquery() function below:

session session = sessionfactory.getcurrentsession(); query query = session.createquery("delete tablename myentitypojoname id=:userid , hid=:hospitalid"); query.setstring("userid",myuserid); query.setstring("hospitalid", myhospid); int row = query.executeupdate(); //returns number of updated rows

for hibernate implemented functions saveorupdate(),save() etc. can take @ hibernate docs @ http://www.hibernate.org/docs

hibernate spring