HIBERNATE

/*
 * 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 empresa;

import Classes.Departamento;
import Classes.Funcionario;
import Util.HibernateUtil;
import java.util.List;
import org.hibernate.Session;
import org.hibernate.Transaction;

/**
 *
 * @author LEO
 */
public class ConexaoHibernate {

    public ConexaoHibernate(){}

    public void inserirDepartamento(Departamento d) throws Exception{

         Session session = HibernateUtil.getSessionFactory().openSession();
        Transaction transaction = session.beginTransaction();
        session.save(d);
        session.flush();
        transaction.commit();
        session.close();


    }

    public List<Departamento> listarDepartamento() throws Exception{

        List<Departamento> departamentos = null;

        Session session = HibernateUtil.getSessionFactory().openSession();
        Transaction transaction = session.beginTransaction();
        departamentos = session.createQuery("from Departamento").list();

        transaction.commit();
        session.flush();
        session.close();


        return departamentos;

    }

    public void excluirDepartamento(Departamento d) throws Exception{

        Session session = HibernateUtil.getSessionFactory().openSession();
        Transaction transaction = session.beginTransaction();
        session.delete(d);
        transaction.commit();
        session.flush();
        session.close();


    }

    public void atualizarDepartamento(Departamento d) throws Exception{

        Session session = HibernateUtil.getSessionFactory().openSession();
        Transaction transaction = session.beginTransaction();
        session.update(d);
        transaction.commit();
        session.flush();
        session.close();

    }

    public void inserirFuncionario(Funcionario f) throws Exception{

         Session session = HibernateUtil.getSessionFactory().openSession();
        Transaction transaction = session.beginTransaction();
        session.save(f);
        transaction.commit();
        session.flush();
        session.close();


    }

    public List<Funcionario> listarFuncionario() throws Exception{

        List<Funcionario> funcionarios = null;

        Session session = HibernateUtil.getSessionFactory().openSession();
        Transaction transaction = session.beginTransaction();
        funcionarios = session.createQuery("from Funcionario").list();
        transaction.commit();
        session.flush();
        session.close();

        return funcionarios;

    }

    public void excluirFuncionario(Funcionario f) throws Exception{

        Session session = HibernateUtil.getSessionFactory().openSession();
        Transaction transaction = session.beginTransaction();
        session.delete(f);
        transaction.commit();
        session.flush();
        session.close();


    }

    public void atualizarFuncionario(Funcionario f) throws Exception{

        Session session = HibernateUtil.getSessionFactory().openSession();
        Transaction transaction = session.beginTransaction();
        session.update(f);
        session.flush();
        transaction.commit();
        session.close();

    }

}