criteria接口查询某字段不为#开头
criteria = session.createCriteria(ClientPhone.class);
criteria.add(Restrictions.sqlRestriction("{alias}.phone not like '#%'"));
criteria.add(Restrictions.like("phone", queryStr,
MatchMode.ANYWHERE));
criteria = session.createCriteria(ClientPhone.class);
criteria.add(Restrictions.sqlRestriction("{alias}.phone not like '#%'"));
criteria.add(Restrictions.like("phone", queryStr,
MatchMode.ANYWHERE));