merchantscorepolicydao.java

基于struts的网上商店源码

/*
 * 作者:刘云云
 * 时间:2007年11月11日
 * 功能:店铺管理-＞积分政策。
 */
package com.mole.struts.dao;

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

import com.mole.struts.bean.MerchantScorePolicyBean;

public class MerchantScorePolicyDAO extends AbstractDAO {
	// 获取积分记录集
	public MerchantScorePolicyBean[] getScorePolicy(String id) {
		String sql = "SELECT ID,Score, Discount,description FROM ScoreDiscount WHERE StoreID="
				+ id;
		ArrayList<Object[]> arrayList = executeQuery(sql);
		if (arrayList == null)
			return null;

		MerchantScorePolicyBean[] records = new MerchantScorePolicyBean[arrayList
				.size()];
		Iterator<Object[]> it = arrayList.iterator();
		int i = 0;
		while (it.hasNext()) {
			Object[] obj = it.next();
			MerchantScorePolicyBean record = new MerchantScorePolicyBean();
			record.setId(Integer.valueOf(obj[0].toString()));
			record.setScore(Integer.valueOf(obj[1].toString()));
			record.setDiscount(Double.valueOf(obj[2].toString()));
			record.setDescription(obj[3].toString());
			records[i++] = record;
		}
		return records;
	}

	// 获取一条记录信息
	public MerchantScorePolicyBean getScorePolicyInfo(String id) {
		String sql = "select ID,Score, Discount,description from ScoreDiscount where ID="
				+ id;
		ArrayList<Object[]> al = this.executeQuery(sql);
		Object[] obj = al.get(0);

		MerchantScorePolicyBean record = new MerchantScorePolicyBean();
		record.setId(Integer.valueOf(obj[0].toString()));
		record.setScore(Integer.valueOf(obj[1].toString()));
		record.setDiscount(Double.valueOf(obj[2].toString()));
		record.setDescription(obj[3].toString());

		return record;
	}
}