public static void appendMap(StatementBuilder sql, Map<String, String> map) { sql.resetCount(); sql.append("("); for (Entry<String, String> e : map.entrySet()) { if (e.getValue() == null) continue; sql.appendExceptFirst(","); sql.append(e.getKey()).append('=').append("'").append(e.getValue()).append("'"); } sql.append(')'); }
private void appendKeyCondition(StatementBuilder buff) { buff.append(" WHERE "); buff.resetCount(); for (String k : key) { buff.appendExceptFirst(" AND "); buff.append(StringUtils.quoteIdentifier(k)).append("=?"); } }
private void appendColumnList(StatementBuilder buff, boolean set) { buff.resetCount(); for (int i = 0; i < columnCount; i++) { buff.appendExceptFirst(","); String col = result.getColumnName(i); buff.append(StringUtils.quoteIdentifier(col)); if (set) { buff.append("=? "); } } }
@Override public String getString() { try { StatementBuilder buff = new StatementBuilder("("); result.beforeFirst(); ResultSetMetaData meta = result.getMetaData(); int columnCount = meta.getColumnCount(); for (int i = 0; result.next(); i++) { if (i > 0) { buff.append(", "); } buff.append('('); buff.resetCount(); for (int j = 0; j < columnCount; j++) { buff.appendExceptFirst(", "); int t = DataType.convertSQLTypeToValueType(meta.getColumnType(j + 1)); Value v = DataType.readValue(null, result, j + 1, t); buff.append(v.getString()); } buff.append(')'); } result.beforeFirst(); return buff.append(')').toString(); } catch (SQLException e) { throw DbException.convert(e); } }
private void appendWhere(StatementBuilder buff) { buff.append(" WHERE "); buff.resetCount(); for (IndexColumn c : columns) { buff.appendExceptFirst(" AND "); buff.append(database.quoteIdentifier(c.column.getName())).append("=?"); } }
private void appendUpdate(StatementBuilder buff) { buff.append("UPDATE ").append(table.getSQL()).append(" SET "); buff.resetCount(); for (IndexColumn c : columns) { buff.appendExceptFirst(" , "); buff.append(database.quoteIdentifier(c.column.getName())).append("=?"); } }
appendColumnList(buff, false); buff.append(")VALUES("); buff.resetCount(); for (int i = 0; i < columnCount; i++) { buff.appendExceptFirst(",");
buff.resetCount(); for (IndexColumn r : refColumns) { buff.appendExceptFirst(", "); if (searchIndex != null && check != null) { buff.append(" ("); buff.resetCount(); Column[] cols = searchIndex.getColumns(); int len = Math.min(columns.length, cols.length);
if (keys != null) { buff.append(" KEY("); buff.resetCount(); for (Column c : keys) { buff.appendExceptFirst(", "); buff.resetCount(); for (Expression e : expr) { buff.appendExceptFirst(", ");
buff.resetCount(); for (Column c : keys) { buff.appendExceptFirst(" AND ");
buff.resetCount(); for (Expression e : expr) { buff.appendExceptFirst(", ");
buff.resetCount(); for (IndexColumn c : columns) { buff.appendExceptFirst(" AND "); buff.resetCount(); for (IndexColumn c : columns) { buff.appendExceptFirst(", "); buff.resetCount(); int i = 0; for (IndexColumn c : columns) {
TableFilter filter = topTableFilter; if (filter != null) { buff.resetCount(); int i = 0; do { } while (filter != null); } else { buff.resetCount(); int i = 0; for (TableFilter f : topFilters) { buff.resetCount(); for (int gi : groupIndex) { Expression g = exprList[gi]; buff.resetCount(); for (Expression g : group) { buff.appendExceptFirst(", "); buff.resetCount(); for (SelectOrderBy o : orderList) { buff.appendExceptFirst(", ");
buff.resetCount(); for (IndexColumn r : refCols) { buff.appendExceptFirst(", ");