merchantvoucherprovidedao.java

基于struts的网上商店源码

package com.mole.struts.dao;

import java.sql.CallableStatement;
import java.sql.Connection;
import java.util.ArrayList;
import java.util.Iterator;

import com.mole.struts.bean.MerchantVoucherBean;

public class MerchantVoucherProvideDAO extends AbstractDAO {

	public MerchantVoucherBean[] getVoucherInfo(String sql) {
		ArrayList<Object[]> arrayList = this.executeQuery(sql);
		MerchantVoucherBean[] records = new MerchantVoucherBean[arrayList
				.size()];
		Iterator<Object[]> it = arrayList.iterator();
		int i = 0;
		while (it.hasNext()) {
			Object[] obj = it.next();
			MerchantVoucherBean record = new MerchantVoucherBean();
			record.setId(obj[0].toString());
			record.setName(obj[1].toString());
			record.setAmount(Integer.parseInt(obj[2].toString()));
			record.setDiscount(Double.parseDouble(obj[3].toString()));
			records[i++] = record;
		}
		return records;
	}

	public int executeProvideVoucherProcedure(String cardId, int voucherId,
			int amount) throws Exception {
		CallableStatement stmt = null;
		Connection conn = getConn();
		try {
			conn.setAutoCommit(true);
			stmt = conn.prepareCall("{call sp_ProvideVoucher(?,?,?)}");
			stmt.setString(1, cardId);
			stmt.setInt(2, voucherId);
			stmt.setInt(3, amount);
			stmt.executeUpdate();
			return 1;
		} finally {
			if (stmt != null)
				stmt.close();
		}
	}
}