merchantstoreinfodao.java

基于struts的网上商店源码

/*
 * 作者:
 * 时间:2007年11月18日
 * 功能:店铺管理 -＞店铺资料修改
 */
package com.mole.struts.dao;

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

import com.mole.struts.bean.MerchantStoreInfoModifyBean;

public class MerchantStoreInfoDAO extends AbstractDAO {
	// 获取店铺资料
	public MerchantStoreInfoModifyBean getMerchantStoreInfo(String sql) {

		ArrayList<Object[]> al = this.executeQuery(sql);
		if (al == null)
			return null;

		MerchantStoreInfoModifyBean record = null;
		Iterator<Object[]> it = al.iterator();
		while (it.hasNext()) {
			record = new MerchantStoreInfoModifyBean();
			Object[] obj = it.next();
			record.setName(obj[0].toString());
			record.setTypeName(obj[1].toString());
			record.setCityName(obj[2].toString());
			record.setAreaName(obj[3].toString());
			record.setImage(obj[4].toString());
			record.setAddress(obj[5].toString());
			record.setTelephone(obj[6].toString());
			record.setCreateDate(obj[7].toString().substring(0, 10));
			record.setTypeName2(obj[8].toString());
			record.setTypeName3(obj[9].toString());
			record.setTypeName4(obj[10].toString());
		}
		return record;
	}
}