/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package maissocial.repositorio;
import java.util.List;
import maissocial.entidade.Pis;
import maissocial.util.HibernateUtil;
import org.hibernate.SQLQuery;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
/**
*
* @author luciano
*/
public class PisRepositorio {
SessionFactory factory = HibernateUtil.getSessionFactory();
public void salvarPis(Pis pis){
Session session = factory.openSession();
Transaction trans = session.beginTransaction();
trans.begin();
session.save(pis);
trans.commit();
session.close();
}
public void deletarPis(int cod){
Session session = factory.openSession();
Transaction trans = session.beginTransaction();
trans.begin();
Pis pis = pesquisarPisPorCodigo(cod);
session.delete(pis);
trans.commit();
session.close();
}
public void deletarPisPorObj(Pis pis){
Session session = factory.openSession();
Transaction trans = session.beginTransaction();
trans.begin();
session.delete(pis);
trans.commit();
session.close();
}
public Pis pesquisarPisPorCodigo(int cod){
Session session = factory.openSession();
SQLQuery query = session.createSQLQuery("SELECT {pis.*} FROM pis {pis} WHERE cod_pis = "+cod);
query.addEntity("pis", Pis.class);
Pis pis = null;
if(query.list().size() > 0){
pis = (Pis) query.list().get(0);
}
session.close();
return pis;
}
public Pis pesquisarPisPorDescricao(String desc){
Session session = factory.openSession();
SQLQuery query = session.createSQLQuery("SELECT {pis.*} FROM pis {pis} WHERE nome like '"+desc+"'");
query.addEntity("pis", Pis.class);
Pis pis = null;
if(query.list().size() > 0){
pis = (Pis) query.list().get(0);
}
session.close();
return pis;
}
public List pesquisarPisTodos(){
Session session = factory.openSession();
SQLQuery query = session.createSQLQuery("SELECT {pis.*} FROM pis {pis}");
query.addEntity("pis", Pis.class);
List pis = query.list();
session.close();
return pis;
}
public void alterarPis(Pis pis){
Session session = factory.openSession();
Transaction trans = session.beginTransaction();
trans.begin();
Pis pis2 = pesquisarPisPorCodigo(pis.getCodPis());
pis.setCodPis(pis2.getCodPis());
session.update(pis);
trans.commit();
session.close();
}
}