Hibernate advanced Query Method

Java code
Public List <BillMain> retrieve (BillMain billMain ){
Criteria criteria = billMainDAO. getSession (). createCriteria (
BillMain. class );
If (! StringUtil. isEmpty (billMain. getCustomerAdd ())){
Criteria. add (Restrictions. like ("customerAdd", "%"
+ BillMain. getCustomerAdd (). trim () + "% "));
}
// Query by company name
/*
* If (! StringUtil. isEmpty (billMain. getCustomerName ())){
* Criteria. add (Restrictions. like ("customerName", "%" +
* BillMain. getCustomerName (). trim () + "% "));}
*/
If (! StringUtil. isEmpty (billMain. getEntryId ())){
Criteria. add (Restrictions. like ("entryId", "%"
+ BillMain. getEntryId (). trim () + "% "));
}
If (! StringUtil. isEmpty (billMain. getOperator ())){
Criteria. add (Restrictions. like ("operator", "%"
+ BillMain. getOperator (). trim () + "% "));
}
If (null! = BillMain. getOperaTime ()){
Criteria
. Add (Restrictions
. SqlRestriction ("convert (varchar (10), this _. operaTime, 120) like '%"
+ BillMain. getOperaTime (). toString ()
. Substring (0, 10) + "% '"));
}
Criteria. add (Property. forName ("state"). eq ("N"). addOrder (
Order. desc ("id "));
 
Return criteria. list ();
}

Author: qiaolevip"