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	torben	602	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	torben	1347	Session session = HibernateUtil.getSessionFactory().openSession();
15			//no need to open transaction for a readonly session
16	torben	602
17			Criteria c = session.createCriteria(Posting.class);
18			java.util.List<Posting> list = c.list();
19	torben	1347
20	torben	602	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			}