I am not very familiar with the QBC syntax, but I would like to share it with you. Sometimes QBC is very efficient and it is very convenient to master it. I have already talked about some usage of QBC in my previous blog, today, we will review the query of the date range using QBC.CodeAs follows:
Methods In the DaO layer:
// Hql public list findbyhql (integer page, integer row, date startdate, date enddate) {try {query = session. createquery ("from student Stu where stu. date>: startdate and Stu. date <=: enddate "). settimestamp ("startdate", startdate ). settimestamp ("enddate", enddate); query. setfirstresult (page-1) * row); query. setmaxresults (ROW); Return query. list ();} catch (runtimeexception re) {Throw re;} // public list in QBC language findbylikeexamplebydate (student instance, integer page, integer row, date startdate, date enddate) {try {list Results = getsession (). createcriteria ("com. tjcyjd. student "). setfirstresult (page-1) * row ). setmaxresults (ROW ). add (expression. between ("date", startdate, enddate )). addorder (Order. ASC ("studentid ")). add (example. create (instance ). enablelike (matchmode. anywhere )). list (); return results;} catch (runtimeexception re) {Throw re ;}}