@Override public void removeLinksForTarget(String targetId) { try (SQLSession session = getSQLSession()) { removeLinksForTarget(targetId, session); } }
@Override public void setTargetIdsForSource(String sourceId, List<String> targetIds) { try (SQLSession session = getSQLSession()) { setTargetIdsForSource(sourceId, targetIds, session); } }
@Override public void addLinks(List<String> sourceIds, String targetId) { if (sourceIds == null) { return; } try (SQLSession session = getSQLSession()) { addLinks(sourceIds, targetId, session); } }
@Override public void removeLinksForSource(String sourceId) { try (SQLSession session = getSQLSession()) { removeLinksForSource(sourceId, session); } }
@Override public void setSourceIdsForTarget(String targetId, List<String> sourceIds) { try (SQLSession session = getSQLSession()) { setSourceIdsForTarget(targetId, sourceIds, session); } }
@Override public void addLinks(String sourceId, List<String> targetIds) { if (targetIds == null) { return; } try (SQLSession session = getSQLSession()) { addLinks(sourceId, targetIds, session); } }
protected List<String> getIdsFor(String valueColumn, String filterColumn, String filterValue) { try (SQLSession session = getSQLSession()) { // "SELECT %s FROM %s WHERE %s = ?", table.getColumn(valueColumn), tableName, filterColumn Select select = new Select(table); select.setWhat(table.getColumn(valueColumn).getQuotedName()); select.setFrom(table.getQuotedName()); select.setWhere(table.getColumn(filterColumn).getQuotedName() + " = ?"); String sql = select.getStatement(); if (session.logger.isLogEnabled()) { session.logger.logSQL(sql, Collections.<Serializable> singleton(filterValue)); } List<String> ids = new LinkedList<String>(); try (PreparedStatement ps = session.sqlConnection.prepareStatement(sql)) { ps.setString(1, filterValue); try (ResultSet rs = ps.executeQuery()) { while (rs.next()) { ids.add(rs.getString(valueColumn)); } return ids; } } catch (SQLException e) { throw new DirectoryException("error fetching reference values: ", e); } } }