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(); 
                //no need to open transaction for a readonly session            
        
                Criteria c = session.createCriteria(Posting.class);
                java.util.List<Posting> list = c.list();
                
                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();
        
                 Criteria c = session.createCriteria(Posting.class);
                 c.add( Restrictions.eq("id", id));
                 Posting post = (Posting) c.uniqueResult();
                 
                 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	//no need to open transaction for a readonly session
16
17	Criteria c = session.createCriteria(Posting.class);
18	java.util.List<Posting> list = c.list();
19
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	Criteria c = session.createCriteria(Posting.class);
39	c.add( Restrictions.eq("id", id));
40	Posting post = (Posting) c.uniqueResult();
41
42	return post;
43	}
44
45	}