surveyoptiondaoimpl.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.SurveyOption;
import com.mySurvey.dao.SurveyOptionDAO;

public class SurveyOptionDAOImpl extends HibernateDaoSupport implements SurveyOptionDAO{
	private SessionFactory sessionFactory;
	private String hql = "from SurveyOption u where u.id = ?";
	private String hql1 = "from SurveyOption u where u.surveyId = ?";
	//查询多笔调查项目
    public List queryList(int surveyId) {
		List list = new ArrayList();
		list = this.getHibernateTemplate().find(hql1, surveyId);
		return list;
    }
    public SurveyOption query(SurveyOption surveyOption) {
    	SurveyOption surveyOption1 = null;
    	//如果查询结果为空
		if (this.getHibernateTemplate().find(hql, surveyOption.getId()) == null ) {
			surveyOption1 = null;
		} else {
			//不为空时，取第一笔
			surveyOption1 = (SurveyOption)(this.getHibernateTemplate().find(hql, surveyOption.getId()).get(0));
		}
		return surveyOption1;
    }
    //新增调查项目项目
	public void insert(SurveyOption surveyOption) {
		this.getHibernateTemplate().save(surveyOption);
	}
	//修改调查项目项目
	public void update(SurveyOption surveyOption) {
		this.getHibernateTemplate().update(surveyOption);
	}
	//删除调查项目项目
	public void delete(SurveyOption surveyOption) {
		this.getHibernateTemplate().delete(surveyOption);
	}
}