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 |
} |