play.db

Class DB

java.lang.Object

play.db.DB

public class DB
extends Object

Database connection utilities.

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	DB.ExtendedDatasource

Field Summary

Fields

Modifier and Type	Field and Description
static DataSource	datasource Deprecated. Use datasources instead
protected static Map<String,DB.ExtendedDatasource>	datasources The loaded datasource.
static String	DEFAULT
static String	destroyMethod Deprecated. Use datasources instead

Constructor Summary

Constructors

Constructor and Description
DB()

Method Summary

Modifier and Type	Method and Description
static void	close() Close all the open connections for the current thread.
static void	close(String name) Close an given open connections for the current thread
static void	closeAll() Close all the open connections for the current thread.
static void	destroy() Destroy the datasource
static void	destroy(String name) Destroy the datasource
static void	destroyAll() Destroy all datasources
static boolean	execute(String SQL)
static boolean	execute(String name, String SQL) Execute an SQL update
static RowSet	executeQuery(String SQL)
static RowSet	executeQuery(String name, String SQL) Execute an SQL query
static Connection	getConnection()
static Connection	getConnection(String name) Open a connection for the current thread.
static Connection	getConnection(String name, boolean autocommit)
static DataSource	getDataSource()
static DataSource	getDataSource(String name)
static void	safeCloseResultSet(ResultSet resultSet)
static void	safeCloseStatement(Statement statement)

Methods inherited from class java.lang.Object

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

Field Detail

datasources

protected static final Map<String,DB.ExtendedDatasource> datasources

The loaded datasource.

See Also:

DB.ExtendedDatasource

datasource

@Deprecated
public static DataSource datasource

Deprecated. Use datasources instead

Since:

1.3.0

See Also:

datasources, DB.ExtendedDatasource

destroyMethod

@Deprecated
public static String destroyMethod

Deprecated. Use datasources instead

The method used to destroy the datasource

Since:

1.3.0

See Also:

datasources, DB.ExtendedDatasource

DEFAULT

public static final String DEFAULT

See Also:

Constant Field Values

Constructor Detail

DB

public DB()

Method Detail

getDataSource

public static DataSource getDataSource(String name)

getDataSource

public static DataSource getDataSource()

getConnection

public static Connection getConnection(String name,
                                       boolean autocommit)

closeAll

public static void closeAll()

Close all the open connections for the current thread.

close

public static void close()

Close all the open connections for the current thread.

close

public static void close(String name)

Close an given open connections for the current thread

getConnection

public static Connection getConnection(String name)

Open a connection for the current thread.

Returns:

A valid SQL connection

getConnection

public static Connection getConnection()

execute

public static boolean execute(String name,
                              String SQL)

Execute an SQL update

Parameters:

SQL -

Returns:

true if the next result is a ResultSet object; false if it is an update count or there are no more results

execute

public static boolean execute(String SQL)

executeQuery

public static RowSet executeQuery(String SQL)

executeQuery

public static RowSet executeQuery(String name,
                                  String SQL)

Execute an SQL query

Parameters:

SQL -

Returns:

The rowSet of the query

safeCloseResultSet

public static void safeCloseResultSet(ResultSet resultSet)

safeCloseStatement

public static void safeCloseStatement(Statement statement)

destroy

public static void destroy(String name)

Destroy the datasource

destroy

public static void destroy()

Destroy the datasource

destroyAll

public static void destroyAll()

Destroy all datasources