QBC中sqlRestriction方法应用

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);
	}