criteria = session.createCriteria(ClientPhone.class);
criteria.add(Restrictions.sqlRestriction("{alias}.phone not like ‘#%‘"));
criteria.add(Restrictions.like("phone", queryStr,
MatchMode.ANYWHERE));
原文：http://www.cnblogs.com/jupal/p/5222071.html