org.velocityweb
Class JdbcPageDao

java.lang.Object
  extended byorg.velocityweb.BaseDao
      extended byorg.velocityweb.JdbcDao
          extended byorg.velocityweb.JdbcPageDao

public class JdbcPageDao
extends JdbcDao

DAO base class, support JDBC, support paging.

Author:
Jacklondon Chen

Field Summary
 
Fields inherited from class org.velocityweb.JdbcDao
tableColumnNamesMap
 
Constructor Summary
JdbcPageDao(BaseService srv, PageDialect dialect)
          construction method
 
Method Summary
 int getPageData(java.lang.String sql, java.util.List paraList, java.lang.String orderBy, int pageIndex, int pageSize, java.lang.Class beanClass, java.util.List resultDataList)
          get page data by SQL, and get record count for all pages too.
 
Methods inherited from class org.velocityweb.JdbcDao
callStoredProcedure, getTableColumnNames, isSameColumn, query, queryArray, queryArrayList, queryBean, queryBean, queryBeanList, queryBeanList, queryColumnList, queryColumnList, queryKeyed, queryKeyed, queryMap, queryMapList, queryScalar, queryScalar, update, update
 
Methods inherited from class org.velocityweb.BaseDao
getAppContext
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

JdbcPageDao

public JdbcPageDao(BaseService srv,
                   PageDialect dialect)
construction method

Parameters:
srv - base service
dialect - SQL paging dialect
Method Detail

getPageData

public int getPageData(java.lang.String sql,
                       java.util.List paraList,
                       java.lang.String orderBy,
                       int pageIndex,
                       int pageSize,
                       java.lang.Class beanClass,
                       java.util.List resultDataList)
get page data by SQL, and get record count for all pages too.

Parameters:
sql - SQL without order by,cannot be null
paraList - parameters if need to this SQL, can be null
orderBy - order by for SQL, cannot be null
pageIndex - page index, begin from 0
pageSize - page size, bigger than 0
beanClass - return bean class in resultDataList
resultDataList - the result data list of beanClass
Returns:
total record count of this SQL, not just current page