admincityinfodao.java

基于struts的网上商店源码

/*
 * 作者:刘云云
 * 时间:2007年12月22日
 * 功能:平台基础信息维护-开通城市（所在城市）的添加和删除修改（数据库接口）。
 */
package com.mole.struts.dao;

import java.util.ArrayList;
import java.util.Iterator;

import com.mole.struts.bean.AdminProvinceInfoBean;
import com.mole.struts.bean.MerchantCityInfoBean;

public class AdminCityInfoDAO extends AbstractDAO {
	// 获取省份信息记录集
	public AdminProvinceInfoBean[] getAllProvinceInfo() {
		String sql = "SELECT ID,Name FROM province";
		ArrayList<Object[]> arrayList = this.executeQuery(sql);
		if (arrayList == null)
			return null;

		AdminProvinceInfoBean[] records = new AdminProvinceInfoBean[arrayList
				.size()];
		if (records.length == 0)
			return records;

		Iterator<Object[]> it = arrayList.iterator();
		int i = 0;
		while (it.hasNext()) {
			Object[] obj = it.next();
			AdminProvinceInfoBean record = new AdminProvinceInfoBean();
			record.setId(obj[0].toString());
			record.setName(obj[1].toString());
			records[i++] = record;
		}
		return records;
	}

	// 获取城市信息记录集
	public MerchantCityInfoBean[] getAllCityInfo(String sql) {
		ArrayList<Object[]> arrayList = this.executeQuery(sql);
		if (arrayList == null)
			return null;

		MerchantCityInfoBean[] records = new MerchantCityInfoBean[arrayList
				.size()];
		if (records.length == 0)
			return records;

		Iterator<Object[]> it = arrayList.iterator();
		int i = 0;
		while (it.hasNext()) {
			Object[] obj = it.next();
			MerchantCityInfoBean record = new MerchantCityInfoBean();
			record.setId(obj[0].toString());
			record.setName(obj[1].toString());
			records[i++] = record;
		}
		return records;
	}
}