gu.sql2java

类 Manager

java.lang.Object

gu.sql2java.Manager

所有已实现的接口:

Constant, SqlRunner

public final class Manager
extends java.lang.Object
implements Constant, SqlRunner

The Manager provides connections and manages transactions transparently.
It is a singleton, you get its instance with the getInstance() method. All of the XxxxManager classes use the Manager to get database connections. Before doing any operation, you must pass either a datasource or a jdbc driver/url/username/password.

作者:

guyadong

嵌套类概要

从接口继承的嵌套类/接口 gu.sql2java.Constant

Constant.JdbcProperty, Constant.UpdateStrategy

字段概要

从接口继承的字段 gu.sql2java.Constant

DEFAULT_CACHE_MAXIMUMSIZE, DEFAULT_DURATION, DEFAULT_STRATEGY, DEFAULT_TIME_UNIT, RETRIEVE_SUFFIX, SEARCH_ENDING_LIKE, SEARCH_EXACT, SEARCH_LIKE, SEARCH_STARTING_LIKE, SQL_LIKE_WILDCARD, STATE_BIT_MASK, STATE_BIT_NUM, STATE_BIT_SHIFT, STATEMENT_SUFFIX

方法概要

方法

限定符和类型	方法和说明
java.sql.Connection	beginTransaction() Initiates a database transaction.
void	disposePool() dispose pool
void	endTransaction(boolean commit) Releases connection used for the transaction and performs a commit or rollback.
protected static void	fillPrepareStatement(java.sql.PreparedStatement ps, java.lang.Object[] argList) 填充PreparedStatement中的参数对象
java.sql.Connection	getConnection() Gets an auto commit connection.
static Manager	getInstance() Returns the manager singleton instance.
static <T> T	getObject(java.sql.ResultSet rs, int columnIndex, java.lang.Class<T> type) For compatibility with old version ResultSet without getObject(int,Class) method
static void	injectProperties(java.util.EnumMap<Constant.JdbcProperty,java.lang.String> properties) inject properties to databaseProperties be effected only while called before initializing singleton instance
static void	injectProperties(java.util.Map<java.lang.String,java.lang.String> properties) inject properties to databaseProperties be effected only while called before initializing singleton instance
void	loadProperties(java.util.Properties properties) configure with the parameters given in the properties object
void	releaseConnection(java.sql.Connection c) Releases the database connection.
<T> T	runAsTransaction(java.util.concurrent.Callable<T> fun) Run Callable<T> as a transaction.
void	runAsTransaction(java.lang.Runnable fun) Run Runnable as a transaction.no return
<T> java.util.List<T>	runSqlAsList(java.lang.Class<T> targetType, java.lang.String sql, java.lang.Object... argList) Load all the elements using a SQL statement specifying a fields to be retrieved.
java.util.List<BaseBean>	runSqlAsList(java.lang.String sql, java.lang.Object... argList) Load all the elements using a SQL statement specifying a list of fields to be retrieved.
java.util.List<java.util.Map<java.lang.String,java.lang.Object>>	runSqlForMap(java.util.Map<java.lang.String,java.lang.Class<?>> targetType, java.lang.String sql, java.lang.Object... argList) Load all the elements using a SQL statement specifying a list of fields to be retrieved.
<T> T	runSqlForValue(java.lang.Class<T> targetType, java.lang.String sql, java.lang.Object... argList) Load all the elements using a SQL statement specifying a row of a field to be retrieved.
void	setDebug(boolean isDebug)
protected static void	setPreparedStatement(java.sql.PreparedStatement ps, int pos, java.lang.Object value, int sqlType)

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

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

方法详细资料

injectProperties

public static final void injectProperties(java.util.Map<java.lang.String,java.lang.String> properties)

inject properties to databaseProperties
be effected only while called before initializing singleton instance

参数:

properties -

另请参阅:

JdbcProperty

injectProperties

public static final void injectProperties(java.util.EnumMap<Constant.JdbcProperty,java.lang.String> properties)

inject properties to databaseProperties
be effected only while called before initializing singleton instance

参数:

properties -

getInstance

public static Manager getInstance()

Returns the manager singleton instance.

disposePool

public void disposePool()

dispose pool

loadProperties

public void loadProperties(java.util.Properties properties)

configure with the parameters given in the properties object

参数:

properties - the properties object to be used

getConnection

public java.sql.Connection getConnection()
                                  throws java.sql.SQLException

Gets an auto commit connection.
Normally you do not need this method that much ;-)

返回:

an auto commit connection

抛出:

java.sql.SQLException

releaseConnection

public void releaseConnection(java.sql.Connection c)

Releases the database connection.
Normally you should not need this method ;-)

beginTransaction

