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.SurveyChild;
import com.mySurvey.dao.SurveyChildDAO;

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