thoerup/hibertest1/EmployeeDAO.java

package dk.thoerup.hibertest1;

import java.util.List;

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

public class EmployeeDAO {
        
        
        @SuppressWarnings("unchecked")
        public List<Employee> getAll() {
                Session session = HibernateUtil.getSessionFactory().openSession();
                Transaction tx = session.beginTransaction(); // Dummy Transcaction

            Criteria c = session.createCriteria(Employee.class);
            java.util.List<Employee> list  = c.list();
            tx.rollback(); //since no changes was made, just as well rollback
            session.close();
           
            return list;
        }
        
        public void saveEmployee(Employee emp) {
                Session session = HibernateUtil.getSessionFactory().getCurrentSession();
                                
                Transaction tx = session.beginTransaction();
                //session.save(emp); persist could be used here
                session.persist(emp);
            tx.commit();

            //don't close if we're using getCurrentSession
            //session.close();
        }
        public void updateEmployee(Employee emp) {
                Session session = HibernateUtil.getSessionFactory().openSession();
                                
                Transaction tx = session.beginTransaction();
                session.update(emp);
            tx.commit();
            session.close();

        }
        
        @SuppressWarnings("unchecked")
        public List<Employee> getEmployeesByName(String name) {
                Session session = HibernateUtil.getSessionFactory().getCurrentSession();
                
                Transaction tx = session.beginTransaction();
                Criteria c = session.createCriteria(Employee.class);
                c.add( Restrictions.ilike("name", name, MatchMode.ANYWHERE) );
                List<Employee> emps = c.list();
                
                tx.rollback();
                return emps;
        }
        
        public Employee getEmployeeById(int id) {
                Session session = HibernateUtil.getSessionFactory().getCurrentSession();
                
                Transaction tx = session.beginTransaction();
                Criteria c = session.createCriteria(Employee.class);
                c.add( Restrictions.eq("id", id));
                Employee emp = (Employee) c.uniqueResult();
                
                tx.rollback();
                return emp;
        }
        
        public void deleteEmployee(Employee emp) {
                Session session = HibernateUtil.getSessionFactory().getCurrentSession();
                
                Transaction tx = session.beginTransaction();
                session.delete(emp);
                tx.commit();            
        }
}
1	torben	599	package dk.thoerup.hibertest1;
2
3			import java.util.List;
4
5			import org.hibernate.Criteria;
6			import org.hibernate.Session;
7			import org.hibernate.Transaction;
8			import org.hibernate.criterion.MatchMode;
9			import org.hibernate.criterion.Restrictions;
10
11			public class EmployeeDAO {
12
13
14			@SuppressWarnings("unchecked")
15			public List<Employee> getAll() {
16			Session session = HibernateUtil.getSessionFactory().openSession();
17			Transaction tx = session.beginTransaction(); // Dummy Transcaction
18
19			Criteria c = session.createCriteria(Employee.class);
20			java.util.List<Employee> list = c.list();
21			tx.rollback(); //since no changes was made, just as well rollback
22			session.close();
23
24			return list;
25			}
26
27			public void saveEmployee(Employee emp) {
28			Session session = HibernateUtil.getSessionFactory().getCurrentSession();
29
30			Transaction tx = session.beginTransaction();
31			//session.save(emp); persist could be used here
32			session.persist(emp);
33			tx.commit();
34
35			//don't close if we're using getCurrentSession
36			//session.close();
37			}
38			public void updateEmployee(Employee emp) {
39			Session session = HibernateUtil.getSessionFactory().openSession();
40
41			Transaction tx = session.beginTransaction();
42			session.update(emp);
43			tx.commit();
44			session.close();
45
46			}
47
48			@SuppressWarnings("unchecked")
49			public List<Employee> getEmployeesByName(String name) {
50			Session session = HibernateUtil.getSessionFactory().getCurrentSession();
51
52			Transaction tx = session.beginTransaction();
53			Criteria c = session.createCriteria(Employee.class);
54			c.add( Restrictions.ilike("name", name, MatchMode.ANYWHERE) );
55			List<Employee> emps = c.list();
56
57			tx.rollback();
58			return emps;
59			}
60
61			public Employee getEmployeeById(int id) {
62			Session session = HibernateUtil.getSessionFactory().getCurrentSession();
63
64			Transaction tx = session.beginTransaction();
65			Criteria c = session.createCriteria(Employee.class);
66			c.add( Restrictions.eq("id", id));
67			Employee emp = (Employee) c.uniqueResult();
68
69			tx.rollback();
70			return emp;
71			}
72
73			public void deleteEmployee(Employee emp) {
74			Session session = HibernateUtil.getSessionFactory().getCurrentSession();
75
76			Transaction tx = session.beginTransaction();
77			session.delete(emp);
78			tx.commit();
79			}
80			}