org.velocityweb.jdbc
Class JdbcPageUtils

java.lang.Object
  org.velocityweb.jdbc.JdbcPageUtils

public class JdbcPageUtils

extends java.lang.Object

Get page data and total record count using JDBC directly

Author:

Jacklondon Chen

Constructor Summary

JdbcPageUtils()

Method Summary

static int

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

JdbcPageUtils

public JdbcPageUtils()

Method Detail

getPageData

public static int getPageData(java.lang.String sql,
                              java.util.List paraList,
                              java.lang.String orderBy,
                              int pageIndex,
                              int pageSize,
                              java.sql.Connection con,
                              PageDialect dialect,
                              java.util.List resultDataList)
                       throws java.sql.SQLException

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

con - JDBC connection

dialect - paging dialect

resultDataList - the page data is been hold in this list, each item is a Object[]

Returns:

total record count

Throws:

java.sql.SQLException