area.java

电信的网厅的整站代码

/*
 * 创建日期 2005-8-1
 *
 */
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 Area extends DAO {
	/** 区域编码* */
	private String areacode = "";

	/** 地市编码* */
	private String citycode = "";

	/** 区域名称* */
	private String areaname = "";

	/** 禁用* */
	private String state = "";

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

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

	public DataTable getAreaList(int pageNo) {
		DataTable dataTable = null;

		String sql = "select AREACODE,CITYCODE,AREANAME,decode(STATE,'E','启用','D','禁用') state, state estate"
				+ " from td_area order by citycode";
		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 getAreaByCode(String areacode) {
		DataTable dataTable = null;
		String sql = "select AREACODE,CITYCODE,AREANAME,decode(STATE,'E','启用','D','禁用') state, state estate"
				+ " from td_area where AREACODE=? order by citycode";
		Object[] value = new Object[1];
		value[0] = areacode;
		try {
			dataTable = _dac.executeQuery(sql, value);
		} catch (Exception e) {
			FileLogger.getLogger().debug(e.getMessage());
		}
		return dataTable;
	}

	public DataTable getAraeByCityCode(String cityCode) {
		DataTable dataTable = null;
		String sql = "select AREACODE,CITYCODE,AREANAME,decode(STATE,'E','启用','D','禁用') state, state estate"
				+ " from td_area where CITYCODE=? order by citycode";
		
		Object[] value = new Object[1];
		value[0] = cityCode;
		try {
			dataTable = _dac.executeQuery(sql, value);
		} catch (Exception e) {
			FileLogger.getLogger().debug(e.getMessage());
		}
		return dataTable;
	}

	public int getAreaSize() {
		DataTable dataTable = null;
		String sql = "select count(AREACODE) from td_area";
		try {
			dataTable = _dac.executeQuery(sql);
		} catch (Exception e) {
			FileLogger.getLogger().debug(e.getMessage());
		}
		return Integer.parseInt(dataTable.getRow(0).getString(0));
	}

	public void addArea() {
		String sql = "insert into td_area(AREACODE,CITYCODE,AREANAME) values(?,?,?)";
		Object[] value = new Object[3];
		value[0] = this.areacode;
		value[1] = this.citycode;
		value[2] = this.areaname;
		try {
			_dac.executeUpdate(sql, 1000, value);
		} catch (Exception e) {
			FileLogger.getLogger().debug(e.getMessage());
		}
	}

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

	public void updateArea() {
		String sql = "update td_area set CITYCODE=?,AREANAME=?,STATE=? where AREACODE=?";
		Object[] value = new Object[4];
		value[0] = this.citycode;
		value[1] = this.areaname;
		value[2] = this.state;
		value[3] = areacode;
		try {
			_dac.executeUpdate(sql, 1000, value);
		} catch (Exception e) {
			FileLogger.getLogger().debug(e.getMessage());
		}
	}

	public void updateAreaState() {
		String sql = "update td_area set STATE= ? where AREACODE= ?";
		Object[] value = new Object[2];
		value[0] = this.state;
		value[1] = this.areacode;
		try {
			_dac.executeUpdate(sql, 1000, value);
		} catch (Exception e) {
			FileLogger.getLogger().debug(e.getMessage());
		}
	}

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

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

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

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

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