程序包 gu.sql2java.parser

类 StatementCache

java.lang.Object

gu.sql2java.parser.StatementCache

public class StatementCache
extends Object

基于LoadingCache实现SQL语句解析格式化缓存，提高SQL语句分析的效率

作者:

guyadong

构造器概要

构造器

构造器	说明
StatementCache()
StatementCache(SqlFormatter sqlFormatter, SqlSyntaxNormalizer sqlSyntaxNormalizer)
StatementCache(net.sf.jsqlparser.parser.CCJSqlParserDefaultVisitor vistor, SqlSyntaxNormalizer sqlSyntaxNormalizer)
StatementCache(net.sf.jsqlparser.parser.CCJSqlParserVisitor vistor, SqlSyntaxNormalizer sqlSyntaxNormalizer)

方法概要

修饰符和类型	方法	说明
StatementCache	injectCheckEnable(boolean enable)
String	normalize(String sql, boolean injectAnalyze)	解析SQL语句，解析成功则返回由visitor归一化处理后的SQL语句, 否则将解析异常JSQLParserException封装到RuntimeDaoException抛出
ParserSupport.SqlParserInfo	parse(String sql, boolean injectAnalyze)	解析SQL语句，解析成功返回保存解析数据的ParserSupport.SqlParserInfo对象, 否则将解析异常JSQLParserException封装到RuntimeDaoException抛出
PreparedStatement	prepareStatement(Connection c, String sql, boolean injectAnalyze, boolean debug, String logPrefix)	调用Connection.prepareStatement(String)创建预编译SQL语句PreparedStatement对象, 调用前执行normalize(String, boolean)方法对SQL语句进行归一化处理和安全检查
PreparedStatement	prepareStatement(Connection c, String sql, boolean injectAnalyze, boolean debug, String logPrefix, int autoGeneratedKeys)	调用Connection.prepareStatement(String, int)创建预编译SQL语句PreparedStatement对象, 调用前执行normalize(String, boolean)方法对SQL语句进行归一化处理和安全检查
PreparedStatement	prepareStatement(Connection c, String sql, boolean injectAnalyze, boolean debug, String logPrefix, int resultSetType, int resultSetConcurrency)	调用Connection.prepareStatement(String, int, int)创建预编译SQL语句PreparedStatement对象, 调用前执行normalize(String, boolean)方法对SQL语句进行归一化处理和安全检查

从类继承的方法 java.lang.Object

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

构造器详细资料

StatementCache

public StatementCache()

StatementCache

public StatementCache(net.sf.jsqlparser.parser.CCJSqlParserDefaultVisitor vistor,
 SqlSyntaxNormalizer sqlSyntaxNormalizer)

StatementCache

public StatementCache(net.sf.jsqlparser.parser.CCJSqlParserVisitor vistor,
 SqlSyntaxNormalizer sqlSyntaxNormalizer)

StatementCache

public StatementCache(SqlFormatter sqlFormatter,
 SqlSyntaxNormalizer sqlSyntaxNormalizer)

方法详细资料

injectCheckEnable

public StatementCache injectCheckEnable(boolean enable)

parse

public ParserSupport.SqlParserInfo parse(String sql,
 boolean injectAnalyze)

解析SQL语句，解析成功返回保存解析数据的ParserSupport.SqlParserInfo对象, 否则将解析异常JSQLParserException封装到RuntimeDaoException抛出

参数:

sql -

injectAnalyze - 为true执行注入攻击分析

normalize

public String normalize(String sql,
 boolean injectAnalyze)

解析SQL语句，解析成功则返回由visitor归一化处理后的SQL语句, 否则将解析异常JSQLParserException封装到RuntimeDaoException抛出

参数:

sql -

injectAnalyze - 为true执行注入攻击分析

prepareStatement

public PreparedStatement prepareStatement(Connection c,
 String sql,
 boolean injectAnalyze,
 boolean debug,
 String logPrefix,
 int resultSetType,
 int resultSetConcurrency)
                                   throws SQLException

调用Connection.prepareStatement(String, int, int)创建预编译SQL语句PreparedStatement对象, 调用前执行normalize(String, boolean)方法对SQL语句进行归一化处理和安全检查

参数:

c - SQL connection

sql - sql statement

injectAnalyze - run injection attack analysis if true

debug - output SQL statement to console if true

logPrefix - prefix string for debug information

resultSetType - see also Connection.prepareStatement(String, int, int)

resultSetConcurrency - see also Connection.prepareStatement(String, int, int)

抛出:

SQLException

另请参阅:

• Connection.prepareStatement(String, int, int)

prepareStatement

public PreparedStatement prepareStatement(Connection c,
 String sql,
 boolean injectAnalyze,
 boolean debug,
 String logPrefix,
 int autoGeneratedKeys)
                                   throws SQLException

调用Connection.prepareStatement(String, int)创建预编译SQL语句PreparedStatement对象, 调用前执行normalize(String, boolean)方法对SQL语句进行归一化处理和安全检查

参数:

c - SQL connection

sql - sql statement

injectAnalyze - run injection attack analysis if true

debug - output SQL statement to console if true

logPrefix - prefix string for debug information

autoGeneratedKeys - see also Connection.prepareStatement(String, int)

抛出:

SQLException

另请参阅:

• Connection.prepareStatement(String, int)

prepareStatement

public PreparedStatement prepareStatement(Connection c,
 String sql,
 boolean injectAnalyze,
 boolean debug,
 String logPrefix)
                                   throws SQLException

调用Connection.prepareStatement(String)创建预编译SQL语句PreparedStatement对象, 调用前执行normalize(String, boolean)方法对SQL语句进行归一化处理和安全检查

参数:

c - SQL connection

sql - sql statement

injectAnalyze - run injection attack analysis if true

debug - output SQL statement to console if true

logPrefix - prefix string for debug information

抛出:

SQLException

另请参阅:

• Connection.prepareStatement(String)