org.eclipse.net4j.db
Class DBUtil

java.lang.Object
  extended by 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
 

Method Detail

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)

Copyright (c) 2004 - 2008 Eike Stepper, Germany.
All Rights Reserved.