/* * The MIT License * * Copyright 2012 Universidad de Montemorelos A. C. * * Permission is hereby granted, free of charge, to any person obtaining a copy * of this software and associated documentation files (the "Software"), to deal * in the Software without restriction, including without limitation the rights * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell * copies of the Software, and to permit persons to whom the Software is * furnished to do so, subject to the following conditions: * * The above copyright notice and this permission notice shall be included in * all copies or substantial portions of the Software. * * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN * THE SOFTWARE. */ package mx.edu.um.escuela.dao; import java.util.List; import mx.edu.um.escuela.model.Alumno; import org.hibernate.Query; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.slf4j.Logger; import org.slf4j.LoggerFactory; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Repository; import org.springframework.transaction.annotation.Transactional; /** * * @author J. David Mendoza <jdmendoza@um.edu.mx> */ @Repository("alumnoDao") @Transactional public class AlumnoDaoHibernate implements AlumnoDao { private static final Logger log = LoggerFactory.getLogger(AlumnoDaoHibernate.class); @Autowired private SessionFactory sessionFactory; private Session currentSession() { return sessionFactory.getCurrentSession(); } public AlumnoDaoHibernate() { } @Transactional(readOnly = true) @Override public List<Alumno> lista() { log.debug("Obteniendo lista de alumnos"); Query query = currentSession().createQuery("select a from Alumno a order by a.matricula"); List<Alumno> alumnos = query.list(); return alumnos; } @Override public Alumno crea(final Alumno alumno) { log.debug("Creando al alumno {}", alumno); currentSession().save(alumno); currentSession().flush(); return alumno; } @Override public Alumno actualiza(Alumno alumno) { log.debug("Actualizando al alumno {}", alumno); currentSession().update(alumno); currentSession().flush(); return alumno; } @Override public String elimina(Alumno alumno) { log.debug("Eliminando al alumno {}", alumno); String matricula = alumno.getMatricula(); currentSession().delete(alumno); currentSession().flush(); return matricula; } @Override public Alumno obtiene(String matricula) { log.debug("Obteniendo al alumno con la matricula {}", matricula); Query query = currentSession().createQuery("select a from Alumno a where matricula = :matricula"); query.setString("matricula", matricula); return (Alumno) query.uniqueResult(); } }