merchantcustomerbizrecorddao.java

基于struts的网上商店源码

package com.mole.struts.dao;

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

import com.mole.struts.bean.merchantBusinessRecordDetailBean;

public class MerchantCustomerBizRecordDAO extends AbstractPageDAO {

	public MerchantCustomerBizRecordDAO(String column, String where, String id,
			String group, String order, int pageSize) {
		this.setColumnCondition(column);
		this.setWhereCondition(where);
		this.setIdCondition(id);
		this.setGroupCondition(group);
		this.setOrderCondition(order);
		this.setPageSize(pageSize);
	}

	public merchantBusinessRecordDetailBean[] getAllBizRecordInfo() {

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

		merchantBusinessRecordDetailBean[] records = new merchantBusinessRecordDetailBean[arrayList
				.size()];
		Iterator<Object[]> it = arrayList.iterator();
		int i = 0;
		while (it.hasNext()) {
			Object[] obj = it.next();
			merchantBusinessRecordDetailBean record = new merchantBusinessRecordDetailBean();
			record.setSwiftId(obj[0].toString());
			record.setGoodsName(obj[1].toString());
			record.setGoodsId(obj[2].toString());
			record.setAmount(obj[3].toString());
			record.setFactPrice(obj[4].toString());
			record.setNominalPrice(obj[5].toString());
			record.setDiscount(obj[6].toString());
			record.setGoodsNumber(obj[7].toString());
			records[i++] = record;
		}
		return records;
	}

}