org.eclipse.net4j.db
Class DBUtil
java.lang.Object
org.eclipse.net4j.db.DBUtil
public final class DBUtil
- extends java.lang.Object
Method Summary |
static java.lang.Exception |
close(java.sql.Connection connection)
|
static java.lang.Exception |
close(java.sql.ResultSet resultSet)
|
static java.lang.Exception |
close(java.sql.Statement statement)
|
static IDBConnectionProvider |
createConnectionProvider(javax.sql.DataSource dataSource)
|
static javax.sql.DataSource |
createDataSource(java.util.Map<java.lang.Object,java.lang.Object> properties)
|
static javax.sql.DataSource |
createDataSource(java.util.Map<java.lang.Object,java.lang.Object> properties,
java.lang.String namespace)
|
static javax.sql.DataSource |
createDataSource(java.util.Map<java.lang.Object,java.lang.Object> properties,
java.lang.String namespace,
java.lang.String driverClassKey)
|
static IDBSchema |
createSchema(java.lang.String name)
|
static void |
dropAllTables(java.sql.Connection connection,
java.lang.String dbName)
|
static java.util.List<java.lang.String> |
getAllTableNames(java.sql.Connection connection,
java.lang.String dbName)
|
static IDBAdapter |
getDBAdapter(java.lang.String adapterName)
Can only be used when Eclipse is running. |
static void |
insertRow(java.sql.Connection connection,
IDBAdapter dbAdapter,
IDBTable table,
java.lang.Object... args)
|
static int |
select(java.sql.Connection connection,
IDBRowHandler rowHandler,
IDBField... fields)
|
static int |
select(java.sql.Connection connection,
IDBRowHandler rowHandler,
java.lang.String where,
IDBField... fields)
|
static java.lang.Object[] |
select(java.sql.Connection connection,
java.lang.String where,
IDBField... fields)
|
static int |
selectMaximumInt(java.sql.Connection connection,
IDBField field)
|
static long |
selectMaximumLong(java.sql.Connection connection,
IDBField field)
|
static void |
trace(java.lang.String sql)
|
static int |
update(java.sql.Connection connection,
java.lang.String sql)
|
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
createSchema
public static IDBSchema createSchema(java.lang.String name)
createDataSource
public static javax.sql.DataSource createDataSource(java.util.Map<java.lang.Object,java.lang.Object> properties)
createDataSource
public static javax.sql.DataSource createDataSource(java.util.Map<java.lang.Object,java.lang.Object> properties,
java.lang.String namespace)
createDataSource
public static javax.sql.DataSource createDataSource(java.util.Map<java.lang.Object,java.lang.Object> properties,
java.lang.String namespace,
java.lang.String driverClassKey)
createConnectionProvider
public static IDBConnectionProvider createConnectionProvider(javax.sql.DataSource dataSource)
getDBAdapter
public static IDBAdapter getDBAdapter(java.lang.String adapterName)
- Can only be used when Eclipse is running. In standalone scenarios create the adapter instance by directly calling
the constructor of the adapter class.
close
public static java.lang.Exception close(java.sql.Connection connection)
close
public static java.lang.Exception close(java.sql.Statement statement)
close
public static java.lang.Exception close(java.sql.ResultSet resultSet)
getAllTableNames
public static java.util.List<java.lang.String> getAllTableNames(java.sql.Connection connection,
java.lang.String dbName)
dropAllTables
public static void dropAllTables(java.sql.Connection connection,
java.lang.String dbName)
selectMaximumInt
public static int selectMaximumInt(java.sql.Connection connection,
IDBField field)
throws DBException
- Throws:
DBException
selectMaximumLong
public static long selectMaximumLong(java.sql.Connection connection,
IDBField field)
throws DBException
- Throws:
DBException
update
public static int update(java.sql.Connection connection,
java.lang.String sql)
insertRow
public static void insertRow(java.sql.Connection connection,
IDBAdapter dbAdapter,
IDBTable table,
java.lang.Object... args)
throws DBException
- Throws:
DBException
select
public static int select(java.sql.Connection connection,
IDBRowHandler rowHandler,
java.lang.String where,
IDBField... fields)
throws DBException
- Throws:
DBException
select
public static int select(java.sql.Connection connection,
IDBRowHandler rowHandler,
IDBField... fields)
throws DBException
- Throws:
DBException
select
public static java.lang.Object[] select(java.sql.Connection connection,
java.lang.String where,
IDBField... fields)
throws DBException
- Throws:
DBException
trace
public static void trace(java.lang.String sql)