Mercurial > hg > LGDataverses

comparison src/main/java/edu/harvard/iq/dataverse/GuestbookServiceBean.java @ 10:a50cf11e5178

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Rewrite LGDataverse completely upgrading to dataverse4.0
author Zoe Hong <zhong@mpiwg-berlin.mpg.de>
date Tue, 08 Sep 2015 17:00:21 +0200
parents
children
comparison
equal deleted inserted replaced
9:5926d6419569 10:a50cf11e5178
1 /*
2 * To change this license header, choose License Headers in Project Properties.
3 * To change this template file, choose Tools | Templates
4 * and open the template in the editor.
5 */
6 package edu.harvard.iq.dataverse;
7
8 import java.util.List;
9 import javax.ejb.Stateless;
10 import javax.inject.Named;
11 import javax.persistence.EntityManager;
12 import javax.persistence.PersistenceContext;
13 import javax.persistence.Query;
14
15 /**
16 *
17 * @author skraffmiller
18 */
19 @Stateless
20 @Named
21 public class GuestbookServiceBean implements java.io.Serializable {
22
23 @PersistenceContext(unitName = "VDCNet-ejbPU")
24 private EntityManager em;
25
26
27 public Long findCountUsages(Long guestbookId) {
28 String queryString = "";
29 if (guestbookId != null) {
30 queryString = "select count(o.id) from Dataset o where o.guestbook_id = " + guestbookId + " ";
31 } else {
32 return new Long(0) ;
33 }
34 Query query = em.createNativeQuery(queryString);
35 return (Long) query.getSingleResult();
36 }
37
38
39
40 public Guestbook find(Object pk) {
41 return em.find(Guestbook.class, pk);
42 }
43
44 public Guestbook save(Guestbook guestbook) {
45 if (guestbook.getId() == null) {
46 em.persist(guestbook);
47 return guestbook;
48 } else {
49 return em.merge(guestbook);
50 }
51 }
52
53 }