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

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

import com.mySurvey.bean.Survey;
import com.mySurvey.dao.SurveyDAO;

public class SurveyDAOImpl extends HibernateDaoSupport  implements SurveyDAO{
	private SessionFactory sessionFactory;
	private String hql = "from Survey u where u.id = ?";
	private String hql1 = "from Survey u";
	//查詢多筆調查
    public List queryList() {
		List list = new ArrayList();
		list = this.getHibernateTemplate().find(hql1);
		return list;
    }
	//查詢單筆調查
    public Survey query(Survey survey) {
    	Survey survey1 = null;
    	//如果查詢結果為空
		if (this.getHibernateTemplate().find(hql, survey.getId()) == null ) {
			survey1 = null;
		} else {
			//不為空時，取第一筆
			survey1 = (Survey)(this.getHibernateTemplate().find(hql, survey.getId()).get(0));
		}
		return survey1;
    }
    //新增調查
	public void insert(Survey survey) {
		this.getHibernateTemplate().save(survey);
	}
	//修改調查
	public void update(Survey survey) {
		this.getHibernateTemplate().update(survey);
	}
	//刪除調查
	public void delete(Survey survey) {
		this.getHibernateTemplate().delete(survey);
	}
}