configsubdao.java

电信的网厅的整站代码

/*
 * 创建日期 2005-7-31
 *

 */
package com.doone.fj1w.fjmgr.monitor;

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

/**
 * @author huzcx
 *
 */
public class ConfigSubDAO extends DAO {

	private String paraid = "";

	private String paraname = "";

	private String paravalue = "";

	private String paradesc = "";

	private String paraother = "";

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

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

	public DataTable getConfigSubList(int pageNo) {
		DataTable dataTable = null;
		String sql = "select t.CITYCODE,t.PARAID,t.PARANAME,t.PARAVALUE,t.PARASTATE,t.PARADESC,t.PARAOTHER from ts_configsub t where t.PARASYS=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 getConfigSubByID(String PARAID) {
		DataTable dataTable = null;
		String sql = "select t.CITYCODE,t.PARAID,t.PARANAME,t.PARAVALUE,t.PARASTATE,t.PARADESC,t.PARAOTHER from ts_configsub t where t.PARAID=? ";
		Object[] value = new Object[1];
		value[0] = PARAID;
		try {
			dataTable = _dac.executeQuery(sql, value);
		} catch (Exception e) {
			FileLogger.getLogger().debug(e.getMessage());
		}
		return dataTable;
	}

	public DataTable getConfigSubByParaname(String paraname) {
		DataTable dataTable = null;
		String sql = "select t.CITYCODE,t.PARAID,t.PARANAME,t.PARAVALUE,t.PARASTATE,t.PARADESC,t.PARAOTHER from ts_configsub 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 int getConfigSubSize() {
		DataTable dataTable = null;
		String sql = "select count(t.paraname) from ts_configsub t where t.PARASYS=1 ";

		try {
			dataTable = _dac.executeQuery(sql);
		} catch (Exception e) {
			FileLogger.getLogger().debug(e.getMessage());
		}
		return Integer.parseInt(dataTable.getRow(0).getString(0));
	}

	public void addConfigSub() {
		String sql = "insert into ts_configsub(PARAID,PARANAME,PARAVALUE,PARADESC,PARAOTHER)"
				+ " values(seq_paraid.nextval,?,?,?,?) ";
		Object[] value = new Object[4];
		value[0] = this.paraname;
		value[1] = this.paravalue;
		value[2] = this.paradesc;
		value[3] = this.paraother;
//		StringBuffer s=new StringBuffer();
//		s.append("insert into ts_configsub(");
//		s.append("PARAID,PARANAME,PARAVALUE,PARADESC,PARAOTHER)");
//		s.append(" values(");
//		s.append("seq_paraid.nextval,");
//		s.append(this.paraname);
//		s.append(",");
//		s.append(this.paravalue);
//		s.append(",");
//		s.append(this.paradesc);
//		s.append(",");
//		s.append(this.paraother);
//		s.append(")");
//		System.out.println("s======>"+s.toString()) ;

//
//		System.out.println(this.paraname);
//		System.out.println(this.paravalue);
//		System.out.println(this.paradesc);
//		System.out.println(this.paraother);
//		System.out.println(value);
//		System.out.println("sql===>"+sql) ;

		try {
			_dac.executeUpdate(sql, 1000, value);
		} catch (Exception e) {
			FileLogger.getLogger().debug(e.getMessage());
		}
	}

	public void updateConfigSub() {
		String sql = "update ts_configsub set PARAVALUE=?,PARADESC=?,PARAOTHER=? where PARAID= ?";

		Object[] value = new Object[4];
		value[0] = this.paravalue;
		value[1] = this.paradesc;
		value[2] = this.paraother;
		value[3] = this.paraid;
		try {
			int timeout=1000;
			_dac.executeUpdate(sql, timeout, value);
		} catch (Exception e) {
			FileLogger.getLogger().debug(e.getMessage());
		}
	}

	public void delConfigSub(String id) {
		String sql = "delete ts_configsub where PARAID=?";
		Object[] value = new Object[1];
		value[0] = id;
		try {
			_dac.executeUpdate(sql, 1000, value);
		} catch (Exception e) {
			FileLogger.getLogger().debug(e.getMessage());
		}

	}

        /**
         * 用来更新单个状态。
         * wull 2005.12.29
         * @param citycode String
         * @param paravalue String
         * @param paraname String
         */
        public String UpdateConfigSinSub(String citycode, String paravalue,
                                       String paraname) {
            String sql =
                    "update ts_configsub set PARAVALUE=? where CITYCODE= ? and PARANAME = ?";

            Object[] value = new Object[3];
            value[0] = paravalue;
            value[1] = citycode;
            value[2] = paraname;
            int i = 0;
            try {
                int timeout = 1000;
                i =_dac.executeUpdate(sql, timeout, value);
            } catch (Exception e) {
                FileLogger.getLogger().debug(e.getMessage());
            }
            return String.valueOf(i);
        }

        /**
         * 取出状态
         * wull 2005.12.29
         * @param paraname String
         * @param citycode String
         * @return DataTable
         */
        public DataTable getConfigSubByParaname(String paraname, String citycode) {
            DataTable dataTable = null;
            String sql = "select t.CITYCODE,t.PARAID,t.PARANAME,t.PARAVALUE,t.PARASTATE,t.PARADESC,t.PARAOTHER from ts_configsub t where t.PARANAME=? and  t.CITYCODE=? ";
            Object[] value = new Object[2];
            value[0] = paraname;
            value[1] = citycode;
            try {
                dataTable = _dac.executeQuery(sql, value);
            } catch (Exception e) {
                FileLogger.getLogger().debug(e.getMessage());
            }
            return dataTable;
        }



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

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

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

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

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

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