cn.sucang.core.dao

Class BaseJdbcDao

java.lang.Object

JdbcDaoSupport

cn.sucang.core.dao.BaseJdbcDao

public class BaseJdbcDao
extends JdbcDaoSupport

Constructor Summary

Constructors

Constructor and Description
BaseJdbcDao()
BaseJdbcDao(JdbcTemplate jdbc)

Method Summary

Modifier and Type	Method and Description
int[]	batchUpdate(java.lang.String[] sql)
int[]	batchUpdate(java.lang.String sql, BatchPreparedStatementSetter pss)
<T> int[][]	batchUpdate(java.lang.String sql, java.util.Collection<T> batchArgs, int batchSize, <any> pss)
int[]	batchUpdate(java.lang.String sql, java.util.List<java.lang.Object[]> batchArgs, int[] argTypes)
java.util.Map<java.lang.String,java.lang.Object>	call(CallableStatementCreator csc, java.util.List<SqlParameter> declaredParameters)
<T> T	execute(<any> action)
<T> T	execute(<any> action)
<T> T	execute(CallableStatementCreator csc, <any> action)
<T> T	execute(PreparedStatementCreator psc, <any> action)
void	execute(java.lang.String sql)
<T> T	execute(java.lang.String sql, <any> action)
<T> T	execute(java.lang.String callString, <any> action)
<T> T	query(PreparedStatementCreator psc, <any> rse)
<T> java.util.List<T>	query(PreparedStatementCreator psc, <any> rowMapper)
void	query(PreparedStatementCreator psc, RowCallbackHandler rch)
<T> T	query(java.lang.String sql, <any> rse)
<T> java.util.List<T>	query(java.lang.String sql, <any> rowMapper)
<T> T	query(java.lang.String sql, <any> rse, java.lang.Object... args)
<T> java.util.List<T>	query(java.lang.String sql, <any> rowMapper, java.lang.Object... args)
<T> T	query(java.lang.String sql, java.lang.Object[] args, <any> rse)
<T> java.util.List<T>	query(java.lang.String sql, java.lang.Object[] args, <any> rowMapper)
<T> T	query(java.lang.String sql, java.lang.Object[] args, int[] argTypes, <any> rse)
<T> java.util.List<T>	query(java.lang.String sql, java.lang.Object[] args, int[] argTypes, <any> rowMapper)
void	query(java.lang.String sql, java.lang.Object[] args, int[] argTypes, RowCallbackHandler rch)
void	query(java.lang.String sql, java.lang.Object[] args, RowCallbackHandler rch)
<T> T	query(java.lang.String sql, PreparedStatementSetter pss, <any> rse)
<T> java.util.List<T>	query(java.lang.String sql, PreparedStatementSetter pss, <any> rowMapper)
void	query(java.lang.String sql, PreparedStatementSetter pss, RowCallbackHandler rch)
void	query(java.lang.String sql, RowCallbackHandler rch)
void	query(java.lang.String sql, RowCallbackHandler rch, java.lang.Object... args)
int	queryForInt(java.lang.String sql)
int	queryForInt(java.lang.String sql, java.lang.Object... args)
int	queryForInt(java.lang.String sql, java.lang.Object[] args, int[] argTypes)
java.util.List<java.util.Map<java.lang.String,java.lang.Object>>	queryForList(java.lang.String sql)
<T> java.util.List<T>	queryForList(java.lang.String sql, java.lang.Class<T> elementType)
<T> java.util.List<T>	queryForList(java.lang.String sql, java.lang.Class<T> elementType, java.lang.Object... args)
java.util.List<java.util.Map<java.lang.String,java.lang.Object>>	queryForList(java.lang.String sql, java.lang.Object... args)
<T> java.util.List<T>	queryForList(java.lang.String sql, java.lang.Object[] args, java.lang.Class<T> elementType)
java.util.List<java.util.Map<java.lang.String,java.lang.Object>>	queryForList(java.lang.String sql, java.lang.Object[] args, int[] argTypes)
<T> java.util.List<T>	queryForList(java.lang.String sql, java.lang.Object[] args, int[] argTypes, java.lang.Class<T> elementType)
java.util.List	queryForList0(java.lang.String sql)
java.util.List	queryForList0(java.lang.String sql, java.lang.Class elementType)
java.util.List	queryForList0(java.lang.String sql, java.lang.Object[] args)
java.util.List	queryForList0(java.lang.String sql, java.lang.Object[] args, java.lang.Class elementType)
java.util.List	queryForList0(java.lang.String sql, java.lang.Object[] args, int[] argTypes)
java.util.List	queryForList0(java.lang.String sql, java.lang.Object[] args, int[] argTypes, java.lang.Class elementType)
long	queryForLong(java.lang.String sql)
long	queryForLong(java.lang.String sql, java.lang.Object... args)
long	queryForLong(java.lang.String sql, java.lang.Object[] args, int[] argTypes)
java.util.Map<java.lang.String,java.lang.Object>	queryForMap(java.lang.String sql)
java.util.Map<java.lang.String,java.lang.Object>	queryForMap(java.lang.String sql, java.lang.Object... args)
java.util.Map<java.lang.String,java.lang.Object>	queryForMap(java.lang.String sql, java.lang.Object[] args, int[] argTypes)
java.util.Map	queryForMap0(java.lang.String sql)
java.util.Map	queryForMap0(java.lang.String sql, java.lang.Object[] args)
java.util.Map	queryForMap0(java.lang.String sql, java.lang.Object[] args, int[] argTypes)
java.lang.Object	queryForObject(java.lang.String sql)
<T> T	queryForObject(java.lang.String sql, <any> rowMapper)
<T> T	queryForObject(java.lang.String sql, <any> rowMapper, java.lang.Object... args)
java.lang.Object	queryForObject(java.lang.String sql, java.lang.Object[] args)
<T> T	queryForObject(java.lang.String sql, java.lang.Object[] args, <any> rowMapper)
<T> T	queryForObject(java.lang.String sql, java.lang.Object[] args, int[] argTypes, <any> rowMapper)
java.lang.Object	queryForObject0(java.lang.String sql, java.lang.Object[] args, java.lang.Class requiredType)
SqlRowSet	queryForRowSet(java.lang.String sql)
SqlRowSet	queryForRowSet(java.lang.String sql, java.lang.Object... args)
SqlRowSet	queryForRowSet(java.lang.String sql, java.lang.Object[] args, int[] argTypes)
java.lang.Object[]	SQLArray(java.lang.String sql) 只取sql结果集的第一行为数组，如果无结果，则返回空数组
int	SQLInt(java.lang.String sql)
java.util.List	SQLList(java.lang.String sql) 执行Sql语句查询返回List
java.util.List	SQLList(java.lang.String sql, java.lang.String dsName) 从指定数据源中查询数据
java.util.Map	SQLMap(java.lang.String sql) 执行Sql语句查询返回第一行第一列的值
java.lang.Object	SQLObject(java.lang.String sql) 执行Sql语句查询返回第一行第一列的值
int	update(PreparedStatementCreator psc)
int	update(PreparedStatementCreator psc, KeyHolder generatedKeyHolder)
int	update(java.lang.String sql)
int	update(java.lang.String sql, java.lang.Object... args)
int	update(java.lang.String sql, java.lang.Object[] args, int[] argTypes)
int	update(java.lang.String sql, PreparedStatementSetter pss)

