UserGroupServiceLocalBean.java 文件源码

public void addAccessibleServices(String unitId,
        List<String> accessibleServices) {
    List<Long> existingInvisibleProductKeys = getExistingInvisibleProductKeys(unitId);

    for (String product : accessibleServices) {
        if (existingInvisibleProductKeys.contains(Long.valueOf(product))) {
            String queryString = "DELETE FROM UserGroupToInvisibleProduct as ug2ip "
                    + "WHERE ug2ip.usergroup_tkey=:unitId AND ug2ip.product_tkey=:productId";
            Query query = dm.createNativeQuery(queryString);
            query.setParameter("productId", Long.valueOf(product));
            query.setParameter("unitId", Long.valueOf(unitId));
            query.executeUpdate();
        }
    }
}