quizfun.model.dao.HibernateModuleDao.java Source code

Introduction

Here is the source code for quizfun.model.dao.HibernateModuleDao.java

Source

/*
 * QuizFun - A quiz game
 * Copyright (C) 2008,2009
 * 
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or (at
 * your option) any later version.
 * 
 * This program is distributed in the hope that it will be useful, but
 * WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
 * General Public License for more details.
 * 
 * You should have received a copy of the GNU General Public License
 * along with this program. If not, see <http://www.gnu.org/licenses/>.
 */

package quizfun.model.dao;

import java.util.ArrayList;
import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.criterion.MatchMode;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Restrictions;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import quizfun.model.dto.CourseSCDO;
import quizfun.model.dto.ModuleSCDO;
import quizfun.model.entity.Module;
import quizfun.model.exception.DuplicateModuleException;

public class HibernateModuleDao extends HibernateDaoSupport implements ModuleDao {

    final Logger logger = LoggerFactory.getLogger(HibernateModuleDao.class);

    @Override
    public void saveModule(Module module) throws DuplicateModuleException {
        if (logger.isDebugEnabled()) {
            logger.info("Saving Module: {}", module);
        }
        Session session = getSession(false);
        try {
            Module existingModule = (Module) session.get(Module.class, module.getCode());
            if (existingModule != null) {
                throw new DuplicateModuleException(module.toString());
            }
            session.save(module);
        } catch (HibernateException ex) {
            throw convertHibernateAccessException(ex);
        }
    }

    @SuppressWarnings("unchecked")
    @Override
    public List<Module> findModule(ModuleSCDO moduleSCDO) {
        if (logger.isDebugEnabled()) {
            logger.debug("Finding Module(s): {}", moduleSCDO);
        }
        List<Module> list = null;
        Session session = getSession(false);
        try {
            String code = moduleSCDO.getCode();
            String name = moduleSCDO.getName();

            CourseSCDO courseSCDO = moduleSCDO.getCourseSCDO();

            String courseCode = courseSCDO.getCode();
            String courseName = courseSCDO.getName();

            Criteria criteria = session.createCriteria(Module.class);
            if (code != null && !code.equals("")) {
                criteria.add(Restrictions.like("code", code, MatchMode.ANYWHERE));
            }
            if (name != null && !name.equals("")) {
                criteria.add(Restrictions.like("name", name, MatchMode.ANYWHERE));
            }

            criteria.addOrder(Order.asc("code"));

            if ((courseCode != null && !courseCode.isEmpty()) || (courseName != null && !courseName.isEmpty())) {
                criteria = criteria.createCriteria("course");
            }

            if (courseCode != null && !courseCode.isEmpty()) {
                criteria.add(Restrictions.like("code", courseCode, MatchMode.ANYWHERE));
            }
            if (courseName != null && !courseName.isEmpty()) {
                criteria.add(Restrictions.like("name", courseName, MatchMode.ANYWHERE));
            }

            list = criteria.list();
        } catch (HibernateException ex) {
            throw convertHibernateAccessException(ex);
        }
        return list;
    }

    @Override
    public Module updateModule(Module module) {
        if (logger.isDebugEnabled()) {
            logger.debug("Updating Module: {}", module);
        }
        Session session = getSession(false);
        try {
            return (Module) session.merge(module);
        } catch (HibernateException ex) {
            throw convertHibernateAccessException(ex);
        }
    }

    @Override
    public void deleteModule(Module module) {
        if (logger.isDebugEnabled()) {
            logger.debug("Deleting Module: {}", module);
        }
        Session session = getSession(false);
        try {
            session.delete(module);
        } catch (HibernateException ex) {
            throw convertHibernateAccessException(ex);
        }
    }

    @SuppressWarnings("unchecked")
    @Override
    public List<Module> findAllModules() {
        if (logger.isDebugEnabled()) {
            logger.debug("Going to find Modules");
        }
        Session session = getSession(false);

        List<Module> modules = new ArrayList<Module>();

        try {
            Criteria criteria = session.createCriteria(Module.class);

            modules = criteria.list();
        } catch (HibernateException e) {
            throw convertHibernateAccessException(e);
        }

        if (modules != null && !modules.isEmpty()) {
            if (logger.isDebugEnabled()) {
                logger.debug("Returning " + modules.size() + " Modules");
            }
            return modules;
        }
        return null;

    }

    @Override
    public Module findModuleByCode(String code) {
        if (logger.isDebugEnabled()) {
            logger.debug("Going to find Module");
        }
        Session session = getSession(false);

        Module module = new Module();
        try {
            module = (Module) session.get(Module.class, code);
        } catch (HibernateException e) {
            throw convertHibernateAccessException(e);
        }

        if (module != null) {
            if (logger.isDebugEnabled()) {
                logger.debug("Returning " + module.getCode() + " Module");
            }
            return module;
        }
        return null;

    }

}