Package com.alibaba.druid.sql.parser

Class SQLStatementParser

java.lang.Object

com.alibaba.druid.sql.parser.SQLParser

com.alibaba.druid.sql.parser.SQLStatementParser

Direct Known Subclasses:

AdsStatementParser, AntsparkStatementParser, BlinkStatementParser, ClickhouseStatementParser, DB2StatementParser, H2StatementParser, HiveStatementParser, MySqlStatementParser, OdpsStatementParser, OracleStatementParser, OracleUpdateParser, OscarStatementParser, PGSQLStatementParser, PhoenixStatementParser, PrestoStatementParser, SQLDDLParser, SQLServerStatementParser, StarRocksStatementParser

public class SQLStatementParser
extends SQLParser

Field Summary

Fields

Modifier and Type	Field	Description
protected Date	currentDate
protected SQLExprParser	exprParser
protected InsertColumnsCache	insertColumnsCache
protected Timestamp	now
protected boolean	parseCompleteValues
protected int	parseValuesSize
protected SchemaRepository	repository
protected SQLSelectListCache	selectListCache

Fields inherited from class com.alibaba.druid.sql.parser.SQLParser

dbType, lexer

Constructor Summary

Constructors

Modifier	Constructor	Description
protected	SQLStatementParser(Lexer lexer, DbType dbType)
	SQLStatementParser(SQLExprParser exprParser)
	SQLStatementParser(String sql)
	SQLStatementParser(String sql, DbType dbType)

Method Summary

