criteria接口查询某字段不为#开头

criteria = session.createCriteria(ClientPhone.class);
criteria.add(Restrictions.sqlRestriction("{alias}.phone not like '#%'"));
criteria.add(Restrictions.like("phone", queryStr,
MatchMode.ANYWHERE));

posted @ 2016-02-26 23:12  巨炮  阅读(868)  评论(0)    收藏  举报