public Integer deleteByDateInterval( DeleteDataForm.DateIntervalType dateIntervalType, final Integer dateIntervalSize) { String sql = "DELETE FROM " + tableName + " WHERE occurred_at < DATE_SUB(CURDATE(), INTERVAL ? " + dateIntervalType.toString() + ")"; return jdbcTemplate.update( sql, new PreparedStatementSetter() { public void setValues(PreparedStatement ps) throws SQLException { ps.setInt(1, dateIntervalSize); } }); }