Modifier and Type	Method	Description
SQLSelectParser	createSQLSelectParser()
SQLSelectParser	createSQLSelectParser(SQLExprParser exprParser)
protected SQLUpdateStatement	createUpdateStatement()
SQLExprParser	getExprParser()
int	getParseValuesSize()
SchemaRepository	getRepository()
SQLSelectListCache	getSelectListCache()
SQLCreateTableParser	getSQLCreateTableParser()
boolean	isKeepComments()
boolean	isParseCompleteValues()
SQLStatement	parseAlter()
protected SQLAlterTableAlterColumn	parseAlterColumn()
protected SQLStatement	parseAlterDatabase()
void	parseAlterDrop(SQLAlterTableStatement stmt)
protected SQLStatement	parseAlterFunction()
protected SQLStatement	parseAlterIndex()
SQLStatement	parseAlterMaterialized()
protected SQLStatement	parseAlterResourceGroup()
protected SQLStatement	parseAlterSchema()
SQLAlterSequenceStatement	parseAlterSequence()
protected SQLAlterTableAddClusteringKey	parseAlterTableAddClusteringKey()
protected SQLAlterTableAddColumn	parseAlterTableAddColumn()
protected SQLAlterTableDropPartition	parseAlterTableDropPartition(boolean ifExists)
protected SQLAlterTableDropSubpartition	parseAlterTableDropSubpartition()
protected SQLAlterTableItem	parseAlterTableRename()
protected SQLAlterTableReplaceColumn	parseAlterTableReplaceColumn()
protected SQLStatement	parseAnalyze()
void	parseAssignItems(List<? super SQLAssignItem> items, SQLObject parent)
void	parseAssignItems(List<? super SQLAssignItem> items, SQLObject parent, boolean variant)
SQLStatement	parseBlock()
SQLCallStatement	parseCall()
SQLStatement	parseCase()
SQLStatement	parseClone()
SQLStatement	parseClose()
SQLCommentStatement	parseComment()
SQLStatement	parseCommit()
SQLStatement	parseCopy()
SQLStatement	parseCreate()
SQLStatement	parseCreateDatabase()
SQLStatement	parseCreateDbLink()
SQLStatement	parseCreateExternalCatalog()
SQLCreateFunctionStatement	parseCreateFunction()
SQLCreateIndexStatement	parseCreateIndex(boolean acceptCreate)
SQLStatement	parseCreateMaterializedView()
SQLStatement	parseCreatePackage()
SQLCreateProcedureStatement	parseCreateProcedure()
protected SQLStatement	parseCreateResourceGroup()
SQLStatement	parseCreateRole()
SQLStatement	parseCreateSchema()
SQLStatement	parseCreateSequence(boolean acceptCreate)
SQLStatement	parseCreateSynonym()
SQLCreateTableStatement	parseCreateTable()
SQLStatement	parseCreateTableGroup()
SQLStatement	parseCreateTrigger()
SQLStatement	parseCreateType()
SQLStatement	parseCreateUser()
SQLCreateViewStatement	parseCreateView()
SQLStatement	parseDeclare()
SQLDeleteStatement	parseDeleteStatement()
SQLStatement	parseDescribe()
SQLStatement	parseDrop()
protected SQLStatement	parseDropCatalog()
protected SQLDropStatement	parseDropDatabaseOrSchema(boolean acceptDrop)
protected SQLStatement	parseDropEvent()
protected SQLDropFunctionStatement	parseDropFunction(boolean acceptDrop)
SQLStatement	parseDropIndex()
protected SQLStatement	parseDropLogFileGroup()
SQLStatement	parseDropMaterializedView()
SQLStatement	parseDropOfflineModel()
protected SQLStatement	parseDropOutline()
protected SQLDropProcedureStatement	parseDropProcedure(boolean acceptDrop)
protected SQLStatement	parseDropResource()
protected SQLStatement	parseDropRole()
protected SQLDropStatement	parseDropSchema()
protected SQLDropSequenceStatement	parseDropSequence(boolean acceptDrop)
protected SQLStatement	parseDropServer()
protected SQLDropTableStatement	parseDropTable(boolean acceptDrop)
protected SQLStatement	parseDropTableGroup()
protected SQLDropTableSpaceStatement	parseDropTablespace(boolean acceptDrop)
protected SQLDropTriggerStatement	parseDropTrigger(boolean acceptDrop)
SQLDropUserStatement	parseDropUser()
protected SQLDropViewStatement	parseDropView(boolean acceptDrop)
SQLStatement	parseDump()
protected SQLErrorLoggingClause	parseErrorLoggingClause()
SQLExplainStatement	parseExplain()
SQLFetchStatement	parseFetch()
SQLStatement	parseFlashback()
SQLStatement	parseFor()
protected FullTextType	parseFullTextType()
SQLGrantStatement	parseGrant()
void	parseHints(List<SQLHint> hints)
SQLCreateFunctionStatement	parseHiveCreateFunction()
protected HiveInsert	parseHiveInsert()
protected HiveInsertStatement	parseHiveInsertStmt()
SQLStatement	parseIf()
SQLStatement	parseInsert()
protected void	parseInsert0(SQLInsertInto insertStatement)
protected void	parseInsert0(SQLInsertInto insertStatement, boolean acceptSubQuery)
protected void	parseInsert0_hinits(SQLInsertInto insertStatement)
protected void	parseInsertColumns(SQLInsertInto insert)
SQLStatement	parseKill()
SQLStatement	parseLeave()
SQLStatement	parseList()
SQLStatement	parseMerge()
protected SQLStatement	parseMsck()
SQLOpenStatement	parseOpen()	parse cursor open statement
SQLStatement	parseOptimize()
SQLPartitionRef	parsePartitionRef()
protected void	parsePrivileages(List<SQLPrivilegeItem> privileges, SQLObject parent)
SQLStatement	parsePurge()
SQLStatement	parseRefresh()
SQLStatement	parseReleaseSavePoint()
SQLStatement	parseRename()
SQLStatement	parseRepeat()
SQLStatement	parseReturn()
SQLRevokeStatement	parseRevoke()
SQLStatement	parseRollback()
SQLStatement	parseSavePoint()
SQLStatement	parseSelect()
SQLStatement	parseSet()
SQLStatement	parseShow()
protected SQLShowColumnsStatement	parseShowColumns()
protected SQLShowCreateTableStatement	parseShowCreateTable()
protected SQLShowDatabasesStatement	parseShowDatabases(boolean isPhysical)
SQLStatement	parseShowMaterializedView()
protected SQLShowTableGroupsStatement	parseShowTableGroups()
protected SQLShowTablesStatement	parseShowTables()
SQLShowVariantsStatement	parseShowVariants()
SQLStatement	parseStatement()
SQLStatement	parseStatement(boolean tryBest)
List<SQLStatement>	parseStatementList()
List<SQLStatement>	parseStatementList(SQLObject parent)
void	parseStatementList(List<SQLStatement> statementList)
void	parseStatementList(List<SQLStatement> statementList, int max)
void	parseStatementList(List<SQLStatement> statementList, int max, SQLObject parent)
boolean	parseStatementListDialect(List<SQLStatement> statementList)
SQLStatement	parseTruncate()
protected void	parseUpdateSet(SQLUpdateStatement update)
SQLUpdateStatement	parseUpdateStatement()
SQLStatement	parseUpsert()
SQLUseStatement	parseUse()
protected SQLExpr	parseUser()
void	parseValueClause(SQLInsertValueHandler valueHandler)
protected void	parseValueClause(List<SQLInsertStatement.ValuesClause> valueClauseList, int columnSize, SQLObject parent)
protected void	parseValueClause(List<SQLInsertStatement.ValuesClause> valueClauseList, List<SQLColumnDefinition> columnDefinitionList, int columnSize, SQLObject parent)
protected void	parseValueClauseNative(List<SQLInsertStatement.ValuesClause> valueClauseList, List<SQLColumnDefinition> columnDefinitionList, int columnSize, SQLObject parent)
SQLStatement	parseWhile()
protected SQLStatement	parseWhoami()
SQLStatement	parseWith()
SQLWithSubqueryClause	parseWithQuery()
void	setKeepComments(boolean keepComments)
void	setParseCompleteValues(boolean parseCompleteValues)
void	setParseValuesSize(int parseValuesSize)
void	setRepository(SchemaRepository repository)
void	setSelectListCache(SQLSelectListCache selectListCache)

