areadao.java

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

package com.doone.fj1w.fjmgr.order;

import java.util.ArrayList;
import java.util.List;

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

public class AreaDAO extends DAO {

	private List areacode = new ArrayList();

	private List citycode = new ArrayList();

	private List areaname = new ArrayList();

	private List state = new ArrayList();

	public AreaDAO(String FieldName, String FieldValue) {
		FileLogger.getLogger().debug("AreaDAO 数据库链接" + _dac);
		DataTable dataTable = null;
		String sql = "select AREACODE,CITYCODE,AREANAME,STATE from td_area where "
				+ FieldName + "= ?";
		Object[] value = new Object[1];
		value[0] = FieldValue;

		try {

			dataTable = _dac.executeQuery(sql, value);

			for (int i = 0; i < dataTable.getRows().getCount(); i++) {
				areacode.add(dataTable.getRow(i).getString("areacode"));
				areaname.add(dataTable.getRow(i).getString("areaname"));
				citycode.add(dataTable.getRow(i).getString("citycode"));
				state.add(dataTable.getRow(i).getString("state"));
			}

		} catch (Exception e) {
			FileLogger.getLogger().debug("AreaDAO 数据库链接" + e.getMessage());
		}
	}

	public List getAreacode() {
		return areacode;
	}

	
	public List getAreaname() {
		return areaname;
	}

	public List getCitycode() {
		return citycode;
	}

	public List getState() {
		return state;
	}
	
}