package com.yc.dao;
import java.util.Iterator;
import java.util.List;

import org.hibernate.HibernateException;
import org.springframework.orm.hibernate3.HibernateTemplate;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.yc.model.Users;
import com.yc.util.CONSTANTS;

public class RegUserDao extends HibernateDaoSupport {
	
	public Users getUser(String accountNo) {
		//System.out.println(username);
		List listuser;
		Iterator itr = null;
		listuser = getHibernateTemplate().find(
				"from Users u where u.accountNo=?", accountNo);
		if (listuser != null && listuser.size() > 0) {
			itr = listuser.iterator();
			return (Users) itr.next();
		}
		return null;
	}

	public Users getUser(String accountNo,String name,String password,String sex,String phone,String email) throws Exception {

		String[] paramUserList = new String[6];
		paramUserList[0] = accountNo;
		paramUserList[1] =name;
		paramUserList[2] =password;
		paramUserList[3]=sex;
		paramUserList[4]=phone;
		paramUserList[5]=email;
		List listuser;
		List listusername;
		Iterator itr = null;
		try {
			listusername = getHibernateTemplate().find(
					"from Users u where u.accountNo=?", accountNo);

			if (listusername != null && listusername.size() > 0) {
				
				listuser = getHibernateTemplate().find(
						"from Users u where u.accountNo=? and u.name=? and u.password=? and u.sex=? and u.phone=? and u.eamil=?",
						paramUserList);
				if (listuser != null && listuser.size() > 0) {
					itr = listuser.iterator();
					return (Users) itr.next();
				} else {
					throw new HibernateException("error!");
				}

			} else {

				throw new HibernateException("error!");
			}
		} catch (HibernateException e) {
			e.printStackTrace();
			// throw new SelfException(Constants.FINDEXCEPTION);
			return null;
		}
	}

	
	public void RegUser(String accountNo, String name, String password, String sex,
			String phone, String email)
	{
		//System.out.println("test---------");
		Users u=new Users(accountNo,name,password,sex,phone,email);
		try
		{
			HibernateTemplate ht = this.getHibernateTemplate();
			this.getHibernateTemplate().save(u);
		}
		catch(HibernateException e)
		{
			e.printStackTrace();
			//return false;
		}
		//return true;
	}

}