AlunoDAO.java: Java Hibernate DAO for Student Management

AlunoDAO.java

import java.util.List;

import model.Aluno;

import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.criterion.Restrictions;

import util.HibernateUtil;

public class AlunoDAO {

Validating a User

public boolean validaUsuario(String login, String senha) {
Session session = HibernateUtil.getSession();
Transaction tx = session.beginTransaction();

String query = "from Aluno where login = ? and senha = ?";

List<Aluno> lista = session.createQuery(query)
.setString(0, login)
.setString(1, senha)
.list();

tx.commit();

Aluno aluno = new Aluno();
if(lista.size() >= 1){
return true;
}else{
return false;
}
}

Listing Students

/**
*
* @return
*/
public List<Aluno> listar() {
Session session = HibernateUtil.getSession();

return session.createCriteria(Aluno.class).list();
}

Updating a Student

/**
*
* @param aluno
*/
public void update(Aluno aluno) {
/*
* Any operation performed on the database requires a session. A session
* may be composed of one or more units of work, and at each commit or
* rollback the session is cleared, making it useless until
* beginTransaction is called again.
*/
Session session = HibernateUtil.getSession();

Transaction tx = session.beginTransaction();

session.update(aluno);

tx.commit();
}

Filtered Listing

/**
*
* @return
*/
public List<Aluno> listarFiltro() {
Session session = HibernateUtil.getSession();
Transaction tx = session.beginTransaction();

List<Aluno> lista = session.createQuery("from Aluno").list();

tx.commit();

return lista;
}

Searching Students

/**
*
* @param nome
* @param login
* @return
*/
public List<Aluno> listarPesquisa(String nome, String login) {
Session session = HibernateUtil.getSession();
Transaction tx = session.beginTransaction();

Criteria crit = session.createCriteria(Aluno.class);

// adds the name to the filter or not
if(nome != null && !nome.equals("")){
crit.add(Restrictions.like("nome", "%"+ nome +"%"));
}

// adds the login to the filter or not
if(login != null && !login.equals("")){
crit.add(Restrictions.like("login", "%"+ login +"%"));
}

List<Aluno> lista = (List<Aluno>) crit.list();

tx.commit();

return lista;
}

Getting a Student by ID

/**
*
* @param id
* @return
*/
public Aluno getAluno(String id) {
Session session = HibernateUtil.getSession();
Transaction tx = session.beginTransaction();

String query = "from Aluno where id = ?";

List<Aluno> lista = session.createQuery(query)
.setLong(0, Long.parseLong(id))
.list();

tx.commit();

Aluno aluno = new Aluno();
if(lista.size() >= 1){
aluno = (Aluno)lista.get(0);
}

return aluno;
}

Deleting a Student

/**
*
* @param aluno
*/
public void delete(Aluno aluno) {
Session session = HibernateUtil.getSession();
Transaction tx = session.beginTransaction();

session.delete(aluno);

tx.commit();
}

Saving a Student

/**
*
* @param aluno
*/
public void save(Aluno aluno){

Session session = HibernateUtil.getSession();
Transaction tx = session.beginTransaction();

session.save(aluno);

tx.commit();

}

}