package com.myExam.dao.impl;
import java.util.ArrayList;
import java.util.List;

import org.hibernate.SessionFactory;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.myExam.bean.Exam;
import com.myExam.dao.ExamDAO;
public class ExamDAOImpl extends HibernateDaoSupport implements ExamDAO{
	private SessionFactory sessionFactory;
	private String hql = "from Exam u where u.id = ?";
	private String hql1 = "from Exam u ";
//	查詢多筆試卷
    public List queryList() {
		List list = new ArrayList();
		list = this.getHibernateTemplate().find(hql1);
		return list;
    }
	//查詢試卷
    public Exam query(int id) {
    	Exam exam = null;
    	//如果查詢結(jié)果為空
		if (this.getHibernateTemplate().find(hql, id) == null ) {
			exam = null;
		} else {
			//不為空時，取第一筆
			exam = (Exam)(this.getHibernateTemplate().find(hql, id).get(0));
		}
		return exam;
    }
	//新增試卷
	public void insert(Exam exam) {
		this.getHibernateTemplate().save(exam);
	}
	//修改試卷
	public void update(Exam exam) {
		this.getHibernateTemplate().update(exam);
	}
	//刪除試卷
	public void delete(Exam exam) {
		this.getHibernateTemplate().delete(exam);
	}
}