daohelper.java

电信的网厅的整站代码

package com.doone.fj1w.common;

import com.doone.data.DacClient;
import com.doone.data.DataTable;

/**
 * 持久帮助.
 * @author wushaol
 *
 */
public abstract class DAOHelper {

	/**
	 * 分页帮助.
	 * @param start
	 * @param end
	 * @param sql
	 * @param _param
	 * @return
	 * @throws java.sql.SQLException
	 */
	public static DataTable executePageList(int start, int end, String sql,
			Object[] _param) throws java.sql.SQLException {
		
		StringBuffer _sb = new StringBuffer();
		_sb.append("SELECT * FROM ( SELECT row_.*, rownum rownum_ FROM(");
		_sb.append(sql);
		_sb.append(")row_ WHERE rownum <=");
		_sb.append(end);
		_sb.append(") WHERE rownum_ >");
		_sb.append(start);
		
		DacClient client = new DacClient();
		if (_param == null || _param.length == 0) {
			return client.executeQuery(_sb.toString());
		} else {
			return client.executeQuery(_sb.toString(), _param);
		}
	}
	
}