@Override public Column getPrimaryColumn() { return new Column(table.getPrimaryColumn(), this); }
@Override public void deleteEntryWithoutReferences(String id) { // second step: clean stored fields Delete delete = new Delete(table); String whereString = table.getPrimaryColumn().getQuotedName() + " = ?"; delete.setWhere(whereString); String sql = delete.getStatement(); if (logger.isLogEnabled()) { logger.logSQL(sql, Collections.singleton(id)); } try (PreparedStatement ps = sqlConnection.prepareStatement(sql)) { setFieldValue(ps, 1, table.getPrimaryColumn(), id); ps.execute(); } catch (SQLException e) { checkConcurrentUpdate(e); throw new DirectoryException("deleteEntry failed", e); } }
List<Serializable> values = new ArrayList<>(1 + map.size()); whereClause.append(table.getPrimaryColumn().getQuotedName()); whereClause.append(" = ?"); values.add(id); for (int i = 0; i < values.size(); i++) { if (i == 0) { setFieldValue(ps, 1, table.getPrimaryColumn(), values.get(i)); } else { ps.setString(1 + i, (String) values.get(i));
@Override public boolean hasEntry(String id) { acquireConnection(); Select select = new Select(table); select.setFrom(table.getQuotedName()); select.setWhat("1"); select.setWhere(table.getPrimaryColumn().getQuotedName() + " = ?"); String sql = select.getStatement(); if (logger.isLogEnabled()) { logger.logSQL(sql, Collections.singleton(id)); } try (PreparedStatement ps = sqlConnection.prepareStatement(sql)) { setFieldValue(ps, 1, table.getPrimaryColumn(), id); try (ResultSet rs = ps.executeQuery()) { boolean has = rs.next(); if (logger.isLogEnabled()) { logger.logCount(has ? 1 : 0); } return has; } } catch (SQLException e) { throw new DirectoryException("hasEntry failed", e); } }
String whereClause = table.getPrimaryColumn().getQuotedName() + " = ?"; whereClause = addFilterWhereClause(whereClause); select.setWhere(whereClause); setFieldValue(ps, 1, table.getPrimaryColumn(), id); addFilterValues(ps, 2); try (ResultSet rs = ps.executeQuery()) {
select.setWhat(getReadColumnsSQL()); String whereClause = table.getPrimaryColumn().getQuotedName() + " = ?"; whereClause = addFilterWhereClause(whereClause); setFieldValue(ps, 1, table.getPrimaryColumn(), id); addFilterValues(ps, 2);
String whereString = table.getPrimaryColumn().getQuotedName() + " = ?"; update.setWhere(whereString); String sql = update.getStatement(); index++; setFieldValue(ps, index, table.getPrimaryColumn(), docModel.getId()); ps.execute(); } catch (SQLException e) {