public void deleteRightCriteriumImpl(Connection con, int id) throws SQLException {
   StringTemplate template = SecurityDatabaseUtils.stGroup().getInstanceOf("deleteRightCriterium");
   JDBCUpdateTemplate jdbcTemplate = new JDBCUpdateTemplate(con, false);
   String sql = template.toString();
   LOGGER.fine(sql);
   jdbcTemplate.executeUpdate(sql, id);
 }
 public void updateRightCriteriumImpl(Connection con, RightCriteriumWrapper criteriumWrapper)
     throws SQLException {
   StringTemplate template = SecurityDatabaseUtils.stGroup().getInstanceOf("updateRightCriterium");
   template.setAttribute("criteriumWrapper", criteriumWrapper);
   JDBCUpdateTemplate jdbcTemplate = new JDBCUpdateTemplate(con, false);
   String sql = template.toString();
   LOGGER.fine(sql);
   jdbcTemplate.executeUpdate(sql);
 }
 @InitSecurityDatabase
 public int insertRightCriteriumParamsImpl(Connection con, RightCriteriumParams criteriumParams)
     throws SQLException {
   StringTemplate template =
       SecurityDatabaseUtils.stGroup().getInstanceOf("insertRightCriteriumParams");
   template.setAttribute("params", criteriumParams);
   JDBCUpdateTemplate jdbcTemplate = new JDBCUpdateTemplate(con, false);
   String sql = template.toString();
   LOGGER.fine(sql);
   return jdbcTemplate.executeUpdate(sql);
 }
 @InitSecurityDatabase
 public int insertRightCriteriumImpl(Connection con, RightCriteriumWrapper criterium)
     throws SQLException {
   StringTemplate template = SecurityDatabaseUtils.stGroup().getInstanceOf("insertRightCriterium");
   template.setAttribute("criteriumWrapper", criterium);
   template.setAttribute("type", criterium.getCriteriumType().getVal());
   JDBCUpdateTemplate jdbcTemplate = new JDBCUpdateTemplate(con, false);
   String sql = template.toString();
   LOGGER.fine(sql);
   return jdbcTemplate.executeUpdate(sql);
 }
 @InitSecurityDatabase
 public int insertRightImpl(Connection con, Right right) throws SQLException {
   StringTemplate template = SecurityDatabaseUtils.stGroup().getInstanceOf("insertRight");
   template.setAttribute("association", right.getUser() instanceof Role ? "group_id" : "user_id");
   template.setAttribute("right", right);
   template.setAttribute(
       "priority", right.getFixedPriority() == 0 ? "NULL" : "" + right.getFixedPriority());
   JDBCUpdateTemplate jdbcTemplate = new JDBCUpdateTemplate(con, false);
   String sql = template.toString();
   LOGGER.fine(sql);
   return jdbcTemplate.executeUpdate(sql);
 }