seqmanagerdao.java

电信的网厅的整站代码

/*
 * 创建日期 2005-7-29
 *
 */
package com.doone.fj1w.fjmgr.monitor;

import com.doone.data.DataTable;
import com.doone.fj1w.fjmgr.order.DAO;
import com.doone.util.FileLogger;

/**
 * @author huzx
 *  
 */
public class SeqManagerDAO extends DAO {
	
	private int pageSize = 20; // 默认每页20条
	
	
	public SeqManagerDAO() {
		FileLogger.getLogger().debug("SeqManagerDAO 数据库链接" + _dac);
	}

	public DataTable getSeqManagerList(int pageNo ) {
		String sql = "select rownum,t.tablename , t.fieldname,t.seqsource  from ts_seqmanager t";
		return getSeqManagers(pageNo,sql);
	}
	/**
	 * @param pageNo
	 *            查询第N页记录
	 * @param sql
	 *            查询sql
	 * @return
	 */
	private DataTable getSeqManagers(int pageNo, String sql) {
		DataTable dataTable = null;
		sql = "SELECT * FROM ( SELECT row_.*, rownum rownum_ FROM(" + sql
				+ ")row_ WHERE rownum <= " + pageNo * pageSize
				+ ") WHERE rownum_ >" + (pageNo - 1) * pageSize;
		try {
			dataTable = _dac.executeQuery(sql);
		} catch (Exception e) {
			FileLogger.getLogger().debug(e.getMessage());
		}
		return dataTable;
	}
	
	public int getSeqManagerSize(){
		DataTable dataTable = null;
		String sql = "select count(SEQMANAGERID) from ts_seqmanager";
		try {
			dataTable = _dac.executeQuery(sql);
		} catch (Exception e) {
			FileLogger.getLogger().debug(e.getMessage());
			return 0;
		}
		return Integer.parseInt(dataTable.getRow(0).getString(0));
	}

	
	/**
	 * @param pageSize 要设置的 pageSize。
	 */
	public void setPageSize(int pageSize) {
		this.pageSize = pageSize;
	}
}