hibernate重要查询语句

public List<RenewInsur> getRenewInsurByCarNo(String carNo) {
System.out.println("getRenewInsurByCarNo *********************** "  + carNo); 
//carNo = carNo + "            ";
List<RenewInsur> list = new ArrayList<RenewInsur>();
DetachedCriteria dc = DetachedCriteria.forClass(this.renewInsurClass);
if (carNo != null && !carNo.equals("")) {
dc.add(Restrictions.sqlRestriction("trim(license_No) = '" + carNo + "'"));//真实的sql
}
 
List<RenewInsur> renewInsurList = super.getHibernateTemplate()
.findByCriteria(dc);


if (renewInsurList == null)
return null;
return renewInsurList;
}