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.Shiti;
import com.myExam.dao.ShitiDAO;
public class ShitiDAOImpl extends HibernateDaoSupport implements ShitiDAO{
	private SessionFactory sessionFactory;
	private String hql = "from Shiti u where u.name = ?";
	private String hql1 = "from Shiti u ";
	private String hql2 = "from Shiti u where u.shitiTypeId = ?";
//	查詢多筆試題
    public List queryList() {
		List list = new ArrayList();
		list = this.getHibernateTemplate().find(hql1);
		return list;
    }
//	查詢多筆試題
    public List queryListByTypeId(int typeId) {
		List list = new ArrayList();
		list = this.getHibernateTemplate().find(hql2, typeId);
		return list;
    }
	//查詢試題
    public Shiti query(String name) {
    	Shiti shiti = null;
    	//如果查詢結果為空
		if (this.getHibernateTemplate().find(hql, name) == null ) {
			shiti = null;
		} else {
			//不為空時，取第一筆
			shiti = (Shiti)(this.getHibernateTemplate().find(hql, name).get(0));
		}
		return shiti;
    }
	//新增試題
	public void insert(Shiti shiti) {
		this.getHibernateTemplate().save(shiti);
	}
	//修改試題
	public void update(Shiti shiti) {
		this.getHibernateTemplate().update(shiti);
	}
	//刪除試題
	public void delete(Shiti shiti) {
		this.getHibernateTemplate().delete(shiti);
	}
}