@Override protected PreparedStatement getDeleteStatement(Vote vote) throws SQLException { PreparedStatement statement = getConnection().prepareStatement(DELETE_QUERY); try { statement.setLong(1, vote.getId()); return statement; } catch (SQLException e) { statement.close(); throw e; } }
@Override protected PreparedStatement getUpdateStatement(Vote vote) throws SQLException { validate(vote); PreparedStatement statement = getConnection().prepareStatement(UPDATE_QUERY); try { User author = vote.getAuthor(); if (author == null) { statement.setNull(1, Types.INTEGER); } else { statement.setLong(1, author.getId()); } statement.setLong(2, vote.getAnswer().getId()); statement.setTimestamp(3, DatabaseUtil.dateToTimestamp(vote.getCreationDate())); statement.setLong(4, vote.getId()); return statement; } catch (SQLException e) { statement.close(); throw e; } }