如果是MySQL:
c.add(Restrictions.sqlRestriction("CAST({alias}.id AS CHAR) like ?", "%1%", Hibernate.STRING));
c.add(Restrictions.sqlRestriction("CAST({alias}.id AS CHAR) like ?", "%1%", Hibernate.STRING));
Oracle:
c.add(Restrictions.sqlRestriction("to_char({alias}.id) like ?","1%",Hibernate.STRING))