Methods inherited from class java.lang.Object

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

Constructor Detail

BaseJdbcDao

public BaseJdbcDao()

BaseJdbcDao

public BaseJdbcDao(JdbcTemplate jdbc)

Method Detail

batchUpdate

public int[] batchUpdate(java.lang.String[] sql)
                  throws DataAccessException

Throws:

DataAccessException

batchUpdate

public int[] batchUpdate(java.lang.String sql,
                         BatchPreparedStatementSetter pss)
                  throws DataAccessException

Throws:

DataAccessException

call

public java.util.Map<java.lang.String,java.lang.Object> call(CallableStatementCreator csc,
                                                             java.util.List<SqlParameter> declaredParameters)
                                                      throws DataAccessException

Throws:

DataAccessException

execute

public <T> T execute(<any> action)
              throws DataAccessException

Throws:

DataAccessException

execute

public <T> T execute(<any> action)
              throws DataAccessException

Throws:

DataAccessException

execute

public void execute(java.lang.String sql)
             throws DataAccessException

Throws:

DataAccessException

execute

public <T> T execute(PreparedStatementCreator psc,
                     <any> action)
              throws DataAccessException

Throws:

DataAccessException

execute

public <T> T execute(java.lang.String sql,
                     <any> action)
              throws DataAccessException

Throws:

DataAccessException

execute

public <T> T execute(CallableStatementCreator csc,
                     <any> action)
              throws DataAccessException

Throws:

DataAccessException

execute

public <T> T execute(java.lang.String callString,
                     <any> action)
              throws DataAccessException

Throws:

DataAccessException

query

public <T> T query(java.lang.String sql,
                   <any> rse)
            throws DataAccessException

Throws:

DataAccessException

query

public void query(java.lang.String sql,
                  RowCallbackHandler rch)
           throws DataAccessException

Throws:

DataAccessException

query

public <T> java.util.List<T> query(java.lang.String sql,
                                   <any> rowMapper)
                            throws DataAccessException

Throws:

DataAccessException

query

public <T> T query(PreparedStatementCreator psc,
                   <any> rse)
            throws DataAccessException

Throws:

DataAccessException

query

