Q.o.imple

package com.education.vidyarthi.online.Daoimpl;

import java.util.List;

import org.hibernate.SessionFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;

import com.education.vidyarthi.online.Dao.QuestionOptionsDao;
import com.education.vidyarthi.online.model.QuestionOptions;
@Repository("questionOptionsDao")
public class QuestionOptionsDaoImpl implements QuestionOptionsDao {
   
    @Autowired
    private SessionFactory sessionFactory;

   
    public List<QuestionOptions> listQuestionOptions() {
        return sessionFactory.getCurrentSession().createQuery(
                "from QuestionOptions where quesOpId=1").list();
    }

   
    public List<QuestionOptions> getQuestionOptionsByQuestionId(Long questionId) {
        return sessionFactory.getCurrentSession().createQuery(
                "from QuestionOptions where questionId=:questionId")
                .setParameter("questionId", questionId).list();
    }

   
    public List<QuestionOptions> getQuestionOptionsByQuesOpId(Long quesOpId) {
        return sessionFactory.getCurrentSession().createQuery(
                "from QuestionOptions where quesOpId=:quesOpId").setParameter(
                "quesOpId", quesOpId).list();
    }

   
    public void saveQuestionOptions(QuestionOptions questionOptions) {
        sessionFactory.getCurrentSession().saveOrUpdate(questionOptions);
       
    }

   
    public void updateQuestionOptions(QuestionOptions questionOptions) {
        sessionFactory
        .getCurrentSession()
        .createQuery(
                "UPDATE QuestionOptions  SET ansDescription=:ansDescription ,questionId=:questionId where quesOpId=:quesOpId")
        .setParameter("ansDescription",
                questionOptions.getAnsDescription()).setParameter(
                "questionId", questionOptions.getQuestionId())
        .setParameter("quesOpId", questionOptions.getQuesOpId())
        .executeUpdate();
       
    }


    public void deleteQuestionOptionsByQuestionId(Long questionId) {
        sessionFactory.getCurrentSession().createQuery(
                "delete from  QuestionOptions where questionId=:questionId")
                .setParameter("questionId", questionId).executeUpdate();
       
    }

}

Browse More Articles

Tweet

Written by Unknown

We are Creative Blogger Theme Wavers which provides user friendly, effective and easy to use themes. Each support has free and providing HD support screen casting.