org.velocityweb.jdbc
Class VelocitywebPageUtils

java.lang.Object
  org.velocityweb.jdbc.VelocitywebPageUtils

public class VelocitywebPageUtils

extends java.lang.Object

Get page data and total record count using Velocityweb JdbcDao

Author:

Jacklondon Chen

Constructor Summary

VelocitywebPageUtils()

Method Summary

static int

getPageData(java.lang.String sql, java.util.List paraList, java.lang.String orderBy, int pageIndex, int pageSize, JdbcDao dao, PageDialect dialect, 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 java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

VelocitywebPageUtils

public VelocitywebPageUtils()

Method Detail

getPageData

public static int getPageData(java.lang.String sql,
                              java.util.List paraList,
                              java.lang.String orderBy,
                              int pageIndex,
                              int pageSize,
                              JdbcDao dao,
                              PageDialect dialect,
                              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

dao - JdbcDao instance

dialect - paging dialect

beanClass - return bean class in resultDataList

resultDataList - the result data list of beanClass

Returns:

total record count of this SQL, not just current page