在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