br.ufg.reqweb.dao.DisciplinaDao.java Source code

Introduction

Here is the source code for br.ufg.reqweb.dao.DisciplinaDao.java

Source

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package br.ufg.reqweb.dao;

import br.ufg.reqweb.model.Curso;
import br.ufg.reqweb.model.Disciplina;
import java.util.ArrayList;
import java.util.List;
import org.hibernate.Criteria;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.criterion.MatchMode;
import org.hibernate.criterion.Restrictions;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Scope;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.Transactional;

/**
 *
 * @author andre
 */
@Repository
@Scope(value = "singleton")
public class DisciplinaDao {

    @Autowired
    private SessionFactory sessionFactory;

    @Transactional
    public void adicionar(Disciplina disciplina) {
        this.sessionFactory.getCurrentSession().save(disciplina);
    }

    @Transactional
    public void adicionar(List<Disciplina> disciplinas) {
        Session session = this.sessionFactory.getCurrentSession();
        int counter = 0;
        boolean codigoExists;
        List<Long> codigoValues = session.createQuery("SELECT codigo FROM Disciplina d").list();
        for (Disciplina d : disciplinas) {
            codigoExists = codigoValues.contains(d.getCodigo());
            if (!codigoExists) {
                this.sessionFactory.getCurrentSession().save(d);
            }
        }
    }

    @Transactional
    public void atualizar(Disciplina disciplina) {
        this.sessionFactory.getCurrentSession().update(disciplina);
    }

    @Transactional
    public void excluir(Disciplina disciplina) {
        this.sessionFactory.getCurrentSession().delete(disciplina);
    }

    @Transactional(readOnly = true)
    public Disciplina findById(Long id) {
        Disciplina disciplina;
        try {
            disciplina = (Disciplina) this.sessionFactory.getCurrentSession().get(Disciplina.class, id);
        } catch (HibernateException e) {
            System.out.println("query error: " + e.getMessage());
            disciplina = null;
        }
        return disciplina;
    }

    @Transactional(readOnly = true)
    public List<Disciplina> findByCurso(String termo, Curso curso) {
        try {
            Criteria criteria = this.sessionFactory.getCurrentSession().createCriteria(Disciplina.class);
            if (!termo.isEmpty()) {
                criteria.add(Restrictions.and((Restrictions.like("nome", termo, MatchMode.ANYWHERE).ignoreCase())));
            }
            if (curso != null) {
                criteria.add(Restrictions.and(Restrictions.eq("curso", curso)));
            }
            return criteria.list();
        } catch (HibernateException | NumberFormatException e) {
            System.out.println("query error: " + e.getMessage());
            return new ArrayList<>();
        }
    }

    @Transactional(readOnly = true)
    public List<Disciplina> find(String termo) {
        try {
            List<Disciplina> disciplinas = this.sessionFactory.getCurrentSession().createCriteria(Disciplina.class)
                    .add(Restrictions.like("nome", termo, MatchMode.ANYWHERE).ignoreCase()).list();
            return disciplinas;
        } catch (HibernateException | NumberFormatException e) {
            System.out.println("query error: " + e.getMessage());
            return new ArrayList<>();
        }
    }

    @Transactional(readOnly = true)
    public List<Disciplina> find(int firstResult, int maxResult) {
        try {
            List<Disciplina> disciplinas = this.sessionFactory.getCurrentSession()
                    .createQuery("FROM Disciplina d ORDER BY d.nome").setFirstResult(firstResult)
                    .setMaxResults(maxResult).list();
            return disciplinas;
        } catch (HibernateException e) {
            System.out.println("query error: " + e.getMessage());
            return new ArrayList<>();

        }
    }

    @Transactional(readOnly = true)
    public List<Disciplina> findAll() {
        try {
            List<Disciplina> disciplinas = this.sessionFactory.getCurrentSession()
                    .createQuery("SELECT d FROM Disciplina d ORDER BY d.curso.sigla ASC").list();
            return disciplinas;
        } catch (HibernateException | NumberFormatException e) {
            System.out.println("query error: " + e.getMessage());
            return new ArrayList<>();
        }
    }

    @Transactional(readOnly = true)
    public int count() {
        try {
            int result = ((Long) this.sessionFactory.getCurrentSession()
                    .createQuery("SELECT COUNT(d) FROM Disciplina d").uniqueResult()).intValue();
            return result;
        } catch (HibernateException e) {
            System.out.println("query error: " + e.getMessage());
            return 0;
        }
    }
}