merchantbizgroupattenddao.java

来自「基于struts的网上商店源码」· Java 代码 · 共 130 行

/*
 * 作者:刘云云
 * 时间:2007年11月28日
 * 功能:我的商业合作-＞我参与的商圈 
 * 查看自已参与的商圈
 */
package com.mole.struts.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;

import com.mole.struts.bean.MerchantBizGroupInfoBean;

public class MerchantBizGroupAttendDAO extends AbstractDAO {
	// 获取与参与的商圈的记录集
	public MerchantBizGroupInfoBean[] getAttendBizGroup(String sql) {
		ArrayList<Object[]> arrayList = executeQuery(sql);
		MerchantBizGroupInfoBean[] records = new MerchantBizGroupInfoBean[arrayList
				.size()];
		Iterator<Object[]> it = arrayList.iterator();
		int i = 0;
		while (it.hasNext()) {
			Object[] obj = it.next();
			MerchantBizGroupInfoBean record = new MerchantBizGroupInfoBean();
			record.setId(obj[0].toString());
			record.setName(obj[1].toString());
			record.setActivityDes(obj[2].toString());
			record.setStartDate(obj[3].toString().substring(0, 10));
			record.setEndDate(obj[4].toString().substring(0, 10));
			record.setMemberState(Integer.valueOf(obj[5].toString()));
			record.setStoreId(obj[6].toString());
			record.setMemberId(Integer.valueOf(obj[7].toString()));
			record.setStoreName(obj[8].toString());
			record.setCityName(obj[9].toString());
			record.setAreaName(obj[10].toString());
			record.setTypeName(obj[11].toString());
			record.setState(Integer.valueOf(obj[12].toString()));
			record.setTypeName2(obj[13].toString());
			record.setTypeName3(obj[14].toString());
			record.setTypeName4(obj[15].toString());

			Date currentDate = new Date();
			SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd");
			String dateString = formatter.format(currentDate);
			if (record.getState() == 3) {
				record.setTig("delete");
			} else if (record.getState() == 2
					|| (record.getState() == 1 && dateString.compareTo(record
							.getEndDate()) > 0)
					|| (record.getState() == 0 && dateString.compareTo(record
							.getEndDate()) > 0)) {
				record.setTig("end");
			} else if (record.getState() == 1
					|| (record.getState() == 0
							&& dateString.compareTo(record.getEndDate()) <= 0 && dateString
							.compareTo(record.getStartDate()) >= 0)) {
				record.setTig("start");
			} else {
				record.setTig("ready");
			}

			records[i++] = record;
		}
		return records;
	}

	// 获取商圈的详情
	public MerchantBizGroupInfoBean getPlacardInfo(String sql) {
		ArrayList<Object[]> arrayList = this.executeQuery(sql);
		if (arrayList == null)
			return null;

		Iterator<Object[]> it = arrayList.iterator();
		MerchantBizGroupInfoBean record = null;
		while (it.hasNext()) {
			Object[] obj = it.next();
			record = new MerchantBizGroupInfoBean();
			record.setId(obj[0].toString());
			record.setName(obj[1].toString());
			record.setActivityDes(obj[2].toString());
			record.setStartDate(obj[3].toString().substring(0, 10));
			record.setEndDate(obj[4].toString().substring(0, 10));
			record.setActivityId(obj[5].toString());
			record.setState(Integer.parseInt(obj[6].toString()));
			record.setStoreId(obj[7].toString());
			record.setStoreName(obj[8].toString());
			record.setTypeName(obj[9].toString());
			record.setCityName(obj[10].toString());
			record.setAreaName(obj[11].toString());
			record.setTypeName2(obj[12].toString());
			record.setTypeName3(obj[13].toString());
			record.setTypeName4(obj[14].toString());

		}
		return record;
	}

	// 获取商圈的Placard
	public String getBizGroupPlacard(String sql) {
		Connection conn = getConn();
		PreparedStatement ps = null;
		ResultSet rs = null;
		String str = "";
		try {
			conn.setAutoCommit(true);
			ps = conn.prepareStatement(sql);
			rs = ps.executeQuery();
			while (rs.next()) {
				str = rs.getString(1);
			}
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			try {
				rs.close();
				ps.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		return str;
	}
}