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, sequence
Fields 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 JdbcTemplate
createJdbcTemplate
(DataSource dataSource) protected <T,
P> List <T> findByQueryDefinitionInternal
(GlueQueryDefinition def, GlueParameter<P> param) void
void
setFetchSize
(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, updateByQueryStatement
Methods inherited from class org.springframework.jdbc.core.namedparam.NamedParameterJdbcDaoSupport
getNamedParameterJdbcTemplate, initTemplateConfig
Methods inherited from class org.springframework.jdbc.core.support.JdbcDaoSupport
checkDaoConfig, getConnection, getDataSource, getExceptionTranslator, getJdbcTemplate, releaseConnection, setDataSource, setJdbcTemplate
Methods inherited from class org.springframework.dao.support.DaoSupport
afterPropertiesSet, initDao
-
Constructor Details
-
Method Details
-
setCountQuery
- Parameters:
s
- select count(1) cnt from (${query})
-
setFetchSize
public void setFetchSize(int fetchSize) Description copied from class:GlueJdbcDao
setter method for DI.- Overrides:
setFetchSize
in classGlueJdbcDao
- Parameters:
fetchSize
-
-
createJdbcTemplate
- Overrides:
createJdbcTemplate
in classGlueJdbcDao
-
findByQueryDefinitionInternal
protected <T,P> List<T> findByQueryDefinitionInternal(GlueQueryDefinition def, GlueParameter<P> param) - Overrides:
findByQueryDefinitionInternal
in classGlueJdbcDao
- Parameters:
def
-param
-- Returns:
- List of T
-