configmaindao.java

电信的网厅的整站代码

/*
 * 创建日期 2005-7-30
 *
 */
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 ConfigMainDAO extends DAO {

	private String paraname = "";

	private String paradesc = "";

	private int pageSize = 20; // 默认每页20条

	public ConfigMainDAO() {
		FileLogger.getLogger().debug("ConfigMainDAO 数据库链接" + _dac);
	}

	public DataTable getConfigMainList(int pageNo) {
		DataTable dataTable = null;
		String sql = "select t.paraname,t.paradesc from ts_configmain t where output=1 ";

		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 DataTable getConfigMainByParaname(String paraname) {
		DataTable dataTable = null;
		String sql = "select t.paraname,t.paradesc from ts_configmain t where t.paraname=?";
		Object[] value = new Object[1];
		value[0] = paraname;
		try {
			dataTable = _dac.executeQuery(sql, value);
		} catch (Exception e) {
			FileLogger.getLogger().debug(e.getMessage());
		}
		return dataTable;
	}

	public void saveConfigMain() {
		String sql = "update ts_configmain set PARADESC = ? where PARANAME = ?";
		Object[] value = new Object[2];
		value[0] = paradesc;
		value[1] = paraname;
		try {
			_dac.executeUpdate(sql, 1000, value);
		} catch (Exception e) {
			FileLogger.getLogger().debug(e.getMessage());
		}
	}

	public void addConfigMain() {
		String sql = "insert into ts_configmain(PARANAME,PARADESC,OUTPUT) values(?,?,1)";
		Object[] value = new Object[2];
		value[0] = paraname;
		value[1] = paradesc;
		try {
			_dac.executeUpdate(sql, 1000, value);
		} catch (Exception e) {
			e.printStackTrace();
			FileLogger.getLogger().debug(e.getMessage());
		}
	}


	public int getConfigMainSize() {
		DataTable dataTable = null;
		String sql = "select count(t.paraname) from ts_configmain t where output=1 ";
		try {
			dataTable = _dac.executeQuery(sql);
		} catch (Exception e) {
			FileLogger.getLogger().debug(e.getMessage());
		}
		return Integer.parseInt(dataTable.getRow(0).getString(0));
	}

	public void delConfigMain(String paraname) {
		String mainsql = "delete ts_configmain  where paraname=? ";
		String subsql = "delete ts_configsub where paraname= ?";
		Object[] value = new Object[1];
		value[0] = paraname;
		try {
			_dac.beginTransaction(3000);
			_dac.executeUpdate(subsql, 1000, value);

			if (_dac.executeUpdate(mainsql, 1000, value) > 0)
				_dac.endTransaction(true);
			else
				_dac.endTransaction(false);

		} catch (Exception e) {
			e.printStackTrace();
			FileLogger.getLogger().debug(e.getMessage());
			try {
				_dac.endTransaction(false);
			} catch (Exception ee) {
				FileLogger.getLogger().debug(e.getMessage());
			}
		}
	}

	/**
	 * @return 返回 paradesc。
	 */
	public String getParadesc() {
		return paradesc;
	}

	/**
	 * @param paradesc
	 *            要设置的 paradesc。
	 */
	public void setParadesc(String paradesc) {
		this.paradesc = paradesc;
	}

	/**
	 * @return 返回 paraname。
	 */
	public String getParaname() {
		return paraname;
	}

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