br.com.financeiro.dao.CategoriaDAOHibernate.java Source code

Introduction

Here is the source code for br.com.financeiro.dao.CategoriaDAOHibernate.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.com.financeiro.dao;

import br.com.financeiro.pojo.Categoria;
import br.com.financeiro.pojo.Usuario;
import java.util.List;
import org.hibernate.Query;
import org.hibernate.Session;

/**
 *
 * @date 
 * @author Eliel
 * @email eliel.floyd@bol.com.br
 *
 */

public class CategoriaDAOHibernate implements CategoriaDAO {
    private Session session;

    public void setSession(Session session) {
        this.session = session;
    }

    @Override
    public Categoria salvar(Categoria categoria) {
        Categoria merged = (Categoria) this.session.merge(categoria);
        this.session.flush();
        this.session.clear();
        return merged;
    }

    @Override
    public void excluir(Categoria categoria) {
        categoria = (Categoria) this.carregar(categoria.getCodigo());
        this.session.delete(categoria);
        this.session.flush();
        this.session.clear();
    }

    @Override
    public Categoria carregar(Integer categoria) {
        return (Categoria) this.session.get(Categoria.class, categoria);
    }

    @Override
    public List<Categoria> listar(Usuario usuario) {
        String hql = "select c from Categoria c where c.pai is null and c.usuario = :usuario";
        Query query = this.session.createQuery(hql);
        query.setInteger("usuario", usuario.getCodigo());

        List<Categoria> lista = query.list();

        return lista;
    }
}