Java JSQLParserException.printStackTrace方法代码示例

import net.sf.jsqlparser.JSQLParserException; //导入方法依赖的package包/类
/**
 * 找到所有绑定变量
 *
 * @param sql
 * @return
 */
protected static Set<Expression> findBindArgsExpressions(String sql) {
    if (sql == null || sql.startsWith("PRAGMA") || !sql.contains("?")) {
        return new LinkedHashSet<>();
    }

    KbSqlParserManager pm = new KbSqlParserManager();

    try {
        Statement statement = pm.parse(sql);

        Set<Expression> expressionSet = findBindArgsExpressions(statement);

        return expressionSet;
    } catch (JSQLParserException e) {
        e.printStackTrace();
    }
    return new LinkedHashSet<>();
}
 

import net.sf.jsqlparser.JSQLParserException; //导入方法依赖的package包/类
private String parse(String query, QueryType queryType) {
    Statement statement = null;

    try {
        // Read and parse the query
        Reader reader = new StringReader(query);
        statement = parserManager.parse(reader);

        // Find the appropriate method to call based on the query and statement types
        if (statement instanceof Select) {
            statement = queryType.parseQuery((Select) statement, this);
        } else if (statement instanceof Insert) {
            statement = queryType.parseQuery((Insert) statement, this);
        } else if (statement instanceof Delete) {
            statement = queryType.parseQuery((Delete) statement, this);
        } else if (statement instanceof Update) {
            requiresUpdate = true;
            statement = queryType.parseQuery((Update) statement, this);
        } else {
            logger.error("SQL statement type not supported.");
        }
    } catch (JSQLParserException e) {
        logger.error("Failed to parse query");
        e.printStackTrace();
    }

    return statement == null ? "" : statement.toString();
}
 

import net.sf.jsqlparser.JSQLParserException; //导入方法依赖的package包/类
/**
* 
* @param sql
* @return
* @throws JSQLParserException
*/
  public static StatementFinder getStatementFinder(String sql) {

      CCJSqlParserManager pm = new CCJSqlParserManager();
      net.sf.jsqlparser.statement.Statement statement = null;
      StatementFinder statementFinder = null;
      try {
          statement = pm.parse(new StringReader(sql));
          if (statement instanceof Select) {
              Select selectStatement = (Select) statement;
              statementFinder = new SelectItemFinder(selectStatement);
          } else if (statement instanceof Insert) {
              Insert insertStatement = (Insert) statement;
              statementFinder = new InsertItemFinder(insertStatement);
          }
          else if (statement instanceof Delete) {
              Delete deleteStatement = (Delete) statement;
              statementFinder = new DeleteItemFinder(deleteStatement);
          } else if (statement instanceof Update) {
              Update updateStatement = (Update) statement;
              statementFinder = new UpdateItemFinder(updateStatement);
          }
      } catch (JSQLParserException e) {
          e.printStackTrace();
          throw new RuntimeException(e);
      }
      return statementFinder;
  }
 

import net.sf.jsqlparser.JSQLParserException; //导入方法依赖的package包/类
@Test
public void testUnion() {
    TableNameReplacer tableNameReplacer = new TableNameReplacer(manager);
    String sqlcmd = "select * from ddf://adatao/a union select * from " +
            "ddf://adatao/b";
    try {
        Statement statement = parser.parse(new StringReader(sqlcmd));
        // System.out.println(statement.toString());
        int a = 2;
    } catch (JSQLParserException e) {
        e.printStackTrace();
    }
}
 

import net.sf.jsqlparser.JSQLParserException; //导入方法依赖的package包/类
public List<ColumnField> getAutoincrementColumn(String tableName) {
    List<ColumnField> columnFieldList = new LinkedList<>();

    if (!isDBOk()) {
        return columnFieldList;
    }

    String sql = "SELECT sql FROM sqlite_master WHERE type='table' AND name='" + tableName + "'";
    Cursor cursor = _db.rawQuery(sql, null);
    if (cursor == null) return columnFieldList;

    if (!cursor.moveToFirst()) {
        cursor.close();
        return columnFieldList;
    }

    String sqlStr = cursor.getString(0);
    cursor.close();

    if (TextUtils.isEmpty(sqlStr)) return columnFieldList;

    try {
        CreateTable createTable = (CreateTable) CCJSqlParserUtil.parse(sqlStr);
        List<ColumnDefinition> columnList = createTable.getColumnDefinitions();

        ColumnField field;
        List<String> specList;
        for (ColumnDefinition definition : columnList) {

            field = new ColumnField();
            field.setFieldName(SQLTools.removeColumnMark(definition.getColumnName()));
            field.setFieldType(SQLTools.removeColumnMark(definition.getColDataType().getDataType()));

            specList = definition.getColumnSpecStrings();
            if (specList != null) {
                String tmpStr;
                int next;
                int conditionSize = specList.size();
                for (int i = 0; i < conditionSize; i++) {
                    next = i + 1;
                    tmpStr = specList.get(i).toUpperCase();

                    if (tmpStr.equals(Constant.PRIMARY_VALUE)) {
                        field.setPk(1);
                    }

                    if (tmpStr.equals(Constant.AUTOINCREMENT_VALUE)) {
                        field.setIsAutoIncr(true);
                    }

                    if (tmpStr.equals(Constant.NOT_VALUE) &&
                            specList.get(next).toUpperCase().equals(Constant.NULL_VALUE)) {
                        field.setNotNull(1);
                    }

                    if (tmpStr.equals(Constant.DEFAULT_VALUE)) {
                        if (next < conditionSize && !TextUtils.isEmpty(specList.get(next))) {
                            field.setDef(SQLTools.removeColumnMark(specList.get(next)));
                        }
                    }
                }
            }

            columnFieldList.add(field);
            Logger.d("--------" + field.toString());
        }

    } catch (JSQLParserException e) {
        e.printStackTrace();
    }

    return columnFieldList;
}