Methods inherited from class com.alibaba.druid.sql.parser.SQLParser

accept, acceptIdentifier, acceptInteger, alias, as, config, getDbType, getLexer, getTimeZone, identifierEquals, isEnabled, match, newCreateStatement, printError, setErrorEndPos, setTimeZone, tableAlias, tableAlias

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

repository

protected SchemaRepository repository

exprParser

protected SQLExprParser exprParser

parseCompleteValues

protected boolean parseCompleteValues

parseValuesSize

protected int parseValuesSize

selectListCache

protected SQLSelectListCache selectListCache

insertColumnsCache

protected InsertColumnsCache insertColumnsCache

now

protected Timestamp now

currentDate

protected Date currentDate

Constructor Details

SQLStatementParser

public SQLStatementParser(String sql)

SQLStatementParser

public SQLStatementParser(String sql,
 DbType dbType)

SQLStatementParser

public SQLStatementParser(SQLExprParser exprParser)

SQLStatementParser

protected SQLStatementParser(Lexer lexer,
 DbType dbType)

Method Details

isKeepComments

public boolean isKeepComments()

setKeepComments

public void setKeepComments(boolean keepComments)

getExprParser

public SQLExprParser getExprParser()

getRepository

public SchemaRepository getRepository()

setRepository

public void setRepository(SchemaRepository repository)

parseStatementList

public List<SQLStatement> parseStatementList()

parseStatementList

public List<SQLStatement> parseStatementList(SQLObject parent)

parseStatementList

public void parseStatementList(List<SQLStatement> statementList)

parseStatementList

public void parseStatementList(List<SQLStatement> statementList,
 int max)

parseStatementList

public void parseStatementList(List<SQLStatement> statementList,
 int max,
 SQLObject parent)

parseOptimize

public SQLStatement parseOptimize()

parseCopy

public SQLStatement parseCopy()

parseFor

public SQLStatement parseFor()

parseFlashback

public SQLStatement parseFlashback()

parseDump

public SQLStatement parseDump()

parseDrop

public SQLStatement parseDrop()

parseFullTextType

protected FullTextType parseFullTextType()

parseWhoami

protected SQLStatement parseWhoami()

parseDropOutline

protected SQLStatement parseDropOutline()

parseRefresh

public SQLStatement parseRefresh()

parseShowMaterializedView

public SQLStatement parseShowMaterializedView()

parseDropMaterializedView

public SQLStatement parseDropMaterializedView()

parseDropOfflineModel

public SQLStatement parseDropOfflineModel()

parseDropCatalog

protected SQLStatement parseDropCatalog()

parseDropRole

protected SQLStatement parseDropRole()

parseDropTableGroup

protected SQLStatement parseDropTableGroup()

parseDropServer

protected SQLStatement parseDropServer()

parseDropLogFileGroup

protected SQLStatement parseDropLogFileGroup()

parseDropEvent

protected SQLStatement parseDropEvent()

parseDropResource

protected SQLStatement parseDropResource()

parseAlterFunction

protected SQLStatement parseAlterFunction()

parseKill

public SQLStatement parseKill()

parseCase

public SQLStatement parseCase()

parseIf

public SQLStatement parseIf()

parseWhile

public SQLStatement parseWhile()

parseDeclare

public SQLStatement parseDeclare()

parseRepeat

public SQLStatement parseRepeat()

parseLeave

public SQLStatement parseLeave()

parsePurge

public SQLStatement parsePurge()

parseReturn

public SQLStatement parseReturn()

parseUpsert

public SQLStatement parseUpsert()

parseRollback

public SQLStatement parseRollback()

parseCommit

public SQLStatement parseCommit()

parseShow

public SQLStatement parseShow()

parseUse

public SQLUseStatement parseUse()

parseUser

