gu.sql2java

Interface SqlRunner

All Known Subinterfaces:

TableManager<B>

public interface SqlRunner

Method Summary

Modifier and Type	Method and Description
<T> T	runAsTransaction(java.util.concurrent.Callable<T> fun) Run Callable<T> as a transaction. all exceptions but SQLException threw by Callable<T> is wrapped into RuntimeException throw NullPointerException if fun be null
void	runAsTransaction(java.lang.Runnable fun) Run Runnable as a transaction.no return
int	runSql(java.lang.String sql) run a SQL statement as Statement.
boolean	runSql(java.lang.String sql, java.lang.Object[] argList) run a SQL statement as PreparedStatement
<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.

Method Detail

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.

Parameters:

sql - the SQL statement for retrieving

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

Returns:

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

Throws:

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.

Parameters:

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

Returns:

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

Throws:

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.

Parameters:

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

Returns:

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

Throws:

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.

Parameters:

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

Returns:

SQL statement return value

Throws:

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

Type Parameters:

T - type of return result

Parameters:

fun -

Returns:

return T object

Throws:

RuntimeDaoException

runAsTransaction

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

Run Runnable as a transaction.no return

Parameters:

fun -

Throws:

RuntimeDaoException

See Also:

runAsTransaction(Runnable)

runSql

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

run a SQL statement as PreparedStatement

Parameters:

sql - the SQL statement for running

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

Returns:

see java.sql.Statement#execute()

runSql

int runSql(java.lang.String sql)

run a SQL statement as Statement.

Parameters:

sql - the SQL statement for running

Returns:

see Statement.executeUpdate(String sql)