CriteriaQuery cq = new CriteriaQuery(StockRoomEntity.class);
cq.sql("{alias}.activity_name LIKE lower(%"+roomEntity.getActivityName()+"%)");
cq.sql("{alias}.procInsId like ? ",roomEntity.getProcInsId(), StringType.INSTANCE);
CriteriaQuery是封装的一个类
有重载的三个方法
public void sql(String sql) {
Restrictions.sqlRestriction(sql);
}
public void sql(String sql, Object[] objects, Type[] type) {
Restrictions.sqlRestriction(sql, objects, type);
}
public void sql(String sql, Object objects, Type type) {
Restrictions.sqlRestriction(sql, objects, type);
}