本文整理了Java中net.sf.jsqlparser.schema.Table.toString()
方法的一些代码示例,展示了Table.toString()
的具体用法。这些代码示例主要来源于Github
/Stackoverflow
/Maven
等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。Table.toString()
方法的具体详情如下:
包路径:net.sf.jsqlparser.schema.Table
类名称:Table
方法名:toString
暂无
代码示例来源:origin: JSQLParser/JSqlParser
@Override
public String toString() {
String sql = "DROP " + type + " "
+ (ifExists ? "IF EXISTS " : "") + name.toString();
if (parameters != null && !parameters.isEmpty()) {
sql += " " + PlainSelect.getStringList(parameters);
}
return sql;
}
}
代码示例来源:origin: JSQLParser/JSqlParser
b.append(" ");
for (Table t : tables) {
b.append(t.toString());
代码示例来源:origin: JSQLParser/JSqlParser
b.append(" USING ");
if (usingTable != null) {
b.append(usingTable.toString());
} else if (usingSelect != null) {
b.append("(").append(usingSelect.toString()).append(")");
代码示例来源:origin: JSQLParser/JSqlParser
sql.append(" INTO ");
for (Iterator<Table> iter = intoTables.iterator(); iter.hasNext();) {
sql.append(iter.next().toString());
if (iter.hasNext()) {
sql.append(", ");
代码示例来源:origin: JSQLParser/JSqlParser
public void deParse(Delete delete) {
buffer.append("DELETE");
if (delete.getTables() != null && delete.getTables().size() > 0) {
for (Table table : delete.getTables()) {
buffer.append(" ").append(table.getFullyQualifiedName());
}
}
buffer.append(" FROM ").append(delete.getTable().toString());
if (delete.getJoins() != null) {
for (Join join : delete.getJoins()) {
if (join.isSimple()) {
buffer.append(", ").append(join);
} else {
buffer.append(" ").append(join);
}
}
}
if (delete.getWhere() != null) {
buffer.append(" WHERE ");
delete.getWhere().accept(expressionVisitor);
}
if (delete.getOrderByElements() != null) {
new OrderByDeParser(expressionVisitor, buffer).deParse(delete.getOrderByElements());
}
if (delete.getLimit() != null) {
new LimitDeparser(buffer).deParse(delete.getLimit());
}
}
代码示例来源:origin: JSQLParser/JSqlParser
buffer.append(insert.getTable().toString());
代码示例来源:origin: com.github.jsqlparser/jsqlparser
@Override
public String toString() {
String sql = "DROP " + type + " "
+ (ifExists ? "IF EXISTS " : "") + name.toString();
if (parameters != null && !parameters.isEmpty()) {
sql += " " + PlainSelect.getStringList(parameters);
}
return sql;
}
}
代码示例来源:origin: wxbty/meepo
public static List<String> name_update_table(String sql) throws JSQLParserException {
net.sf.jsqlparser.statement.Statement statement = CCJSqlParserUtil.parse(sql);
Update updateStatement = (Update) statement;
List<Table> update_table = updateStatement.getTables();
List<String> str_table = new ArrayList<>();
if (update_table != null) {
for (int i = 0; i < update_table.size(); i++) {
str_table.add(update_table.get(i).toString());
}
}
return str_table;
}
代码示例来源:origin: wxbty/meepo
public static List<String> name_delete_table(String sql) throws JSQLParserException {
net.sf.jsqlparser.statement.Statement statement = CCJSqlParserUtil.parse(sql);
Delete updateStatement = (Delete) statement;
Table update_table = updateStatement.getTable();
List<String> str_table = new ArrayList<>();
if (update_table != null) {
str_table.add(update_table.toString());
}
return str_table;
}
代码示例来源:origin: com.github.jsqlparser/jsqlparser
b.append(" ");
for (Table t : tables) {
b.append(t.toString());
代码示例来源:origin: com.github.jsqlparser/jsqlparser
b.append(" USING ");
if (usingTable != null) {
b.append(usingTable.toString());
} else if (usingSelect != null) {
b.append("(").append(usingSelect.toString()).append(")");
代码示例来源:origin: com.github.jsqlparser/jsqlparser
sql.append(" INTO ");
for (Iterator<Table> iter = intoTables.iterator(); iter.hasNext();) {
sql.append(iter.next().toString());
if (iter.hasNext()) {
sql.append(", ");
代码示例来源:origin: com.github.jsqlparser/jsqlparser
public void deParse(Delete delete) {
buffer.append("DELETE");
if (delete.getTables() != null && delete.getTables().size() > 0) {
for (Table table : delete.getTables()) {
buffer.append(" ").append(table.getFullyQualifiedName());
}
}
buffer.append(" FROM ").append(delete.getTable().toString());
if (delete.getJoins() != null) {
for (Join join : delete.getJoins()) {
if (join.isSimple()) {
buffer.append(", ").append(join);
} else {
buffer.append(" ").append(join);
}
}
}
if (delete.getWhere() != null) {
buffer.append(" WHERE ");
delete.getWhere().accept(expressionVisitor);
}
if (delete.getOrderByElements() != null) {
new OrderByDeParser(expressionVisitor, buffer).deParse(delete.getOrderByElements());
}
if (delete.getLimit() != null) {
new LimitDeparser(buffer).deParse(delete.getLimit());
}
}
代码示例来源:origin: com.github.jsqlparser/jsqlparser
buffer.append(insert.getTable().toString());
代码示例来源:origin: vincentrussell/sql-to-mongo-db-query-converter
public Builder setJSqlParser(CCJSqlParser jSqlParser) throws com.github.vincentrussell.query.mongodb.sql.converter.ParseException, ParseException {
final Statement statement = jSqlParser.Statement();
if (Select.class.isAssignableFrom(statement.getClass())) {
sqlCommandType = SQLCommandType.SELECT;
final PlainSelect plainSelect = (PlainSelect)(((Select)statement).getSelectBody());
SqlUtils.isTrue(plainSelect != null, "could not parseNaturalLanguageDate SELECT statement from query");
SqlUtils.isTrue(plainSelect.getFromItem()!=null,"could not find table to query. Only one simple table name is supported.");
whereClause = plainSelect.getWhere();
isDistinct = (plainSelect.getDistinct() != null);
isCountAll = SqlUtils.isCountAll(plainSelect.getSelectItems());
SqlUtils.isTrue(plainSelect.getFromItem() != null, "could not find table to query. Only one simple table name is supported.");
table = plainSelect.getFromItem().toString();
limit = SqlUtils.getLimit(plainSelect.getLimit());
orderByElements1 = plainSelect.getOrderByElements();
selectItems = plainSelect.getSelectItems();
joins = plainSelect.getJoins();
groupBys = SqlUtils.getGroupByColumnReferences(plainSelect);
SqlUtils.isTrue(plainSelect.getFromItem() != null, "could not find table to query. Only one simple table name is supported.");
} else if (Delete.class.isAssignableFrom(statement.getClass())) {
sqlCommandType = SQLCommandType.DELETE;
Delete delete = (Delete)statement;
SqlUtils.isTrue(delete.getTables().size() == 0, "there should only be on table specified for deletes");
table = delete.getTable().toString();
whereClause = delete.getWhere();
}
return this;
}
内容来源于网络,如有侵权,请联系作者删除!