public void query(PreparedStatementCreator psc,
                  RowCallbackHandler rch)
           throws DataAccessException

Throws:

DataAccessException

query

public <T> java.util.List<T> query(PreparedStatementCreator psc,
                                   <any> rowMapper)
                            throws DataAccessException

Throws:

DataAccessException

query

public <T> T query(java.lang.String sql,
                   PreparedStatementSetter pss,
                   <any> rse)
            throws DataAccessException

Throws:

DataAccessException

query

public <T> T query(java.lang.String sql,
                   java.lang.Object[] args,
                   <any> rse)
            throws DataAccessException

Throws:

DataAccessException

query

public void query(java.lang.String sql,
                  PreparedStatementSetter pss,
                  RowCallbackHandler rch)
           throws DataAccessException

Throws:

DataAccessException

query

public void query(java.lang.String sql,
                  java.lang.Object[] args,
                  RowCallbackHandler rch)
           throws DataAccessException

Throws:

DataAccessException

query

public <T> java.util.List<T> query(java.lang.String sql,
                                   PreparedStatementSetter pss,
                                   <any> rowMapper)
                            throws DataAccessException

Throws:

DataAccessException

query

public <T> java.util.List<T> query(java.lang.String sql,
                                   java.lang.Object[] args,
                                   <any> rowMapper)
                            throws DataAccessException

Throws:

DataAccessException

query

public <T> T query(java.lang.String sql,
                   java.lang.Object[] args,
                   int[] argTypes,
                   <any> rse)
            throws DataAccessException

Throws:

DataAccessException

query

public void query(java.lang.String sql,
                  java.lang.Object[] args,
                  int[] argTypes,
                  RowCallbackHandler rch)
           throws DataAccessException

Throws:

DataAccessException

query

public <T> java.util.List<T> query(java.lang.String sql,
                                   java.lang.Object[] args,
                                   int[] argTypes,
                                   <any> rowMapper)
                            throws DataAccessException

Throws:

DataAccessException

queryForInt

public int queryForInt(java.lang.String sql)
                throws DataAccessException

Throws:

DataAccessException

queryForInt

public int queryForInt(java.lang.String sql,
                       java.lang.Object... args)
                throws DataAccessException

Throws:

DataAccessException

queryForInt

public int queryForInt(java.lang.String sql,
                       java.lang.Object[] args,
                       int[] argTypes)
                throws DataAccessException

Throws:

DataAccessException

queryForList0

public java.util.List queryForList0(java.lang.String sql)

queryForList0

public java.util.List queryForList0(java.lang.String sql,
                                    java.lang.Class elementType)

queryForList0

public java.util.List queryForList0(java.lang.String sql,
                                    java.lang.Object[] args)

queryForList0

public java.util.List queryForList0(java.lang.String sql,
                                    java.lang.Object[] args,
                                    java.lang.Class elementType)

queryForList0

public java.util.List queryForList0(java.lang.String sql,
                                    java.lang.Object[] args,
                                    int[] argTypes)

queryForList0

public java.util.List queryForList0(java.lang.String sql,
                                    java.lang.Object[] args,
                                    int[] argTypes,
                                    java.lang.Class elementType)

queryForLong

public long queryForLong(java.lang.String sql)

queryForLong

public long queryForLong(java.lang.String sql,
                         java.lang.Object... args)

queryForLong

public long queryForLong(java.lang.String sql,
                         java.lang.Object[] args,
                         int[] argTypes)

queryForMap0

public java.util.Map queryForMap0(java.lang.String sql)

queryForMap0

public java.util.Map queryForMap0(java.lang.String sql,
                                  java.lang.Object[] args)

queryForMap0

public java.util.Map queryForMap0(java.lang.String sql,
                                  java.lang.Object[] args,
                                  int[] argTypes)

queryForObject

public <T> T queryForObject(java.lang.String sql,
                            <any> rowMapper)

queryForObject

public java.lang.Object queryForObject(java.lang.String sql)

queryForObject

public <T> T queryForObject(java.lang.String sql,
                            java.lang.Object[] args,
                            <any> rowMapper)

queryForObject

public java.lang.Object queryForObject(java.lang.String sql,
                                       java.lang.Object[] args)

queryForObject0

public java.lang.Object queryForObject0(java.lang.String sql,
                                        java.lang.Object[] args,
                                        java.lang.Class requiredType)

queryForObject

public <T> T queryForObject(java.lang.String sql,
                            java.lang.Object[] args,
                            int[] argTypes,
                            <any> rowMapper)

queryForRowSet

public SqlRowSet queryForRowSet(java.lang.String sql)

queryForRowSet

public SqlRowSet queryForRowSet(java.lang.String sql,
                                java.lang.Object... args)

queryForRowSet

public SqlRowSet queryForRowSet(java.lang.String sql,
                                java.lang.Object[] args,
                                int[] argTypes)

