package com.kingstargroup.eqa.pageshow.action;

import java.util.List;

import org.apache.struts.action.Action;
import org.springframework.jdbc.core.JdbcTemplate;

import com.kingstargroup.framework.dao.Page;

public abstract class AbstractPageShowAction extends Action {
 protected final int defaultPageSize = 50;
 
 private JdbcTemplate jdbcTemplate;

 public JdbcTemplate getJdbcTemplate() {
  return jdbcTemplate;
 }

 public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
  this.jdbcTemplate = jdbcTemplate;
 }
 
 protected Page queryForPage(String sql, int pageNo, int pageCount, Object[] args) {
  String strSql = "";
  int startNo = Page.getStartOfPage(pageNo, pageCount);
  int endNo = startNo + pageCount;
  int argsCount = args.length;
  int totleCount = queryForCount(sql, args);
  Object[] new_args;
  
  if(startNo==0){
   strSql = "select * from (" + sql + ") where rownum <= ?";
   new_args = new Object[argsCount+1];
  }
  else{
   strSql = "select * from (select row_.*,rownum rownum_ from (" + sql + ") row_ where rownum <= ?) where rownum_>?";
   new_args = new Object[argsCount+2];
   new_args[argsCount + 1] = new Integer(startNo);
  }
  for(int i=0; i<argsCount; i++){
   new_args[i] =args[i];
  }
  new_args[argsCount] = new Integer(endNo);
  List list = jdbcTemplate.queryForList(strSql, new_args);   
  
  return new Page(startNo, totleCount, pageCount, list);
 }
 
 private int queryForCount(String sql, Object[] args){
  String strSql = "select count(rowid) from ( " + sql +  ")";
  return jdbcTemplate.queryForInt(strSql, args);
 }

}





package com.kingstargroup.framework.dao;

import java.util.ArrayList;
import java.util.Collection;

import com.kingstargroup.framework.dao.hibernate.BaseHibernateDao;

/**
 * 分頁對象. 包含數據及分頁信息.
 *
 * @author ajax
 */
public class Page implements java.io.Serializable {
 /**
  * 當前頁第一條數據的位置,從0開始
  */
 private int start;

 /**
  * 每頁的記錄數
  */
 private int pageSize = BaseHibernateDao.DEFAULT_PAGE_SIZE;

 /**
  * 當前頁中存放的記錄
  */
 private Object data;

 /**
  * 總記錄數
  */
 private int totalCount;

 private int size;

 /**
  * 構造方法，只構造空頁
  */
 public Page() {
  this(0, 0, BaseHibernateDao.DEFAULT_PAGE_SIZE, new ArrayList());
 }

 /**
  * 默認構造方法
  *
  * @param start
  *            本頁數據在數據庫中的起始位置
  * @param totalSize
  *            數據庫中總記錄條數
  * @param pageSize
  *            本頁容量
  * @param data
  *            本頁包含的數據
  */
 public Page(int start, int totalSize, int pageSize, Object data) {
  this.pageSize = pageSize;
  this.start = start;
  this.totalCount = totalSize;
  this.data = data;
  if (data instanceof Collection)
   this.size = ((Collection) data).size();
  else
   this.size = ((Object[]) data).length;
 }

 /**
  * 取數據庫中包含的總記錄數
  */
 public int getTotalSize() {
  return this.totalCount;
 }

 /**
  * 取總頁數
  */
 public int getTotalPageCount() {
  if (totalCount % pageSize == 0)
   return totalCount / pageSize;
  else
   return totalCount / pageSize + 1;
 }

 /**
  * 取每頁數據容量
  */
 public int getPageSize() {
  return pageSize;
 }

 /**
  * 當前頁中的記錄
  */
 public Object getResult() {
  return data;
 }

 /**
  * 取當前頁碼,頁碼從1開始
  */
 public int getCurrentPageNo() {
  return (start / pageSize) + 1;
 }

 /**
  * 是否有下一頁
  */
 public boolean hasNextPage() {
  return (this.getCurrentPageNo() < this.getTotalPageCount() - 1);
 }

 /**
  * 是否有上一頁
  */
 public boolean hasPreviousPage() {
  return (this.getCurrentPageNo() > 1);
 }

 /**
  * 獲取任一頁第一條數據的位置，每頁條數使用默認值
  */
 protected static int getStartOfPage(int pageNo) {
  return getStartOfPage(pageNo, BaseHibernateDao.DEFAULT_PAGE_SIZE);
 }

 /**
  * 獲取任一頁第一條數據的位置,startIndex從0開始
  */
 public static int getStartOfPage(int pageNo, int pageSize) {
  return (pageNo - 1) * pageSize;
 }

 public int getSize() {
  return this.size;
 }

}