@Override public SQLStaticFilter clone() { SQLStaticFilter clone = new SQLStaticFilter(); clone.column = column; clone.operator = operator; clone.value = value; clone.type = type; return clone; }
protected void addFilterValuesForLog(List<Serializable> values) { for (int i = 0; i < staticFilters.length; i++) { values.add(staticFilters[i].getValue()); } }
protected void addFilterWhereClause(StringBuilder clause, List<ColumnAndValue> params) { if (staticFilters.length == 0) { return; } for (SQLStaticFilter filter : staticFilters) { if (clause.length() > 0) { clause.append(" AND "); } Column column = filter.getDirectoryColumn(table, getDirectory().useNativeCase()); clause.append(column.getQuotedName()); clause.append(" "); clause.append(filter.getOperator()); clause.append(" ?"); params.add(new ColumnAndValue(column, filter.getValue())); } }
protected void addFilterValues(PreparedStatement ps, int startIdx) { for (int i = 0; i < staticFilters.length; i++) { SQLStaticFilter filter = staticFilters[i]; setFieldValue(ps, startIdx + i, filter.getDirectoryColumn(table, getDirectory().useNativeCase()), filter.getValue()); } }
protected String addFilterWhereClause(String whereClause) { if (staticFilters.length == 0) { return whereClause; } if (whereClause != null && whereClause.trim().length() > 0) { whereClause = whereClause + " AND "; } else { whereClause = ""; } for (int i = 0; i < staticFilters.length; i++) { SQLStaticFilter filter = staticFilters[i]; whereClause += filter.getDirectoryColumn(table, getDirectory().useNativeCase()).getQuotedName(); whereClause += " " + filter.getOperator() + " "; whereClause += "? "; if (i < staticFilters.length - 1) { whereClause = whereClause + " AND "; } } return whereClause; }
@Override public SQLDirectoryDescriptor clone() { SQLDirectoryDescriptor clone = (SQLDirectoryDescriptor) super.clone(); // basic fields are already copied by super.clone() if (tableReferences != null) { clone.tableReferences = new TableReferenceDescriptor[tableReferences.length]; for (int i = 0; i < tableReferences.length; i++) { clone.tableReferences[i] = tableReferences[i].clone(); } } if (staticFilters != null) { clone.staticFilters = new SQLStaticFilter[staticFilters.length]; for (int i = 0; i < staticFilters.length; i++) { clone.staticFilters[i] = staticFilters[i].clone(); } } return clone; }