adminmemberdao.java

基于struts的网上商店源码

/*
 * 作者:荆明君
 * 时间:2007年12月15日
 * 功能:平台操作人员管理-添加删除和浏览平台操作人员(账户管理)（数据库接口）。
 */
package com.mole.struts.dao;

import java.util.ArrayList;

import com.mole.struts.bean.AdminMemberBean;

public class AdminMemberDAO extends AbstractDAO {
	// 检测平台账户权限：超级管理员返回TRUE，普通管理员返回FALSE
	public boolean checkRole(String loginId) {
		String sql = "SELECT Role FROM [administrator] WHERE ID=" + loginId;
		ArrayList<Object[]> list = executeQuery(sql);
		Object[] obj = list.get(0);
		if (obj[0].toString().equals("1")) {
			return true;
		} else {
			return false;
		}
	}

	// 获取平台管理员帐户记录集
	public AdminMemberBean[] getMemberInfo(String LoginID) {
		String sql = "Select LoginName,Name,Gender,Role,State,lastLogin,ID from [administrator]where ID<>"
				+ LoginID;
		ArrayList<Object[]> list = executeQuery(sql);

		AdminMemberBean[] memberInfo = new AdminMemberBean[list.size()];

		for (int i = 0; i < list.size(); i++) {
			Object[] obj = list.get(i);
			AdminMemberBean info = new AdminMemberBean();
			info.setLoginName(obj[0].toString());
			info.setName(obj[1].toString());
			info.setGender(obj[2].toString());
			info.setRole(obj[3].toString());
			info.setState(obj[4].toString());
			info.setLastLogin(obj[5].toString().substring(0, 10));
			info.setId(obj[6].toString());
			memberInfo[i] = info;
		}
		return memberInfo;
	}

	// 获取一个管理员账户的个人资料
	public AdminMemberBean getMemberDetail(String memberId) {
		AdminMemberBean info = new AdminMemberBean();
		String sql = "SELECT LoginName,Password,Role,State,Name,Gender,ISNULL(Email,''),ISNULL(Telephone,''),ISNULL(CellPhone,''),ISNULL(Address,''),CreateDate,LastLogin,Id from [administrator] where ID="
				+ memberId;
		ArrayList<Object[]> list = executeQuery(sql);

		Object[] obj = list.get(0);
		info.setLoginName(obj[0].toString());
		info.setPassword(obj[1].toString());
		info.setRole(obj[2].toString());
		info.setState(obj[3].toString());
		info.setName(obj[4].toString());
		info.setGender(obj[5].toString());
		info.setEmail(obj[6].toString());
		info.setTelephone(obj[7].toString().trim());
		if (info.getTelephone() == null || info.getTelephone().equals(""))
			info.setTelephone("尚无");
		info.setCellphone(obj[8].toString());
		if (info.getCellphone() == null || info.getCellphone().equals(""))
			info.setCellphone("尚无");
		info.setAddress(obj[9].toString());
		if (info.getAddress() == null || info.getAddress().equals(""))
			info.setAddress("尚无");
		info.setCreateDate(obj[10].toString().substring(0, 10));
		info.setLastLogin(obj[11].toString().substring(0, 10));
		info.setId(obj[12].toString());
		return info;
	}
}