userdao.java

本系统为符合订单管理 精确使用了账号分层用户管理 可进行主订单 次订单的增加 删除功能 实现了全密浏览用品的功能！

package com.hz.user.dao;

import java.util.ArrayList;
import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;

import com.hz.hibernate.HibernateSessionFactory;
import com.hz.hibernate.PublicClass;
import com.hz.pojo.Level;
import com.hz.pojo.Member;

public class UserDAO extends PublicClass implements IUserDAO {

	public Member judgeLogin(String memberName, String memberPass) {
		Member member=null;
		List list=this.queryByProperty("Level","Member","memberName", memberName);
		if(list.size()>0){
			member=(Member)list.get(0);
			if(!member.getMemberPass().equals(memberPass)){
				member.setMemberId(-1);//密码不正确
			}
		}
		return member;
	}
	
	public List queryAllLevel(){
		List list=null;
		list=this.queryAll("Level");
		return list;
	}
	
	public static void main(String[] arg0){
		UserDAO dao=new UserDAO();
		dao.updateBalance(5,1100);
	}

	public void addMember(Member member) {
		this.insert(member);
		
	}

	public List queryAllUser() {
		// TODO Auto-generated method stub
		List list=this.queryAll("Level","Member");
		List lists=new ArrayList();
		for(int i=0;i<list.size();i++){
			Member member=(Member)list.get(i);
			String levelId=member.getLevelId();
			String[] levelIds=this.getStringArray(levelId);
			for(int j=0;j<levelIds.length;j++){
				if("1".equals(levelIds[j])){
					levelIds[j]="超级管理员";
				}else if("2".equals(levelIds[j])){
					levelIds[j]="用户管理员";
				}else if("3".equals(levelIds[j])){
					levelIds[j]="订单管理员";
				}else if("4".equals(levelIds[j])){
					levelIds[j]="商品管理员";
				}else if("5".equals(levelIds[j])){
					levelIds[j]="统计管理员";
				}else if("6".equals(levelIds[j])){
					levelIds[j]="普通用户";
				}
			}
			levelId=this.getString(levelIds);
			member.setLevelId(levelId);
			lists.add(member);
		}
		return lists;
	}

	public void updateMember(Member member) {
		// TODO Auto-generated method stub
		this.update(member);
	}

	public void delMember(String id) {
		Member member=(Member)this.queryById("Level","Member","memberId",Integer.parseInt(id));
		this.delete(member);
	}

	public Member queryMemberById(String id) {
		Member member=(Member)this.queryById("Level","Member","memberId",Integer.parseInt(id));
		return member;
	}

	public void updateBalance(Integer memberId,Integer money) {
		Session session=HibernateSessionFactory.getSessionFactory().openSession();
		Query query=session.createQuery("update from Member set balance=?  where memberId=?");
		query.setInteger(0, money);
		query.setInteger(1, memberId);
		query.executeUpdate();
		session.beginTransaction().commit();
		session.close();
	}

	public void updateLevel(Integer memberId,String[] levelId,String userLevel) {
		String level=this.getString(levelId);
		if(!"1".equals(userLevel)){
			Member member=this.queryMemberById(""+memberId);
			StringBuffer old=new StringBuffer(member.getLevelId());
			String[] olds=this.getStringArray(old.toString());
			for(int i=0;i<levelId.length;i++){
				int a=0;
				for(int j=0;j<olds.length;j++){
					if(!levelId[i].equals(olds[j])){
						a++;
					}
					if(a==olds.length){
						old.append(" "+levelId[i]);
					}
				}
			}
			level=old.toString();

			for(int i=0;i<olds.length;i++){
				if(olds[i].equals("1")){
					level="1";
					break;
				}
			}
		}else{
			for(int i=0;i<levelId.length;i++){
				if(levelId[i].equals("1")){
					level="1";
					break;
				}
			}
		}
		Session session=HibernateSessionFactory.getSessionFactory().openSession();
		Query query=session.createQuery("update from Member set levelId=? where memberId=?");
		query.setString(0, level);
		query.setInteger(1, memberId);
		query.executeUpdate();
		session.beginTransaction().commit();
		session.close();
	}

	public List queryLevelBy(String levels) {
		List lists=new ArrayList();
		String[] level=this.getStringArray(levels);
		Session session=HibernateSessionFactory.getSessionFactory().openSession();
		if("1".equals(levels)){
			Query querys=session.createQuery("from Level where levelId<6");
			lists=querys.list();
		}else{
			
			for(int i=0;i<level.length;i++){
				Query query=session.createQuery("from Level where levelId=?");
				query.setString(0, level[i]);
				List list=query.list();
				Level le=(Level)list.get(0);
				lists.add(le);
				
			}
		}
		session.beginTransaction().commit();
		session.close();
		return lists;
	}

	public Member queryByMemberName(String memberName) {
		Member member=null;
		List list=this.queryByProperty("Level","Member","memberName", memberName);
		if(list.size()>0){
			member=(Member)list.get(0);
		}
		return member;
	}

	public Integer queryBalance(Integer memberId) {
		int balance=0;
		Member member=null;
		List list=this.queryByProperty("Level","Member","memberId", memberId);
		if(list.size()>0){
			member=(Member)list.get(0);
			balance=member.getBalance();
		}
		return balance;
	}

	public List queryWare() {
		List list=this.queryAll("Goods","Ware");
		return list;
	}

	public String getString(String[] name) {
		StringBuffer a=new StringBuffer();
		if(name!=null){
			for(int i=0;i<name.length-1;i++){
				a.append(name[i]+" ");
			}
			a.append(name[name.length-1]);
		}
		return a.toString();
	}

	public String[] getStringArray(String name) {
		String[] a=null;
		if(name!=null || "".equals(name)){
			a=name.split(" ");
		}
		return a;
	}
}