update

public int update(java.lang.String sql)

update

public int update(PreparedStatementCreator psc)

update

public int update(PreparedStatementCreator psc,
                  KeyHolder generatedKeyHolder)

update

public int update(java.lang.String sql,
                  PreparedStatementSetter pss)

update

public int update(java.lang.String sql,
                  java.lang.Object... args)

update

public int update(java.lang.String sql,
                  java.lang.Object[] args,
                  int[] argTypes)

SQLInt

public int SQLInt(java.lang.String sql)

SQLObject

public java.lang.Object SQLObject(java.lang.String sql)

执行Sql语句查询返回第一行第一列的值

Parameters:

sql - as String

Returns:

SQLMap

public java.util.Map SQLMap(java.lang.String sql)

执行Sql语句查询返回第一行第一列的值

Parameters:

sql - as Map

Returns:

SQLList

public java.util.List SQLList(java.lang.String sql,
                              java.lang.String dsName)

从指定数据源中查询数据

Parameters:

sql - as String

dsName - as String //数据源名称

Returns:

List

SQLArray

public java.lang.Object[] SQLArray(java.lang.String sql)

只取sql结果集的第一行为数组，如果无结果，则返回空数组

Parameters:

sql -

Returns:

SQLList

public java.util.List SQLList(java.lang.String sql)

执行Sql语句查询返回List

Parameters:

sql - as List

Returns:

queryForMap

public java.util.Map<java.lang.String,java.lang.Object> queryForMap(java.lang.String sql)
                                                             throws DataAccessException

Throws:

DataAccessException

queryForList

public <T> java.util.List<T> queryForList(java.lang.String sql,
                                          java.lang.Class<T> elementType)
                                   throws DataAccessException

Throws:

DataAccessException

queryForList

public java.util.List<java.util.Map<java.lang.String,java.lang.Object>> queryForList(java.lang.String sql)
                                                                              throws DataAccessException

Throws:

DataAccessException

query

public <T> T query(java.lang.String sql,
                   <any> rse,
                   java.lang.Object... args)
            throws DataAccessException

Throws:

DataAccessException

query

public void query(java.lang.String sql,
                  RowCallbackHandler rch,
                  java.lang.Object... args)
           throws DataAccessException

Throws:

DataAccessException

query

public <T> java.util.List<T> query(java.lang.String sql,
                                   <any> rowMapper,
                                   java.lang.Object... args)
                            throws DataAccessException

Throws:

DataAccessException

queryForObject

public <T> T queryForObject(java.lang.String sql,
                            <any> rowMapper,
                            java.lang.Object... args)
                     throws DataAccessException

Throws:

DataAccessException

queryForMap

public java.util.Map<java.lang.String,java.lang.Object> queryForMap(java.lang.String sql,
                                                                    java.lang.Object[] args,
                                                                    int[] argTypes)
                                                             throws DataAccessException

Throws:

DataAccessException

queryForMap

public java.util.Map<java.lang.String,java.lang.Object> queryForMap(java.lang.String sql,
                                                                    java.lang.Object... args)
                                                             throws DataAccessException

Throws:

DataAccessException

queryForList

public <T> java.util.List<T> queryForList(java.lang.String sql,
                                          java.lang.Object[] args,
                                          int[] argTypes,
                                          java.lang.Class<T> elementType)
                                   throws DataAccessException

Throws:

DataAccessException

queryForList

public <T> java.util.List<T> queryForList(java.lang.String sql,
                                          java.lang.Object[] args,
                                          java.lang.Class<T> elementType)
                                   throws DataAccessException

Throws:

DataAccessException

queryForList

public <T> java.util.List<T> queryForList(java.lang.String sql,
                                          java.lang.Class<T> elementType,
                                          java.lang.Object... args)
                                   throws DataAccessException

Throws:

DataAccessException

queryForList

public java.util.List<java.util.Map<java.lang.String,java.lang.Object>> queryForList(java.lang.String sql,
                                                                                     java.lang.Object[] args,
                                                                                     int[] argTypes)
                                                                              throws DataAccessException

Throws:

DataAccessException

queryForList

public java.util.List<java.util.Map<java.lang.String,java.lang.Object>> queryForList(java.lang.String sql,
                                                                                     java.lang.Object... args)
                                                                              throws DataAccessException

Throws:

DataAccessException

batchUpdate

public int[] batchUpdate(java.lang.String sql,
                         java.util.List<java.lang.Object[]> batchArgs,
                         int[] argTypes)
                  throws DataAccessException

Throws:

DataAccessException

batchUpdate

public <T> int[][] batchUpdate(java.lang.String sql,
                               java.util.Collection<T> batchArgs,
                               int batchSize,
                               <any> pss)
                        throws DataAccessException

Throws:

DataAccessException