public java.sql.Connection beginTransaction()
                                     throws java.sql.SQLException

Initiates a database transaction.
When working within a transaction, you should invoke this method first. The connection is returned just in case you need to set the isolation level.

返回:

a non-auto commit connection with the default transaction isolation level

抛出:

java.sql.SQLException

endTransaction

public void endTransaction(boolean commit)
                    throws java.sql.SQLException

Releases connection used for the transaction and performs a commit or rollback.

参数:

commit - tells whether this connection should be committed true for commit(), false for rollback()

抛出:

java.sql.SQLException

runAsTransaction

public <T> T runAsTransaction(java.util.concurrent.Callable<T> fun)
                   throws RuntimeDaoException

从接口复制的说明: SqlRunner

Run Callable<T> as a transaction.
all exceptions but SQLException threw by Callable<T> is wrapped into RuntimeException
throw NullPointerException if fun be null

指定者:

runAsTransaction 在接口中 SqlRunner

类型参数:

T - type of return result

参数:

fun -

返回:

抛出:

RuntimeDaoException

runAsTransaction

public void runAsTransaction(java.lang.Runnable fun)
                      throws RuntimeDaoException

Run Runnable as a transaction.no return

指定者:

runAsTransaction 在接口中 SqlRunner

参数:

fun -

抛出:

DaoException

RuntimeDaoException

另请参阅:

SqlRunner.runAsTransaction(Runnable)

getObject

public static <T> T getObject(java.sql.ResultSet rs,
              int columnIndex,
              java.lang.Class<T> type)
                   throws java.sql.SQLException

For compatibility with old version ResultSet without getObject(int,Class) method

参数:

rs -

columnIndex -

type -

返回:

抛出:

java.sql.SQLException

runSqlForMap

public java.util.List<java.util.Map<java.lang.String,java.lang.Object>> runSqlForMap(java.util.Map<java.lang.String,java.lang.Class<?>> targetType,
                                                                            java.lang.String sql,
                                                                            java.lang.Object... argList)
                                                                              throws RuntimeDaoException

从接口复制的说明: SqlRunner

Load all the elements using a SQL statement specifying a list of fields to be retrieved.

指定者:

runSqlForMap 在接口中 SqlRunner

参数:

targetType - map of target type for column name or null

sql - the SQL statement for retrieving

argList - the arguments to use fill given prepared statement,may be null

返回:

an list of row values map, or empty list if no row return

抛出:

RuntimeDaoException

runSqlAsList

public java.util.List<BaseBean> runSqlAsList(java.lang.String sql,
                                    java.lang.Object... argList)
                                      throws RuntimeDaoException

从接口复制的说明: SqlRunner

Load all the elements using a SQL statement specifying a list of fields to be retrieved.

指定者:

runSqlAsList 在接口中 SqlRunner

参数:

sql - the SQL statement for retrieving

argList - the arguments to use fill given prepared statement,may be null

返回:

an list of BaseBean bean, or empty list if no row return

抛出:

RuntimeDaoException

runSqlAsList

public <T> java.util.List<T> runSqlAsList(java.lang.Class<T> targetType,
                                 java.lang.String sql,
                                 java.lang.Object... argList)
                               throws RuntimeDaoException

从接口复制的说明: SqlRunner

Load all the elements using a SQL statement specifying a fields to be retrieved.

指定者:

runSqlAsList 在接口中 SqlRunner

参数:

targetType - target type for column or null

sql - the SQL statement for retrieving

argList - the arguments to use fill given prepared statement,may be null

返回:

an list of row values , or empty list if no row return

抛出:

RuntimeDaoException

runSqlForValue

public <T> T runSqlForValue(java.lang.Class<T> targetType,
                   java.lang.String sql,
                   java.lang.Object... argList)
                 throws RuntimeDaoException

从接口复制的说明: SqlRunner

Load all the elements using a SQL statement specifying a row of a field to be retrieved.

指定者:

runSqlForValue 在接口中 SqlRunner

参数:

targetType - target type for column or null

sql - the SQL statement for retrieving

argList - the arguments to use fill given prepared statement,may be null

返回:

SQL statement return value

抛出:

RuntimeDaoException

fillPrepareStatement

protected static void fillPrepareStatement(java.sql.PreparedStatement ps,
                        java.lang.Object[] argList)
                                    throws DaoException

填充PreparedStatement中的参数对象

参数:

ps -

argList -

抛出:

java.sql.SQLException

DaoException

setPreparedStatement

protected static void setPreparedStatement(java.sql.PreparedStatement ps,
                        int pos,
                        java.lang.Object value,
                        int sqlType)
                                    throws java.sql.SQLException

抛出:

java.sql.SQLException

setDebug

public void setDebug(boolean isDebug)