com.jn.sqlhelper.common.utils

类 SQLs

java.lang.Object

com.jn.sqlhelper.common.utils.SQLs

public class SQLs
extends Object

字段概要

字段

限定符和类型	字段和说明
static String	SQL_FILE_SUFFIX
static String	WHITESPACE

构造器概要

构造器

构造器和说明
SQLs()

方法概要

限定符和类型	方法和说明
static int	findPlaceholderParameterCount(String sqlsegment)
static String	getTableFQN(DatabaseDescription databaseDesc, String catalog, String schema, String tableName)
static String	getTableFQN(DatabaseMetaData metaData, String catalog, String schema, String tableName)
static String	getTableFQN(String catalog, String schema, String tableName)
static String	getTableFQN(String catalog, String schema, String tableName, boolean catalogAtStart)
static String	getTableFQN(String catalog, String schema, String tableName, String separator, boolean catalogAtStart)
static boolean	isCreateStatement(String sql)
static boolean	isDeleteStatement(String sql)
static boolean	isDropTableStatement(String sql)
static boolean	isInsertStatement(String sql)
static boolean	isQuote(String tok)
static boolean	isSelectCountStatement(String sql)
static boolean	isSelectStatement(String sql)
static boolean	isSupportsBatchUpdates(Connection conn)
static boolean	isUpdateStatement(String sql)

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

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

字段详细资料

WHITESPACE

public static final String WHITESPACE

另请参阅:

常量字段值

SQL_FILE_SUFFIX

public static final String SQL_FILE_SUFFIX

另请参阅:

常量字段值

构造器详细资料

SQLs

public SQLs()

方法详细资料

getTableFQN

public static String getTableFQN(String catalog,
                                 String schema,
                                 String tableName)

getTableFQN

public static String getTableFQN(String catalog,
                                 String schema,
                                 String tableName,
                                 boolean catalogAtStart)

getTableFQN

public static String getTableFQN(String catalog,
                                 String schema,
                                 String tableName,
                                 String separator,
                                 boolean catalogAtStart)

getTableFQN

public static String getTableFQN(DatabaseMetaData metaData,
                                 String catalog,
                                 String schema,
                                 String tableName)

getTableFQN

public static String getTableFQN(DatabaseDescription databaseDesc,
                                 String catalog,
                                 String schema,
                                 String tableName)

findPlaceholderParameterCount

public static int findPlaceholderParameterCount(String sqlsegment)

isSelectStatement

public static boolean isSelectStatement(String sql)

isSelectCountStatement

public static boolean isSelectCountStatement(String sql)

isUpdateStatement

public static boolean isUpdateStatement(String sql)

isDeleteStatement

public static boolean isDeleteStatement(String sql)

isInsertStatement

public static boolean isInsertStatement(String sql)

isCreateStatement

public static boolean isCreateStatement(String sql)

isDropTableStatement

public static boolean isDropTableStatement(String sql)

isQuote

public static boolean isQuote(String tok)

isSupportsBatchUpdates

public static boolean isSupportsBatchUpdates(Connection conn)