addressdao.java

来自「电信的网厅的整站代码」· Java 代码 · 共 90 行

package com.doone.fj1w.fjmgr.order;

import com.doone.data.DataRow;
import com.doone.data.DataTable;
import com.doone.util.FileLogger;

public class AddressDAO extends DAO {

	/** The composite primary key value. */
	private java.lang.Long addressid;

	/** The value of the tdArea association. */
	private String areacode;

	/** The value of the tdCity association. */
	private String citycode;

	/** The value of the tfProdorder association. */
	private String prodorderID;

	/** The value of the simple town property. */
	private java.lang.String town;

	/** The value of the simple community property. */
	private java.lang.String community;

	/** The value of the simple doorplate property. */
	private java.lang.String doorplate;
	
	/**
	 * wull 修改。2006-10-19
	 * 因为接口的一些地方需要areaid。所以暂时先在这里加一下参数。
	 */
	private String BSS_AREAID;

	public AddressDAO(String prodorderid) {
		FileLogger.getLogger().debug("AddressDAO 数据库链接" + _dac);
		try {
			DataTable dt = _dac
					.executeQuery("select a.AREACODE,a.CITYCODE,a.PRODORDERID,a.town,a.COMMUNITY,a.DOORPLATE,b.BSS_AREAID"
                       + " from tf_address a,TD_AREA b where a.areacode=b.areacode and a.prodorderid="
							+ prodorderid);
			if(dt != null){
			DataRow dr = dt.getRow(0);
			this.areacode = dr.getString("AREACODE");
			this.citycode = dr.getString("CITYCODE");
			this.town = dr.getString("town");
			this.community = dr.getString("COMMUNITY");
			this.doorplate = dr.getString("DOORPLATE");
			this.BSS_AREAID = dr.getString("BSS_AREAID");
			}

		} catch (Exception e) {
			//FileLogger.getLogger().warn("AddressDAO do not get data!");	
		}

	}
    public String getBSS_AREAID() {
        return BSS_AREAID;
    }
	public java.lang.Long getAddressid() {
		return addressid;
	}

	public String getAreacode() {
		return areacode;
	}

	public String getCitycode() {
		return citycode;
	}

	public java.lang.String getCommunity() {
		return community;
	}

	public java.lang.String getDoorplate() {
		return doorplate;
	}

	public String getProdorderID() {
		return prodorderID;
	}

	public java.lang.String getTown() {
		return town;
	}

}