hibernate模糊查询id为long型的情况

 在hibernate中模糊查询long型数据的时候,网上例子比较好，这里写出来供大家讨论一下，这里要注意:
目前试过的方法中好象只有通过Restrictions.sqlRestriction的方式来进行
具体事例如下:

//此处主要是判断是否全区查询
if(searchCondition.getIsSelectedAllArea() != null && searchCondition.getIsSelectedAllArea().equals("on")){
    //criteria.createAlias("area", "o").add(Restrictions.like("o.id","%"+searchCondition.getAreaId().toString().substring(0, 4)+"%"));
    criteria.createAlias("area", "o").add(Restrictions.sqlRestriction("AREA_ID  like  (?)","%"+searchCondition.getAreaId().toString().substring(0, 4)+"%",Hibernate.STRING));
}else{
   if (searchCondition.getAreaId() != null && !searchCondition.getAreaId().equals("")) {
 criteria.createAlias("area", "o").add(Restrictions.eq("o.id", searchCondition.getAreaId()));
  }
}

附属上全部代码如下：
public List findBillQueryResult(SearchCondition searchCondition, String billTypeKey, SearchDateBean searchDateBean) {

  DetachedCriteria criteria;
  if (DOMSGlobalConstant.DICT_KEY_FOR_BILL_TYPE_TURNINBILL.equals(billTypeKey)) {
   criteria = DetachedCriteria.forClass(TurnBill.class);
  } else if (DOMSGlobalConstant.DICT_KEY_FOR_BILL_TYPE_MOVEBILL.equals(billTypeKey)) {
   criteria = DetachedCriteria.forClass(MoveBill.class);
  } else if (DOMSGlobalConstant.DICT_KEY_FOR_BILL_TYPE_OLDBILL.equals(billTypeKey)){
   criteria = DetachedCriteria.forClass(OldBill.class);
  }else if (DOMSGlobalConstant.DICT_KEY_FOR_BILL_TYPE_WASTERBILL.equals(billTypeKey)){
   criteria = DetachedCriteria.forClass(WasterBill.class);
  }else{
   criteria = DetachedCriteria.forClass(DrawBill.class);
  }
  if (searchCondition.getApplyAccount() != null && !searchCondition.getApplyAccount().equals("")) {
   criteria.createAlias("materialMan", "a").add(Restrictions.like("a.staffAccount", "%" + searchCondition.getApplyAccount() + "%").i