protected SQLExpr parseUser()

parseGrant

public SQLGrantStatement parseGrant()

parsePrivileages

protected void parsePrivileages(List<SQLPrivilegeItem> privileges,
 SQLObject parent)

parseRevoke

public SQLRevokeStatement parseRevoke()

parseSavePoint

public SQLStatement parseSavePoint()

parseReleaseSavePoint

public SQLStatement parseReleaseSavePoint()

parseAlter

public SQLStatement parseAlter()

parseAlterDatabase

protected SQLStatement parseAlterDatabase()

parseAlterSchema

protected SQLStatement parseAlterSchema()

parseAlterTableRename

protected SQLAlterTableItem parseAlterTableRename()

parseAlterColumn

protected SQLAlterTableAlterColumn parseAlterColumn()

parseAlterDrop

public void parseAlterDrop(SQLAlterTableStatement stmt)

parseAlterTableDropPartition

protected SQLAlterTableDropPartition parseAlterTableDropPartition(boolean ifExists)

parseAlterTableDropSubpartition

protected SQLAlterTableDropSubpartition parseAlterTableDropSubpartition()

parseRename

public SQLStatement parseRename()

parseList

public SQLStatement parseList()

parseDropTable

protected SQLDropTableStatement parseDropTable(boolean acceptDrop)

parseDropSequence

protected SQLDropSequenceStatement parseDropSequence(boolean acceptDrop)

parseDropTrigger

protected SQLDropTriggerStatement parseDropTrigger(boolean acceptDrop)

parseDropView

protected SQLDropViewStatement parseDropView(boolean acceptDrop)

parseDropSchema

protected SQLDropStatement parseDropSchema()

parseDropDatabaseOrSchema

protected SQLDropStatement parseDropDatabaseOrSchema(boolean acceptDrop)

parseDropFunction

protected SQLDropFunctionStatement parseDropFunction(boolean acceptDrop)

parseDropTablespace

protected SQLDropTableSpaceStatement parseDropTablespace(boolean acceptDrop)

parseDropProcedure

protected SQLDropProcedureStatement parseDropProcedure(boolean acceptDrop)

parseTruncate

public SQLStatement parseTruncate()

parseInsert

public SQLStatement parseInsert()

parseInsert0

protected void parseInsert0(SQLInsertInto insertStatement)

parseInsert0_hinits

protected void parseInsert0_hinits(SQLInsertInto insertStatement)

parseInsert0

protected void parseInsert0(SQLInsertInto insertStatement,
 boolean acceptSubQuery)

parseInsertColumns

protected void parseInsertColumns(SQLInsertInto insert)

parseStatementListDialect

public boolean parseStatementListDialect(List<SQLStatement> statementList)

parseDropUser

public SQLDropUserStatement parseDropUser()

parseDropIndex

public SQLStatement parseDropIndex()

parseCall

public SQLCallStatement parseCall()

parseSet

public SQLStatement parseSet()

parseAssignItems

public void parseAssignItems(List<? super SQLAssignItem> items,
 SQLObject parent)

parseAssignItems

public void parseAssignItems(List<? super SQLAssignItem> items,
 SQLObject parent,
 boolean variant)

parsePartitionRef

public SQLPartitionRef parsePartitionRef()

parseCreatePackage

public SQLStatement parseCreatePackage()

parseCreate

public SQLStatement parseCreate()

parseCreateRole

public SQLStatement parseCreateRole()

parseCreateType

public SQLStatement parseCreateType()

parseCreateTableGroup

public SQLStatement parseCreateTableGroup()

parseCreateUser

public SQLStatement parseCreateUser()

parseCreateFunction

public SQLCreateFunctionStatement parseCreateFunction()

parseCreateMaterializedView

public SQLStatement parseCreateMaterializedView()

parseCreateDbLink

public SQLStatement parseCreateDbLink()

parseCreateSynonym

public SQLStatement parseCreateSynonym()

parseCreateExternalCatalog

public SQLStatement parseCreateExternalCatalog()

parseCreateTrigger

public SQLStatement parseCreateTrigger()

parseBlock

public SQLStatement parseBlock()

parseCreateSchema

public SQLStatement parseCreateSchema()

parseCreateDatabase

public SQLStatement parseCreateDatabase()

parseCreateProcedure

public SQLCreateProcedureStatement parseCreateProcedure()

parseCreateSequence

public SQLStatement parseCreateSequence(boolean acceptCreate)

parseCreateIndex

public SQLCreateIndexStatement parseCreateIndex(boolean acceptCreate)

getSQLCreateTableParser

public SQLCreateTableParser getSQLCreateTableParser()

