Class GlueLazyJdbcDao
java.lang.Object
org.springframework.dao.support.DaoSupport
org.springframework.jdbc.core.support.JdbcDaoSupport
org.springframework.jdbc.core.namedparam.NamedParameterJdbcDaoSupport
com.poscoict.glueframework.dao.jdbc.GlueJdbcDao
com.poscoict.glueframework.dao.jdbc.GlueLazyJdbcDao
- All Implemented Interfaces:
GlueGenericDao,GlueGenericJdbcDao,InitializingBean
GlueLazyJdbcDao. 데이타베이스 CRUD(Create, Read, Update, Delete) 오퍼레이션을 추상화하여 제공하는 Data Access Object 오브젝트.
Bean Property
- dataSource : (필수) javax.sql.DataSource
- queryManager : (필수) com.poscoict.glueframework.dao.manager.GlueQueryManager
- columnManager : (선택) com.poscoict.glueframework.dao.manager.GlueColumnManager, default는 null
- fetchSize : (필수) int
- countQuery : (필수) default는 "select count(1) cnt from (${query})"
예제
사용 예# 1
<bean id="dao" class="com.poscoict.glueframework.dao.jdbc.GlueLazyJdbcDao">
<property name="dataSource" ref="dataSource"/>
<property name="queryManager" ref="queryManager"/>
<property name="fetchSize" value="100"/>
<property name="countQuery" value="select count(*) from (${query})"/>
</bean>
GlueGenericJdbcDao dao = ...
GlueCursorBasedRowSet rowSet = (GlueCursorBasedRowSet)dao.find("emp.select");
while(rowSet.hasNext()){
Map row = rowSet.next();
empno = row.get("empno")
// EmpVO row = rowSet.next();
// empno = row.getEmpno();
}
-
Field Summary
Fields inherited from class com.poscoict.glueframework.dao.jdbc.GlueJdbcDao
lobHandler, queryManager, sequenceFields inherited from interface com.poscoict.glueframework.dao.jdbc.GlueGenericJdbcDao
DEFAULT_BATCH_UPDATE_SIZE, DELETE, INSERT, SELECT, UPDATE -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionprotected JdbcTemplatecreateJdbcTemplate(DataSource dataSource) protected <T,P> List <T> findByQueryDefinitionInternal(GlueQueryDefinition def, GlueParameter<P> param) voidvoidsetFetchSize(int fetchSize) setter method for DI.Methods inherited from class com.poscoict.glueframework.dao.jdbc.GlueJdbcDao
batchUpdate, batchUpdate, batchUpdate, batchUpdateByQueryStatement, batchUpdateByQueryStatement, batchUpdateByQueryStatement, delete, delete, deleteByQueryStatement, deleteByQueryStatement, find, find, find, findByQueryStatement, findByQueryStatement, findForNavigationPage, findForNavigationPage, findForNavigationPageByQuery, findForNavigationPageByQuery, getBatchUpdateLimit, getColumnManager, getDatabaseProductName, getDBConnection, getQueryManager, getSequence, handleDataAccessException, insert, insert, insertByQueryStatement, insertByQueryStatement, releaseDBConnection, setBatchUpdateLimit, setColumnManager, setLobHandler, setQueryManager, setSequence, setTypeCast, update, update, updateByQueryStatement, updateByQueryStatementMethods inherited from class org.springframework.jdbc.core.namedparam.NamedParameterJdbcDaoSupport
getNamedParameterJdbcTemplate, initTemplateConfigMethods inherited from class org.springframework.jdbc.core.support.JdbcDaoSupport
checkDaoConfig, getConnection, getDataSource, getExceptionTranslator, getJdbcTemplate, releaseConnection, setDataSource, setJdbcTemplateMethods inherited from class org.springframework.dao.support.DaoSupport
afterPropertiesSet, initDao
-
Constructor Details
-
GlueLazyJdbcDao
public GlueLazyJdbcDao()
-
-
Method Details
-
setCountQuery
- Parameters:
s- select count(1) cnt from (${query})
-
setFetchSize
public void setFetchSize(int fetchSize) Description copied from class:GlueJdbcDaosetter method for DI.- Overrides:
setFetchSizein classGlueJdbcDao- Parameters:
fetchSize-
-
createJdbcTemplate
- Overrides:
createJdbcTemplatein classGlueJdbcDao
-
findByQueryDefinitionInternal
protected <T,P> List<T> findByQueryDefinitionInternal(GlueQueryDefinition def, GlueParameter<P> param) - Overrides:
findByQueryDefinitionInternalin classGlueJdbcDao- Parameters:
def-param-- Returns:
- List of T
-