cl.cesfam.DAO.MedicamentoDAO.java Source code

Introduction

Here is the source code for cl.cesfam.DAO.MedicamentoDAO.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 cl.cesfam.DAO;

import java.util.List;
import org.hibernate.Session;
import org.hibernate.criterion.Restrictions;

/**
 *
 * @author Francisco
 */
public class MedicamentoDAO {
    public static boolean add(cl.cesfam.ENTITY.Medicamento a) throws Exception {
        Session sessionA = cl.cesfam.DAL.NewHibernateUtil.getSessionFactory().openSession();
        sessionA.beginTransaction();
        try {
            sessionA.save(a);
            sessionA.getTransaction().commit();
            sessionA.close();
            return true;
        } catch (Exception e) {
            sessionA.getTransaction().rollback();
            sessionA.close();
            System.err.println(e.getMessage());
            throw e;
        }
    }

    public static List<cl.cesfam.ENTITY.Medicamento> getList() throws Exception {
        Session session = cl.cesfam.DAL.NewHibernateUtil.getSessionFactory().openSession();
        session.beginTransaction();
        try {
            List<cl.cesfam.ENTITY.Medicamento> lista = (List<cl.cesfam.ENTITY.Medicamento>) session
                    .createCriteria(cl.cesfam.ENTITY.Medicamento.class).list();
            session.getTransaction().commit();
            return lista;
        } catch (Exception e) {
            session.getTransaction().rollback();
            session.close();
            System.err.println(e.getMessage());
            throw e;
        } finally {
            session.close();
        }
    }

    public static boolean delete(cl.cesfam.ENTITY.Medicamento a) throws Exception {
        Session session = cl.cesfam.DAL.NewHibernateUtil.getSessionFactory().openSession();
        session.beginTransaction();
        try {
            session.delete(a);
            session.getTransaction().commit();
            session.close();
            return true;
        } catch (Exception e) {
            session.getTransaction().rollback();
            session.close();
            System.err.println(e.getMessage());
            throw e;
        }
    }

    public static boolean update(cl.cesfam.ENTITY.Medicamento a) throws Exception {
        Session session = cl.cesfam.DAL.NewHibernateUtil.getSessionFactory().openSession();
        session.beginTransaction();
        try {
            session.update(a);
            session.getTransaction().commit();
            session.close();
            return true;
        } catch (Exception e) {
            session.getTransaction().rollback();
            session.close();
            System.err.println(e.getMessage());
            throw e;
        }
    }

    public static cl.cesfam.ENTITY.Medicamento getMedicamentoByName(String nombre) throws Exception {
        Session session = cl.cesfam.DAL.NewHibernateUtil.getSessionFactory().openSession();
        try {
            session.beginTransaction();
            cl.cesfam.ENTITY.Medicamento tmp = (cl.cesfam.ENTITY.Medicamento) session
                    .createCriteria(cl.cesfam.ENTITY.Medicamento.class)
                    .add(Restrictions.eq("nombreMedicamento", nombre)).uniqueResult();
            session.getTransaction().commit();
            session.close();
            return tmp;
        } catch (Exception e) {
            System.err.print(e.getMessage());
            session.close();
            throw e;
        }
    }

    public static cl.cesfam.ENTITY.Medicamento getMedicamentoById(int id) throws Exception {
        Session session = cl.cesfam.DAL.NewHibernateUtil.getSessionFactory().openSession();
        try {
            session.beginTransaction();
            cl.cesfam.ENTITY.Medicamento tmp = (cl.cesfam.ENTITY.Medicamento) session
                    .createCriteria(cl.cesfam.ENTITY.Medicamento.class).add(Restrictions.eq("idMedicamento", id))
                    .uniqueResult();
            session.getTransaction().commit();
            session.close();
            return tmp;
        } catch (Exception e) {
            System.err.print(e.getMessage());
            session.close();
            throw e;
        }
    }

}