online.sanen.cdm.template.JdbcOperations Maven / Gradle / Ivy

Go to download
package online.sanen.cdm.template;

import java.util.Collection;
import java.util.List;
import java.util.Map;

/**
 * The interface specifies the basic set of Jdbc operations. Implemented by
 * {@link SqlTemplate}.
 *
 * @author LazyToShow 

 *         Date: 2018年10月14日 

 *         Time: 下午2:12:38
 */
public interface JdbcOperations {

	// For object

	Map queryForMap(String sql) throws DataAccessException;

	Map queryForMap(String sql, Object... args) throws DataAccessException;

	 T queryForObject(String sql, RowExtractor rowMapper) throws DataAccessException;

	 T queryForObject(String sql, Object[] args, RowExtractor rowMapper) throws DataAccessException;

	 T queryForObject(String sql, Object[] args, Class requiredType) throws DataAccessException;

	// For list

	List> queryForList(String sql) throws DataAccessException;

	List> queryForList(String sql, Object... args) throws DataAccessException;

	 List queryForList(String sql, Class elementType, Object... args) throws DataAccessException;

	// For Entry

	 T queryForEntry(Class entryType, String sql, Object... args) throws DataAccessException;

	 List queryForEntries(Class entryType, String sql, Object... args) throws DataAccessException;

	// For SqlRowSet

	SqlRowSet queryForRowSet(String sql, Object... args) throws DataAccessException;

	// Update

	int update(String sql, Object... args) throws DataAccessException;

	int update(String sql, PreparedStatementSetter pss) throws DataAccessException;

	int update(final PreparedStatementCreator psc, final KeyHolder generatedKeyHolder) throws DataAccessException;

	int[] batchUpdate(String sql, List batchArgs) throws DataAccessException;

	int[] batchUpdate(String sql, final PreparedStatementSetterBatch pss) throws DataAccessException;

	 int[][] batchUpdate(String sql, Collection batchArgs, int batchSize,
			PreparedStatementSetterBatchCustom pss) throws DataAccessException;

	// Query

	 T query(final String sql, final ResultSetExtractor rse) throws DataAccessException;

	 T query(String sql, Object[] args, ResultSetExtractor rse) throws DataAccessException;

	 T query(String sql, PreparedStatementSetter pss, ResultSetExtractor rse) throws DataAccessException;

	 T query(PreparedStatementCreator psc, final PreparedStatementSetter pss, final ResultSetExtractor rse)
			throws DataAccessException;

	 List query(String sql, RowExtractor rowMapper) throws DataAccessException;

	 List query(String sql, Object[] args, RowExtractor rowMapper) throws DataAccessException;

	// Execute

	void execute(final String sql) throws DataAccessException;

	 T execute(String sql, PreparedStatementCallback action) throws DataAccessException;

	 T execute(StatementCallback action) throws DataAccessException;

	 T execute(PreparedStatementCreator psc, PreparedStatementCallback action) throws DataAccessException;

}