net.sf.jsqlparser.schema.Table.toString()方法的使用及代码示例

x33g5p2x  于2022-01-30 转载在 其他  
字(6.3k)|赞(0)|评价(0)|浏览(141)

本文整理了Java中net.sf.jsqlparser.schema.Table.toString()方法的一些代码示例,展示了Table.toString()的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。Table.toString()方法的具体详情如下:
包路径:net.sf.jsqlparser.schema.Table
类名称:Table
方法名:toString

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;
}

相关文章