package com.david.util;

import java.sql.SQLException;
import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.type.Type;
import org.springframework.orm.hibernate3.HibernateCallback;

/**
 * 負責分頁的bean
 * 
 * @author Administrator
 *
 */
public class PageBeanSH implements IPageBeanSH {
	//起始位置 
	private int start=0;
	//數量 
	private int num;
	//查詢語句 
	private String hql;	
	
	//對象數組,查詢
	private Object[] arrValues;
	//對象
	private Type[] arrTypes;
	
	public PageBeanSH() {
		super();
		// TODO Auto-generated constructor stub
	}
	
	public PageBeanSH(String hql,Object[] arrValues) {
		this.hql = hql;
		this.arrValues=arrValues;
		// TODO Auto-generated constructor stub
	}

	/**
	 * 構造函數
	 * @param start
	 * @param num
	 * @param hql
	 */
	public PageBeanSH(int start, int num, String hql,Object[] arrValues,Type[] arrTypes) {
		super();
		this.start = start;
		this.num = num;
		this.hql = hql;
		this.arrValues=arrValues;
		this.arrTypes=arrTypes;
	}


	/**
	 * 得出查詢結果
	 */
	public Object doInHibernate(Session session) throws HibernateException,
			SQLException {
		// TODO Auto-generated method stub
		Query query=session.createQuery(hql);
		query.setFirstResult(start*num);
		query.setMaxResults(num);
		//循環套入參數
		if(arrValues.length==0){
			;
		}else{
			for(int i=0;i<arrValues.length;i++){
				query.setParameter(i, arrValues[i]);
			}
		}
		return query.list();
	}

	public Type[] getArrTypes() {
		return arrTypes;
	}

	public void setArrTypes(Type[] arrTypes) {
		this.arrTypes = arrTypes;
	}

	public Object[] getArrValues() {
		return arrValues;
	}

	public void setArrValues(Object[] arrValues) {
		this.arrValues = arrValues;
	}

	public String getHql() {
		return hql;
	}

	public void setHql(String hql) {
		this.hql = hql;
	}

	public int getNum() {
		return num;
	}

	public void setNum(int num) {
		this.num = num;
	}

	public int getStart() {
		return start;
	}

	public void setStart(int start) {
		this.start = start;
	}

}