merchantmemberdao.java

基于struts的网上商店源码

/*
 * 作者:刘云云
 * 时间:2007年11月19日
 * 功能:店铺管理-＞帐户管理
 * 管理商家的帐户
 */
package com.mole.struts.dao;

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

import com.mole.struts.bean.MerchantMemberBean;

public class MerchantMemberDAO extends AbstractDAO {

	// 获取商家帐户的记录集
	public MerchantMemberBean[] getAllStaffInfo(String sql) {

		ArrayList<Object[]> arrayList = executeQuery(sql);
		if (arrayList == null)
			return null;

		MerchantMemberBean[] allstaffinfo = new MerchantMemberBean[arrayList
				.size()];
		Iterator<Object[]> it = arrayList.iterator();
		int i = 0;
		while (it.hasNext()) {
			Object[] obj = it.next();
			MerchantMemberBean staffinfo = new MerchantMemberBean();
			staffinfo.setLoginName(obj[0].toString());
			staffinfo.setRole(Integer.valueOf(obj[1].toString()));
			staffinfo.setState(Integer.valueOf(obj[2].toString()));
			staffinfo.setName(obj[3].toString());
			staffinfo.setGender(obj[4].toString());
			staffinfo.setLastLogin(obj[5].toString().substring(0, 10));
			staffinfo.setId(obj[6].toString());
			allstaffinfo[i++] = staffinfo;
		}
		return allstaffinfo;
	}

	// 获取某一商家帐户的的详情
	public MerchantMemberBean getDetailStaffInfo(String sql) {
		ArrayList<Object[]> arrayList = executeQuery(sql);
		if (arrayList == null)
			return null;
		Object[] obj = arrayList.get(0);

		MerchantMemberBean detailinfo = new MerchantMemberBean();
		detailinfo.setLoginName(obj[0].toString());
		detailinfo.setRole(Integer.valueOf(obj[1].toString()));
		detailinfo.setState(Integer.valueOf(obj[2].toString()));
		detailinfo.setName(obj[3].toString());
		detailinfo.setGender(obj[4].toString());
		detailinfo.setEmail(obj[5].toString());
		detailinfo.setTelephone((String) obj[6]);
		detailinfo.setCellphone((String) obj[7]);
		detailinfo.setCreateDate(obj[8].toString());
		detailinfo.setLastLogin(obj[9].toString());
		detailinfo.setId(obj[10].toString());

		return detailinfo;
	}

	// 检测帐户的角色和状态
	public boolean checkRoleandState(String staffid) {
		String sql = "select Role,State from merchant where id=" + staffid;
		ArrayList<Object[]> arrayList = executeQuery(sql);
		Object[] obj = arrayList.get(0);
		return (Integer) obj[0] == 1 && (Integer) obj[1] == 0;
	}
}