package com.wlpava.business;

import java.util.Collection;
import java.util.List;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import com.wlpava.business.IUser;
import com.wlpava.business.IUserService;

public class UserDao extends HibernateDaoSupport implements IUserService {

	public List query(String scope, Collection paras) {
		return this.getHibernateTemplate().find("from User where " + scope,
				paras.toArray());
	}

	public IUser login(String userName, String password, String ip) {
		IUser user = readByName(userName);
		if (user == null || user.getPassword() == null || (!user.getPassword().equals(password))) {// 用戶不存在或者密碼不正確
			return null;
		}
		return user;
	}

	public IUser newUser() {
		return new User();
	}

	public IUser read(int cid) {
		return (IUser) this.getHibernateTemplate().get(User.class, new Integer(cid));
	}

	public IUser readByName(String userName) {
		List list = this.getHibernateTemplate().find("from User where userName='" + userName + "'");
		if (list != null && list.size()>0){
			return (IUser) list.get(0);
		}
		else{
			return null;
		}
	}

	public boolean save(IUser user) {
		boolean ret = true;
		if(readByName(user.getUserName())!=null){
			ret = false;
		}
		else{
			try {
				this.getHibernateTemplate().save(user);
			} catch (Exception e) {
				ret = false;
			}
		}
		return ret;
	}

	public boolean update(IUser user) {
		boolean ret = true;
		try {
			this.getHibernateTemplate().update(user);
		} catch (Exception e) {
			e.printStackTrace();
			ret = false;
		}
		return ret;
	}

	public boolean del(IUser user) {
		boolean ret = true;
		try {
			this.getHibernateTemplate().delete(user);
		} catch (Exception e) {
			ret = false;
		}
		return ret;
	}
	
	public boolean del(IUser[] users) {
		boolean ret = true;
		try {
			for(int i=0;i<users.length;i++)
				this.getHibernateTemplate().delete(users[i]);
		} catch (Exception e) {
			ret = false;
		}
		return ret;
	}
}