thoerup/pictureposterservice/PostingDAO.java

package dk.thoerup.pictureposterservice;

import java.util.List;

import org.hibernate.*;
import org.hibernate.criterion.*;


public class PostingDAO {
        
        @SuppressWarnings("unchecked")
        static public List<Posting> getAll() {
                Session session = HibernateUtil.getSessionFactory().openSession();
                Transaction tx = session.beginTransaction(); // Dummy Transcaction
        
                Criteria c = session.createCriteria(Posting.class);
                java.util.List<Posting> list = c.list();
                tx.rollback(); //since no changes was made, just as well rollback
                session.close();
        
                return list;
        }
        
        static public void savePosting(Posting post) {
                Session session = HibernateUtil.getSessionFactory().openSession();
                
                Transaction tx = session.beginTransaction();
                session.persist(post);
                tx.commit();

                session.close();
        }
        
        static public Posting getPostingById(int id) {
                 Session session = HibernateUtil.getSessionFactory().getCurrentSession();
        
                 Transaction tx = session.beginTransaction();
                 Criteria c = session.createCriteria(Posting.class);
                 c.add( Restrictions.eq("id", id));
                 Posting post = (Posting) c.uniqueResult();
                 
                 tx.rollback();
                 return post;
        } 
        
}
1	package dk.thoerup.pictureposterservice;
2
3	import java.util.List;
4
5	import org.hibernate.*;
6	import org.hibernate.criterion.*;
7
8
9
10	public class PostingDAO {
11
12	@SuppressWarnings("unchecked")
13	static public List<Posting> getAll() {
14	Session session = HibernateUtil.getSessionFactory().openSession();
15	Transaction tx = session.beginTransaction(); // Dummy Transcaction
16
17	Criteria c = session.createCriteria(Posting.class);
18	java.util.List<Posting> list = c.list();
19	tx.rollback(); //since no changes was made, just as well rollback
20	session.close();
21
22	return list;
23	}
24
25	static public void savePosting(Posting post) {
26	Session session = HibernateUtil.getSessionFactory().openSession();
27
28	Transaction tx = session.beginTransaction();
29	session.persist(post);
30	tx.commit();
31
32	session.close();
33	}
34
35	static public Posting getPostingById(int id) {
36	Session session = HibernateUtil.getSessionFactory().getCurrentSession();
37
38	Transaction tx = session.beginTransaction();
39	Criteria c = session.createCriteria(Posting.class);
40	c.add( Restrictions.eq("id", id));
41	Posting post = (Posting) c.uniqueResult();
42
43	tx.rollback();
44	return post;
45	}
46
47	}