citydao.java

电信的网厅的整站代码

package com.doone.fj1w.fjmgr.order;

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

public class CityDAO extends DAO {

	private String citycode;

	private String cityname;

	private String cityshortname;

	public CityDAO(String FieldName, String FieldValue) {
		FileLogger.getLogger().debug("CityDAO 数据库链接" + _dac);
		DataTable dataTable = null;
		String sql = "select CITYCODE,CITYNAME,CITYSHORTNAME from td_city where "
				+ FieldName + "='" + FieldValue + "'";

		try {

			dataTable = _dac.executeQuery(sql);
			DataRow dr = dataTable.getRow(0);
			citycode = dr.getString("citycode");
			cityname = dr.getString("cityname");
			cityshortname = dr.getString("cityshortname");
		} catch (Exception e) {
			FileLogger.getLogger().error("CityDAO error" + e.getMessage());
		}
	}

	public String getCitycode() {
		return citycode;
	}

	public void setCitycode(String citycode) {
		this.citycode = citycode;
	}

	public String getCityname() {
		return cityname;
	}

	public void setCityname(String cityname) {
		this.cityname = cityname;
	}

	public String getCityshortname() {
		return cityshortname;
	}

	public void setCityshortname(String cityshortname) {
		this.cityshortname = cityshortname;
	}

}