package com.dao.hibernate;

import java.util.Iterator;
import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

import com.vo.struts.form.EnrolForm;

public class LoginDAOImpl implements LoginDAO {
	// 在hibernate中，所有的操作都是通過Session完成,此Session不同于jsp中的Session
	private Session session = null;

	private EnrolForm ef = null;

	// 在構造方法之中實例化Session對象
	public LoginDAOImpl() {
		// 找到hibernate配置
		Configuration config = new Configuration().configure();
		// 從配置中取出SessionFactory
		SessionFactory factory = config.buildSessionFactory();
		// 從SessionFactory中取出一個Session
		this.session = factory.openSession();
	}

	// 用戶登陸查詢
	public EnrolForm queryByUsername(String username, String password) {
		try {
			// 使用hiberbate查詢語言
			String hql = "from EnrolForm as ef where ef.username = ?";
			// 通過Query接口查詢
			Query q = this.session.createQuery(hql);
			q.setString(0, username);
			List list = q.list();
			Iterator iter = list.iterator();
			if (iter.hasNext()) {
				ef = (EnrolForm) iter.next();
				if (username.equals(ef.getUsername())
						&& password.equals(ef.getPassword())) {
					return ef;
				}
			}
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			// 關閉Session
			this.session.close();
		}
		return null;
	}

	// 用戶注冊新增操作
	public Boolean insert(EnrolForm enrol) {
		try {
			// 開始事物
			Transaction tran = this.session.beginTransaction();
			// 執行語句
			this.session.save(enrol);
			// 提交事物
			tran.commit();
			return true;
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			// 關閉Session
			this.session.close();
		}
		return false;
	}
}