尝试这个：
List words = session.createCriteria(Word.class).setProjection(Projections.property("word")).add(Restrictions.and(Restrictions.gt("w_id",100), Restrictions.sqlRestriction(word REGEXP '^[A-Z][A-Za-z]*$'))).setMaxResults(2000).list();
尝试这个：
List words = session.createCriteria(Word.class).setProjection(Projections.property("word")).add(Restrictions.and(Restrictions.gt("w_id",100), Restrictions.sqlRestriction(word REGEXP '^[A-Z][A-Za-z]*$'))).setMaxResults(2000).list();名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
