@Override public String toString() { StringBuilder b = new StringBuilder(); b.append(column.toString()); for (int i = 0; i < idents.size(); i++) { b.append(operators.get(i)).append(idents.get(i)); } return b.toString(); } }
@Override public String toString() { StringBuilder b = new StringBuilder(); b.append(" WHEN MATCHED THEN UPDATE SET "); for (int i = 0; i < columns.size(); i++) { if (i != 0) { b.append(", "); } b.append(columns.get(i).toString()).append(" = ").append(values.get(i).toString()); } if (whereCondition != null) { b.append(" WHERE ").append(whereCondition.toString()); } if (deleteWhereCondition != null) { b.append(" DELETE WHERE ").append(deleteWhereCondition.toString()); } return b.toString(); } }
for (Iterator<Column> iterator = join.getUsingColumns().iterator(); iterator.hasNext();) { Column column = iterator.next(); buffer.append(column.toString()); if (iterator.hasNext()) { buffer.append(", ");
@Override public String toString() { StringBuilder b = new StringBuilder(); b.append(column.toString()); for (int i = 0; i < idents.size(); i++) { b.append(operators.get(i)).append(idents.get(i)); } return b.toString(); } }
@Override public String toString() { StringBuilder b = new StringBuilder(); b.append(" WHEN MATCHED THEN UPDATE SET "); for (int i = 0; i < columns.size(); i++) { if (i != 0) { b.append(", "); } b.append(columns.get(i).toString()).append(" = ").append(values.get(i).toString()); } if (whereCondition != null) { b.append(" WHERE ").append(whereCondition.toString()); } if (deleteWhereCondition != null) { b.append(" DELETE WHERE ").append(deleteWhereCondition.toString()); } return b.toString(); } }
public static List<String> name_update_column(String sql) throws JSQLParserException { net.sf.jsqlparser.statement.Statement statement = CCJSqlParserUtil.parse(sql); Update updateStatement = (Update) statement; List<Column> update_column = updateStatement.getColumns(); List<String> str_column = new ArrayList<>(); if (update_column != null) { for (int i = 0; i < update_column.size(); i++) { str_column.add(update_column.get(i).toString()); } } return str_column; }
public static List<String> name_insert_column(String sql) throws JSQLParserException { net.sf.jsqlparser.statement.Statement statement = CCJSqlParserUtil.parse(sql); Insert insertStatement = (Insert) statement; List<Column> table_column = insertStatement.getColumns(); List<String> str_column = new ArrayList<>(); for (int i = 0; i < table_column.size(); i++) { str_column.add(table_column.get(i).toString()); } return str_column; }
for (Iterator<Column> iterator = join.getUsingColumns().iterator(); iterator.hasNext();) { Column column = iterator.next(); buffer.append(column.toString()); if (iterator.hasNext()) { buffer.append(", ");