/** * Paging query/Public List pagequery (Userinfo Userinfo) {String hql= ' select u from Userinfo u where 1=1 '; final List Paraml ist = new ArrayList (); if (Userinfo.getuserid ()!=null) {hql+= "and u.userid>?"; Paramlist.add (Userinfo.getuserid ()); } if (Userinfo.getusername ()!=null&&! "". Equals (Userinfo.getusername (). Trim ())) {hql+= "and username like?"; Paramlist.add ("%" +userinfo.getusername () + "%"); Final String finalhql=hql; List list=this.gethibernatetemplate (). Executefind (New Hibernatecallback () {public Object doinhibernate session) throws Hibernateexception, SQLException {query query = session.createquery (FINALHQL); for (int i=0;i< Paramlist.size (); i++) {Query.setparameter (I, Paramlist.get (i));} query.setfirstresult (0); Query.setmaxresults (2); return Query.list (); } }); return list; }
For the selected user to be updated, you can use the following code:
public void Updateordeletebyin (final long[] userids) {final String hql= ' update Userinfo set username=? where UserID in ( :p aramuser) "//You must use the named parameter//final String hql=" Delete Userinfo set username=? where UserID in (:p aramuser) "; This.gethibernatetemplate (). Execute (new Hibernatecallback () {public Object Doinhibernate (sessions session) throws Hibernateexception, SQLException {Query query=session.createquery (HQL); Query.setparameter (0, "test");//named parameter if set, Then use Query.setparameterlist query.setparameterlist ("Paramuser", UserIDs); Query.executeupdate (); return null; } }); }