surveychilddaoimpl.java

简单的网上调查系统。采用Spring+Hibernate方式设计架构。

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);
	}
}