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