public final class JdbcUtils extends Object implements JdbcConstants
ALI_ORACLE, ALI_ORACLE_DRIVER, DB2, DB2_DRIVER, DERBY, DM, DM_DRIVER, ENTERPRISEDB, ENTERPRISEDB_DRIVER, H2, H2_DRIVER, HBASE, HIVE, HIVE_DRIVER, HSQL, INFORMIX, JTDS, KINGBASE, KINGBASE_DRIVER, LOG4JDBC, LOG4JDBC_DRIVER, MARIADB, MARIADB_DRIVER, MOCK, MYSQL, MYSQL_DRIVER, MYSQL_DRIVER_6, OCEANBASE, OCEANBASE_DRIVER, ODPS, ODPS_DRIVER, ORACLE, ORACLE_DRIVER, PHOENIX, PHOENIX_DRIVER, POSTGRESQL, POSTGRESQL_DRIVER, SQL_SERVER, SQL_SERVER_DRIVER, SQL_SERVER_DRIVER_JTDS, SQL_SERVER_DRIVER_SQLJDBC4, SQLITE, SQLITE_DRIVER, SYBASE, TERADATA, TERADATA_DRIVER
Constructor and Description |
---|
JdbcUtils() |
Modifier and Type | Method and Description |
---|---|
static void |
close(Closeable x) |
static void |
close(Connection x) |
static void |
close(ResultSet x) |
static void |
close(Statement x) |
static Driver |
createDriver(ClassLoader classLoader,
String driverClassName) |
static Driver |
createDriver(String driverClassName) |
static void |
execute(Connection conn,
String sql,
List<Object> parameters) |
static void |
execute(DataSource dataSource,
String sql,
List<Object> parameters) |
static void |
execute(DataSource dataSource,
String sql,
Object... parameters) |
static List<Map<String,Object>> |
executeQuery(Connection conn,
String sql,
List<Object> parameters) |
static List<Map<String,Object>> |
executeQuery(DataSource dataSource,
String sql,
List<Object> parameters) |
static List<Map<String,Object>> |
executeQuery(DataSource dataSource,
String sql,
Object... parameters) |
static int |
executeUpdate(Connection conn,
String sql,
List<Object> parameters) |
static int |
executeUpdate(DataSource dataSource,
String sql,
List<Object> parameters) |
static int |
executeUpdate(DataSource dataSource,
String sql,
Object... parameters) |
static String |
getDbType(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 String |
makeInsertToTableSql(String tableName,
Collection<String> names) |
static void |
printResultSet(ResultSet rs) |
static void |
printResultSet(ResultSet rs,
PrintStream out) |
static void |
printResultSet(ResultSet rs,
PrintStream out,
boolean printHeader,
String seperator) |
public static void close(Connection x)
public static void close(Statement x)
public static void close(ResultSet x)
public static void close(Closeable x)
public static void printResultSet(ResultSet rs) throws SQLException
SQLException
public static void printResultSet(ResultSet rs, PrintStream out) throws SQLException
SQLException
public static void printResultSet(ResultSet rs, PrintStream out, boolean printHeader, String seperator) throws SQLException
SQLException
public static String getTypeName(int sqlType)
public static String getDriverClassName(String rawUrl) throws SQLException
SQLException
public static Driver createDriver(String driverClassName) throws SQLException
SQLException
public static Driver createDriver(ClassLoader classLoader, String driverClassName) throws SQLException
SQLException
public static int executeUpdate(DataSource dataSource, String sql, Object... parameters) throws SQLException
SQLException
public static int executeUpdate(DataSource dataSource, String sql, List<Object> parameters) throws SQLException
SQLException
public static int executeUpdate(Connection conn, String sql, List<Object> parameters) throws SQLException
SQLException
public static void execute(DataSource dataSource, String sql, Object... parameters) throws SQLException
SQLException
public static void execute(DataSource dataSource, String sql, List<Object> parameters) throws SQLException
SQLException
public static void execute(Connection conn, String sql, List<Object> parameters) throws SQLException
SQLException
public static List<Map<String,Object>> executeQuery(DataSource dataSource, String sql, Object... parameters) throws SQLException
SQLException
public static List<Map<String,Object>> executeQuery(DataSource dataSource, String sql, List<Object> parameters) throws SQLException
SQLException
public static List<Map<String,Object>> executeQuery(Connection conn, String sql, List<Object> parameters) throws SQLException
SQLException
public static void insertToTable(DataSource dataSource, String tableName, Map<String,Object> data) throws SQLException
SQLException
public static void insertToTable(Connection conn, String tableName, Map<String,Object> data) throws SQLException
SQLException
public static String makeInsertToTableSql(String tableName, Collection<String> names)
Copyright © 2013–2017 Alibaba Group. All rights reserved.