Package com.alibaba.druid.util
Class JdbcUtils
java.lang.Object
com.alibaba.druid.util.JdbcUtils
- All Implemented Interfaces:
JdbcConstants
- Author:
- wenshao [[email protected]]
-
Field Summary
Fields inherited from interface com.alibaba.druid.util.JdbcConstants
ALI_ORACLE, ALI_ORACLE_DRIVER, ALIYUN_ADS, ALIYUN_DRDS, CLICKHOUSE, CLICKHOUSE_DRIVER, DB2, DB2_DRIVER, DB2_DRIVER2, DB2_DRIVER3, DERBY, DM, DM_DRIVER, ELASTIC_SEARCH, ELASTIC_SEARCH_DRIVER, ENTERPRISEDB, ENTERPRISEDB_DRIVER, GBASE, GBASE_DRIVER, GREENPLUM, GREENPLUM_DRIVER, H2, H2_DRIVER, HBASE, HIVE, HIVE_DRIVER, HSQL, INFORMIX, JTDS, KDB, KDB_DRIVER, KINGBASE, KINGBASE_DRIVER, KINGBASE8_DRIVER, KYLIN, KYLIN_DRIVER, LOG4JDBC, LOG4JDBC_DRIVER, MARIADB, MARIADB_DRIVER, MOCK, MYSQL, MYSQL_DRIVER, MYSQL_DRIVER_6, MYSQL_DRIVER_REPLICATE, OCEANBASE, OCEANBASE_DRIVER, OCEANBASE_DRIVER2, OCEANBASE_ORACLE, ODPS, ODPS_DRIVER, ORACLE, ORACLE_DRIVER, ORACLE_DRIVER2, OSCAR, OSCAR_DRIVER, PHOENIX, PHOENIX_DRIVER, POLARDB, POLARDB_DRIVER, POSTGRESQL, POSTGRESQL_DRIVER, PRESTO, PRESTO_DRIVER, SQL_SERVER, SQL_SERVER_DRIVER, SQL_SERVER_DRIVER_JTDS, SQL_SERVER_DRIVER_SQLJDBC4, SQLITE, SQLITE_DRIVER, SYBASE, TERADATA, TERADATA_DRIVER, TIDB, TIDB_DRIVER, TRINO, TRINO_DRIVER, TYDB, TYDB_DRIVER, XUGU, XUGU_DRIVER
-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionstatic void
static void
static void
static void
close
(Connection x) static void
static void
static Driver
createDriver
(ClassLoader classLoader, String driverClassName) static Driver
createDriver
(String driverClassName) static void
execute
(Connection conn, String sql) static void
execute
(Connection conn, String sql, List<Object> parameters) static void
execute
(DataSource dataSource, String sql, Object... parameters) static void
execute
(DataSource dataSource, String sql, List<Object> parameters) executeQuery
(Connection conn, String sql, List<Object> parameters) static <T> void
executeQuery
(DataSource dataSource, ResultSetConsumer<T> consumer, String sql, Object... parameters) executeQuery
(DataSource dataSource, String sql, Object... parameters) executeQuery
(DataSource dataSource, String sql, List<Object> parameters) static int
executeUpdate
(Connection conn, String sql, List<Object> parameters) static int
executeUpdate
(DataSource dataSource, String sql, Object... parameters) static int
executeUpdate
(DataSource dataSource, String sql, List<Object> parameters) static String
getCreateTableScript
(Connection conn, DbType dbType) static String
getCreateTableScript
(Connection conn, DbType dbType, boolean sorted, boolean simplify) static String
static DbType
getDbTypeRaw
(String rawUrl, String driverClassName) static String
getDriverClassName
(String rawUrl) static String
getTypeName
(int sqlType) static void
insertToTable
(Connection conn, String tableName, Map<String, Object> data) static void
insertToTable
(DataSource dataSource, String tableName, Map<String, Object> data) static boolean
isMysqlDbType
(DbType dbType) static boolean
isMysqlDbType
(String dbTypeName) static boolean
isMySqlDriver
(String driverClassName) static boolean
isOracleDbType
(DbType dbType) static boolean
isOracleDbType
(String dbType) static boolean
isPgsqlDbType
(DbType dbType) static boolean
isPgsqlDbType
(String dbTypeName) static boolean
isSqlserverDbType
(DbType dbType) static boolean
isSqlserverDbType
(String dbTypeName) static String
makeInsertToTableSql
(String tableName, Collection<String> names) static void
static void
printResultSet
(ResultSet rs, PrintStream out) static void
printResultSet
(ResultSet rs, PrintStream out, boolean printHeader, String seperator) showTables
(Connection conn, DbType dbType)
-
Constructor Details
-
JdbcUtils
public JdbcUtils()
-
-
Method Details
-
close
-
close
-
close
-
close
-
close
-
close
-
printResultSet
- Throws:
SQLException
-
printResultSet
- Throws:
SQLException
-
printResultSet
public static void printResultSet(ResultSet rs, PrintStream out, boolean printHeader, String seperator) throws SQLException - Throws:
SQLException
-
getTypeName
-
getDriverClassName
- Throws:
SQLException
-
getDbTypeRaw
-
getDbType
-
createDriver
- Throws:
SQLException
-
createDriver
public static Driver createDriver(ClassLoader classLoader, String driverClassName) throws SQLException - Throws:
SQLException
-
executeUpdate
public static int executeUpdate(DataSource dataSource, String sql, Object... parameters) throws SQLException - Throws:
SQLException
-
executeUpdate
public static int executeUpdate(DataSource dataSource, String sql, List<Object> parameters) throws SQLException - Throws:
SQLException
-
executeUpdate
public static int executeUpdate(Connection conn, String sql, List<Object> parameters) throws SQLException - Throws:
SQLException
-
execute
public static void execute(DataSource dataSource, String sql, Object... parameters) throws SQLException - Throws:
SQLException
-
execute
public static void execute(DataSource dataSource, String sql, List<Object> parameters) throws SQLException - Throws:
SQLException
-
execute
- Throws:
SQLException
-
execute
public static void execute(Connection conn, String sql, List<Object> parameters) throws SQLException - Throws:
SQLException
-
executeQuery
public static List<Map<String,Object>> executeQuery(DataSource dataSource, String sql, Object... parameters) throws SQLException - Throws:
SQLException
-
executeQuery
public static List<Map<String,Object>> executeQuery(DataSource dataSource, String sql, List<Object> parameters) throws SQLException - Throws:
SQLException
-
executeQuery
public static List<Map<String,Object>> executeQuery(Connection conn, String sql, List<Object> parameters) throws SQLException - Throws:
SQLException
-
insertToTable
public static void insertToTable(DataSource dataSource, String tableName, Map<String, Object> data) throws SQLException- Throws:
SQLException
-
insertToTable
public static void insertToTable(Connection conn, String tableName, Map<String, Object> data) throws SQLException- Throws:
SQLException
-
makeInsertToTableSql
-
executeQuery
public static <T> void executeQuery(DataSource dataSource, ResultSetConsumer<T> consumer, String sql, Object... parameters) throws SQLException - Throws:
SQLException
-
showTables
- Throws:
SQLException
-
getCreateTableScript
- Throws:
SQLException
-
getCreateTableScript
public static String getCreateTableScript(Connection conn, DbType dbType, boolean sorted, boolean simplify) throws SQLException - Throws:
SQLException
-
isMySqlDriver
-
isOracleDbType
-
isOracleDbType
-
isMysqlDbType
-
isMysqlDbType
-
isPgsqlDbType
-
isPgsqlDbType
-
isSqlserverDbType
-
isSqlserverDbType
-