gistfile1.txt

usersDao

package uk.co.inbrand.dao;

import java.util.List;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;

import uk.co.inbrand.hibernate.HibernateUtil;
import uk.co.inbrand.model.Users;
import uk.co.inbrand.model.Organisation;

public class UsersDao {

        public UsersDao(){

        }

	@SuppressWarnings("unchecked")
	public List<Users> listRecords() {
		SessionFactory session = HibernateUtil.getSessionFactory();
		Session sess = session.getCurrentSession();
		Transaction tx = sess.beginTransaction();
		List<Users> tempVec = sess.createQuery("from Users").list();
		tx.commit();
		session.close();
		return tempVec;
	}

        public Users getRecordById(int id) {
		SessionFactory session = HibernateUtil.getSessionFactory();
		Session sess = session.getCurrentSession();
		Transaction tx = sess.beginTransaction();
                Users tempUser = (Users)sess.createQuery("from Users where user_id = ?").setInteger(0,id).uniqueResult();
                return tempUser;
        }


        public Users getRecordByUsername(String userName) {
		SessionFactory session = HibernateUtil.getSessionFactory();
		Session sess = session.getCurrentSession();
		Transaction tx = sess.beginTransaction();
                Users tempUser = (Users)sess.createQuery("from Users where user_name = ?").setString(0,userName).uniqueResult();
                return tempUser;
        }

	@SuppressWarnings("unchecked")
	public List<Users> getUsersForOrganisation(Organisation org) {
		SessionFactory session = HibernateUtil.getSessionFactory();
		Session sess = session.getCurrentSession();
		Transaction tx = sess.beginTransaction();
		List<Users> tempVec =sess.createQuery("from Users as Users where user_organisation = ? order by user_name").setEntity(0, org).list(); 
		tx.commit();
		session.close();
		return tempVec;
	}
	
	public void saveNewRecord(Users recordToSave) {
		SessionFactory session = HibernateUtil.getSessionFactory();
		Session sess = session.getCurrentSession();
		Transaction tx = sess.beginTransaction();
		sess.save(recordToSave);
		tx.commit();
		session.close();
	}

	public void saveOrUpdate(Users recordToSave) {
		SessionFactory session = HibernateUtil.getSessionFactory();
		Session sess = session.getCurrentSession();
		Transaction tx = sess.beginTransaction();
		sess.saveOrUpdate(recordToSave);
		tx.commit();
		session.close();
	}
        
        public void deleteUserById(int id) {
                Users recordToDelete = getRecordById(id);
            	SessionFactory session = HibernateUtil.getSessionFactory();
		Session sess = session.getCurrentSession();
		Transaction tx = sess.beginTransaction();
		sess.delete(recordToDelete);
		tx.commit();
		session.close();
        }
}


userRolesDao

package uk.co.inbrand.dao;

import java.util.List;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;

import uk.co.inbrand.hibernate.HibernateUtil;
import uk.co.inbrand.model.UserRoles;

public class UserRolesDao {

        public UserRolesDao(){

        }

	@SuppressWarnings("unchecked")
	public List<UserRoles> listRecords() {
		SessionFactory session = HibernateUtil.getSessionFactory();
		Session sess = session.getCurrentSession();
		Transaction tx = sess.beginTransaction();
		List<UserRoles> tempVec = sess.createQuery("from UserRoles").list();
		tx.commit();
		session.close();
		return tempVec;
	}

        public UserRoles getRecordById(int id) {
		SessionFactory session = HibernateUtil.getSessionFactory();
		Session sess = session.getCurrentSession();
		Transaction tx = sess.beginTransaction();
                UserRoles tempUser = (UserRoles)sess.createQuery("from UserRoles where id = ?").setInteger(0,id).uniqueResult();
                return tempUser;
        }


        public UserRoles getRecordByRoleCode(String role_code) {
		SessionFactory session = HibernateUtil.getSessionFactory();
		Session sess = session.getCurrentSession();
		Transaction tx = sess.beginTransaction();
                UserRoles tempUser = (UserRoles)sess.createQuery("from UserRoles where role_code = ?").setString(0,role_code).uniqueResult();
                return tempUser;
        }

        public UserRoles getRecordByDescription(String description) {
		SessionFactory session = HibernateUtil.getSessionFactory();
		Session sess = session.getCurrentSession();
		Transaction tx = sess.beginTransaction();
                UserRoles tempUser = (UserRoles)sess.createQuery("from UserRoles where description = ?").setString(0,description).uniqueResult();
                return tempUser;
        }        
	
	public void saveNewRecord(UserRoles recordToSave) {
		SessionFactory session = HibernateUtil.getSessionFactory();
		Session sess = session.getCurrentSession();
		Transaction tx = sess.beginTransaction();
		sess.save(recordToSave);
		tx.commit();
		session.close();
	}

	public void saveOrUpdate(UserRoles recordToSave) {
		SessionFactory session = HibernateUtil.getSessionFactory();
		Session sess = session.getCurrentSession();
		Transaction tx = sess.beginTransaction();
		sess.saveOrUpdate(recordToSave);
		tx.commit();
		session.close();
	}
        
        public void deleteById(int id) {
                UserRoles recordToDelete = getRecordById(id);
            	SessionFactory session = HibernateUtil.getSessionFactory();
		Session sess = session.getCurrentSession();
		Transaction tx = sess.beginTransaction();
		sess.delete(recordToDelete);
		tx.commit();
		session.close();
        }
        
        public void delete(UserRoles domain) {
            	SessionFactory session = HibernateUtil.getSessionFactory();
		Session sess = session.getCurrentSession();
		Transaction tx = sess.beginTransaction();
		sess.delete(domain);
		tx.commit();
		session.close();
        }
}