package com.easyjf.web.tools;

import java.util.Collection;
import java.util.List;

/**
 * 通用的數據庫查詢器，根據數據庫操作對象DAO執行數據庫分頁查詢操作
 * @author 大峽
 *
 */
public class DbQuery implements IQuery {
	
	private IDAO dao;

	private int begin;

	private int max;

	private Collection paraValues;

	private Class cls;

	public DbQuery(IDAO dao, Class cls) {
		this.dao = dao;
		this.cls = cls;
	}

	public int getRows(String conditing) {
		int n = conditing.toLowerCase().indexOf("order by");
		String totalSql = conditing;
		if (n > 0)
			totalSql = conditing.substring(0, n);
		int total = ((Number) dao.uniqueResult(totalSql, paraValues)).intValue();
		return total;
	}

	public List getResult(String conditing) {
		return dao.query(cls, conditing, paraValues, begin, max);
	}

	public void setFirstResult(int begin) {
		this.begin = begin;
	}

	public void setMaxResults(int max) {
		this.max = max;
	}

	public List getResult(String conditing, int begin, int max) {
		return dao.query(cls, conditing, paraValues, begin, max);
	}

	public void setParaValues(Collection paraValues) {
		this.paraValues = paraValues;
	}
}