Java tutorial
/* * 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.model.dao; import cl.model.pojos.Workshop; import java.util.List; import org.hibernate.Query; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.Transaction; /** * * @author camilo */ public class WorkshopDAO { public void ingresarWorkshop(Workshop workshop) { SessionFactory sf = null; Session session = null; Transaction tx = null; try { sf = HibernateUtil.getSessionFactory(); session = sf.openSession(); tx = session.beginTransaction(); session.save(workshop); tx.commit(); session.close(); } catch (Exception ex) { tx.rollback(); throw new RuntimeException("No se pudo registrar el workshop"); } } public void modificarWorkshop(Workshop workshop) { SessionFactory sf = null; Session session = null; Transaction tx = null; try { sf = HibernateUtil.getSessionFactory(); session = sf.openSession(); tx = session.beginTransaction(); session.save(workshop); tx.commit(); session.close(); } catch (Exception ex) { tx.rollback(); throw new RuntimeException("No se pudo modificar el workshop"); } } public int consultarWorkshop(int codigo) { SessionFactory sf = HibernateUtil.getSessionFactory(); Session session = sf.openSession(); Workshop workshop = (Workshop) session.get(Workshop.class, codigo); if (workshop != null) { return 1; } else { return 0; } } public List<Workshop> findAll() { SessionFactory sf = HibernateUtil.getSessionFactory(); Session session = sf.openSession(); Query query = session.createQuery("from Workshop"); List<Workshop> lista = query.list(); session.close(); return lista; } public void eliminar(int codigo) { SessionFactory sf = null; Session session = null; Transaction tx = null; try { sf = HibernateUtil.getSessionFactory(); session = sf.openSession(); tx = session.beginTransaction(); session.delete(codigo); tx.commit(); session.close(); } catch (Exception ex) { tx.rollback(); throw new RuntimeException("No se pudo eliminar el workshop"); } } }