gu.sql2java

接口 SqlRunner

所有已知子接口:

TableManager<B>

public interface SqlRunner

方法概要

限定符和类型	方法和说明
<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
boolean	runSql(java.lang.String sql, java.lang.Object[] argList) run a SQL statement.
<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<?>> targetTypes, 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.

方法详细资料

runSqlAsList

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

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

参数:

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

runSqlForMap

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

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

参数:

targetTypes - 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

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

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

参数:

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

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

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

参数:

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

runAsTransaction

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

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

类型参数:

T - type of return result

参数:

fun -

返回:

抛出:

RuntimeDaoException

runAsTransaction

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

Run Runnable as a transaction.no return

参数:

fun -

抛出:

RuntimeDaoException

另请参阅:

runAsTransaction(Runnable)

runSql

boolean runSql(java.lang.String sql,
               java.lang.Object[] argList)

run a SQL statement.

参数:

sql - the SQL statement for running

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

返回:

true if success,otherwise false