parseSelect

public SQLStatement parseSelect()

createSQLSelectParser

public SQLSelectParser createSQLSelectParser()

createSQLSelectParser

public SQLSelectParser createSQLSelectParser(SQLExprParser exprParser)

parseUpdateStatement

public SQLUpdateStatement parseUpdateStatement()

parseUpdateSet

protected void parseUpdateSet(SQLUpdateStatement update)

createUpdateStatement

protected SQLUpdateStatement createUpdateStatement()

parseDeleteStatement

public SQLDeleteStatement parseDeleteStatement()

parseCreateTable

public SQLCreateTableStatement parseCreateTable()

parseCreateView

public SQLCreateViewStatement parseCreateView()

parseComment

public SQLCommentStatement parseComment()

parseAlterTableAddColumn

protected SQLAlterTableAddColumn parseAlterTableAddColumn()

parseAlterTableReplaceColumn

protected SQLAlterTableReplaceColumn parseAlterTableReplaceColumn()

parseStatement

public SQLStatement parseStatement()

parseStatement

public SQLStatement parseStatement(boolean tryBest)

Parameters:

tryBest - - 为true去解析并忽略之后的错误 强制建议除非明确知道可以忽略才传tryBest=true, 不然会忽略语法错误，且截断sql,导致update和delete无where条件下执行！！！

parseExplain

public SQLExplainStatement parseExplain()

parseAlterTableAddClusteringKey

protected SQLAlterTableAddClusteringKey parseAlterTableAddClusteringKey()

parseOpen

public SQLOpenStatement parseOpen()

parse cursor open statement

Returns:

parseFetch

public SQLFetchStatement parseFetch()

parseClose

public SQLStatement parseClose()

isParseCompleteValues

public boolean isParseCompleteValues()

setParseCompleteValues

public void setParseCompleteValues(boolean parseCompleteValues)

getParseValuesSize

public int getParseValuesSize()

setParseValuesSize

public void setParseValuesSize(int parseValuesSize)

parseMerge

public SQLStatement parseMerge()

parseErrorLoggingClause

protected SQLErrorLoggingClause parseErrorLoggingClause()

parseHints

public void parseHints(List<SQLHint> hints)

parseDescribe

public SQLStatement parseDescribe()

parseWithQuery

public SQLWithSubqueryClause parseWithQuery()

parseWith

public SQLStatement parseWith()

parseValueClause

protected void parseValueClause(List<SQLInsertStatement.ValuesClause> valueClauseList,
 int columnSize,
 SQLObject parent)

parseValueClauseNative

protected void parseValueClauseNative(List<SQLInsertStatement.ValuesClause> valueClauseList,
 List<SQLColumnDefinition> columnDefinitionList,
 int columnSize,
 SQLObject parent)

parseValueClause

public void parseValueClause(SQLInsertValueHandler valueHandler)
                      throws SQLException

Throws:

SQLException

parseValueClause

protected void parseValueClause(List<SQLInsertStatement.ValuesClause> valueClauseList,
 List<SQLColumnDefinition> columnDefinitionList,
 int columnSize,
 SQLObject parent)

getSelectListCache

public SQLSelectListCache getSelectListCache()

setSelectListCache

public void setSelectListCache(SQLSelectListCache selectListCache)

parseHiveInsertStmt

protected HiveInsertStatement parseHiveInsertStmt()

parseHiveInsert

protected HiveInsert parseHiveInsert()

parseShowDatabases

protected SQLShowDatabasesStatement parseShowDatabases(boolean isPhysical)

parseShowTableGroups

protected SQLShowTableGroupsStatement parseShowTableGroups()

parseShowTables

protected SQLShowTablesStatement parseShowTables()

parseShowColumns

protected SQLShowColumnsStatement parseShowColumns()

parseAlterIndex

protected SQLStatement parseAlterIndex()

parseAnalyze

protected SQLStatement parseAnalyze()

parseAlterSequence

public SQLAlterSequenceStatement parseAlterSequence()

parseMsck

protected SQLStatement parseMsck()

parseCreateResourceGroup

protected SQLStatement parseCreateResourceGroup()

parseAlterResourceGroup

protected SQLStatement parseAlterResourceGroup()

parseAlterMaterialized

public SQLStatement parseAlterMaterialized()

parseHiveCreateFunction

public SQLCreateFunctionStatement parseHiveCreateFunction()

parseShowCreateTable

protected SQLShowCreateTableStatement parseShowCreateTable()

parseShowVariants

public SQLShowVariantsStatement parseShowVariants()

parseClone

public SQLStatement parseClone()