org.velocityweb
Class JdbcPageDao
java.lang.Object
org.velocityweb.BaseDao
org.velocityweb.JdbcDao
org.velocityweb.JdbcPageDao
- public class JdbcPageDao
- extends JdbcDao
DAO base class, support JDBC, support paging.
- Author:
- Jacklondon Chen
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 java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
JdbcPageDao
public JdbcPageDao(BaseService srv,
PageDialect dialect)
- construction method
- Parameters:
srv
- base servicedialect
- SQL paging dialect
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 nullparaList
- parameters if need to this SQL, can be nullorderBy
- order by for SQL, cannot be nullpageIndex
- page index, begin from 0pageSize
- page size, bigger than 0beanClass
- return bean class in resultDataListresultDataList
- the result data list of beanClass
- Returns:
- total record count of this SQL, not just current page