com.alibaba.druid.util

类 JdbcUtils

java.lang.Object

com.alibaba.druid.util.JdbcUtils

public final class JdbcUtils
extends Object

作者:

wenshao

字段概要

字段

限定符和类型	字段和说明
static String	DB2
static String	DERBY
static String	H2
static String	HBASE
static String	HIVE
static String	HSQL
static String	MOCK
static String	MYSQL
static String	ORACLE
static String	POSTGRESQL
static String	SQL_SERVER
static String	SYBASE

构造器概要

构造器

构造器和说明
JdbcUtils()

方法概要

方法

限定符和类型	方法和说明
static void	close(Closeable x)
static void	close(Connection x)
static void	close(ResultSet x)
static void	close(Statement x)
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 Class<?>	loadDriverClass(String className)
static String	makeInsertToTableSql(String tableName, Collection<String> names)
static void	printResultSet(ResultSet rs)
static void	printResultSet(ResultSet rs, PrintStream out)

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

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

字段详细资料

MOCK

public static final String MOCK

另请参阅:

常量字段值

HSQL

public static final String HSQL

另请参阅:

常量字段值

DB2

public static final String DB2

另请参阅:

常量字段值

POSTGRESQL

public static final String POSTGRESQL

另请参阅:

常量字段值

SYBASE

public static final String SYBASE

另请参阅:

常量字段值

SQL_SERVER

public static final String SQL_SERVER

另请参阅:

常量字段值

ORACLE

public static final String ORACLE

另请参阅:

常量字段值

MYSQL

public static final String MYSQL

另请参阅:

常量字段值

DERBY

public static final String DERBY

另请参阅:

常量字段值

HBASE

public static final String HBASE

另请参阅:

常量字段值

HIVE

public static final String HIVE

另请参阅:

常量字段值

H2

public static final String H2

另请参阅:

常量字段值

构造器详细资料

JdbcUtils

public JdbcUtils()

方法详细资料

close

public static final void close(Connection x)

close

public static final void close(Statement x)

close

public static final void close(ResultSet x)

close

public static final void close(Closeable x)

printResultSet

public static final void printResultSet(ResultSet rs)
                                 throws SQLException

抛出:

SQLException

printResultSet

public static final void printResultSet(ResultSet rs,
                  PrintStream out)
                                 throws SQLException

抛出:

SQLException

getTypeName

public static String getTypeName(int sqlType)

getDriverClassName

public static String getDriverClassName(String rawUrl)
                                 throws SQLException

抛出:

SQLException

getDbType

public static String getDbType(String rawUrl,
               String driverClassName)

createDriver

public static Driver createDriver(String driverClassName)
                           throws SQLException

抛出:

SQLException

executeUpdate

public static int executeUpdate(DataSource dataSource,
                String sql,
                Object... parameters)
                         throws SQLException

抛出:

SQLException

executeUpdate

public static int executeUpdate(DataSource dataSource,
                String sql,
                List<Object> parameters)
                         throws SQLException

抛出:

SQLException

executeUpdate

public static int executeUpdate(Connection conn,
                String sql,
                List<Object> parameters)
                         throws SQLException

抛出:

SQLException

execute

public static void execute(DataSource dataSource,
           String sql,
           Object... parameters)
                    throws SQLException

抛出:

SQLException

execute

public static void execute(DataSource dataSource,
           String sql,
           List<Object> parameters)
                    throws SQLException

抛出:

SQLException

execute

public static void execute(Connection conn,
           String sql,
           List<Object> parameters)
                    throws SQLException

抛出:

SQLException

executeQuery

public static List<Map<String,Object>> executeQuery(DataSource dataSource,
                                    String sql,
                                    Object... parameters)
                                             throws SQLException

抛出:

SQLException

executeQuery

public static List<Map<String,Object>> executeQuery(DataSource dataSource,
                                    String sql,
                                    List<Object> parameters)
                                             throws SQLException

抛出:

SQLException

executeQuery

public static List<Map<String,Object>> executeQuery(Connection conn,
                                    String sql,
                                    List<Object> parameters)
                                             throws SQLException

抛出:

SQLException

loadDriverClass

public static Class<?> loadDriverClass(String className)

insertToTable

public static void insertToTable(DataSource dataSource,
                 String tableName,
                 Map<String,Object> data)
                          throws SQLException

抛出:

SQLException

insertToTable

public static void insertToTable(Connection conn,
                 String tableName,
                 Map<String,Object> data)
                          throws SQLException

抛出:

SQLException

makeInsertToTableSql

public static String makeInsertToTableSql(String tableName,
                          Collection<String> names)