package com.lh.dao;

import java.util.Calendar;

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

import com.lh.model.User;

/**
 * �����û�ע���¼��DAO������
 * @author LH
 */
public class UserDao {
	private static UserDao instance = null;
	/**
	 * ����һ��UserDaoʵ��
	 * @return
	 */
	public static UserDao getInstance(){
		if(instance==null) instance = new UserDao();
		return instance;
	}
	/**
	 * �����û�ע����Ϣ
	 * @param user
	 * @return
	 */

public boolean saveUser(User user){
	boolean result = false;//����Ƿ񱣴�ɹ�
	Session session = null;//����Sessionʵ��
	Transaction trans = null;//��������
	try{
		
		session = SessionFactoryProvider.getSession();//����Sessionʵ��
		trans=session.beginTransaction();//��ȡ����
		trans.begin();//��ʼ����
		session.save(user);//�������
		trans.commit();//�ύ����
		result=true;
	}catch(Exception ex){
		//�������쳣����ع�
		if(trans!=null&&trans.isActive()) trans.rollback();
		ex.printStackTrace();
	}finally{
		session.close();
	}
	return result;
}
	/**
	 * �޸��û�ע����Ϣ
	 * @param user
	 * @return
	 */
	public boolean updateUser(User user){
		boolean result = false;//����Ƿ񱣴�ɹ�
		Session session = null;//����Sessionʵ��
		Transaction trans = null;//��������
		try{
			//��SessionFactory�������ܻ�ȡSessionʵ��
			session = SessionFactoryProvider.getSession();
			trans=session.beginTransaction();//��ȡ����
			trans.begin();//��ʼ����
			session.update(user);//���¶���
			trans.commit();//�ύ����
			result=true;
		}catch(Exception ex){
			//�������쳣����ع�
			if(trans!=null&&trans.isActive()) trans.rollback();
			ex.printStackTrace();
		}
		return result;
	}
	/**
	 * ��ѯ�����û���Ϣ
	 * @return
	 */
	public User selectUserById(String userId){
		User user = null;
		Session session = null;
		try{
			//��SessionFactory�������ܻ�ȡSessionʵ��
			session = SessionFactoryProvider.getSession();
			Query query = session.createQuery("from User where userId=:id");
			query.setString("id", userId);
			//�Ӳ�ѯ�Ľ����л�ȡ��Userʵ��
			user = (User)query.list().get(0);
		}catch(Exception ex){
			ex.printStackTrace();
		}finally{
			session.close();//�ر�session
		}
		return user;
	}
	/**
	 * ��֤�û���¼
	 * @param userName���û���
	 * @param userPwd������
	 * @return
	 */
public boolean enter(String userName,String userPwd){
	boolean result = false;
	Session session = null;
	try{
		//��SessionFactory�������ܻ�ȡSessionʵ��
		session = SessionFactoryProvider.getSession();	
		//��ѯ�Ƿ��и��û���hql���
		String hql="select count(userId) from User where userName=:name and userPwd=:pwd";
		//����query����
		Query query=session.createQuery(hql);
		//�����û������
		query.setString("name", userName);
		//�����������
		query.setString("pwd", userPwd);
		//���ص�intֵ����ѯ�û��ĸ���
		int userCount=Integer.parseInt(query.list().get(0).toString());
		if(userCount==1) result = true;
	}catch(Exception ex){
		ex.printStackTrace();
	}finally{
		session.close();
	}
	return result;
}
	/**
	 * ����û������������û�����
	 * @param name �û���
	 * @param pwd ����
	 * @return
	 */
	
public User getUserByNameAndPwd(String name,String pwd){
	User user = null;
	Session session = null;
	try{
		session = SessionFactoryProvider.getSession();	//����Sessionʵ��
		String hql=" from User where userName=:name and userPwd=:pwd";//hql���
		Query query=session.createQuery(hql);//����query����
		query.setString("name", name);//�����û������
		query.setString("pwd", pwd);//�����������
		if(query.list()!=null&&query.list().size()>0){//�жϷ��ص�list�����Ƿ�����û���Ϣ����
			user=(User)query.list().get(0);
		}
	}catch(Exception ex){
		ex.printStackTrace();
	}finally{
		session.close();
	}
	return user;
}
	/**
	 * ����û�ע��������û���
	 * �жϸ��û��Ƿ����
	 * @param name
	 * @return ���ڷ���true,�����ڷ���false
	 */
	
public boolean getUserByName(String name){
	boolean result = false;
	Session session = null;
	try{	
		session = SessionFactoryProvider.getSession();	//����Sessionʵ��
		String hql=" from User where userName=:name";	//��ѯ�Ƿ��и��û���hql���
		Query query=session.createQuery(hql);			//����query����
		query.setString("name", name);					//�����û������
		if(query.list()!=null&&query.list().size()>0)	//��ݷ��ص�list���ϣ��ж��Ƿ���ڸ��û�
			result = true;
	}catch(Exception ex){
		ex.printStackTrace();
	}finally{
		session.close();
	}
	return result;
}
}