1
19
20 package com.liferay.portal.service.persistence;
21
22 import com.liferay.portal.SystemException;
23 import com.liferay.portal.kernel.dao.orm.QueryPos;
24 import com.liferay.portal.kernel.dao.orm.SQLQuery;
25 import com.liferay.portal.kernel.dao.orm.Session;
26 import com.liferay.portal.model.Resource;
27 import com.liferay.portal.model.impl.ResourceImpl;
28 import com.liferay.portal.service.persistence.impl.BasePersistenceImpl;
29 import com.liferay.util.dao.orm.CustomSQLUtil;
30
31 import java.util.List;
32
33
40 public class ResourceFinderImpl
41 extends BasePersistenceImpl implements ResourceFinder {
42
43 public static String FIND_BY_NAME =
44 ResourceFinder.class.getName() + ".findByName";
45
46 public static String FIND_BY_C_P =
47 ResourceFinder.class.getName() + ".findByC_P";
48
49 public List<Resource> findByName(String name) throws SystemException {
50 Session session = null;
51
52 try {
53 session = openSession();
54
55 String sql = CustomSQLUtil.get(FIND_BY_NAME);
56
57 SQLQuery q = session.createSQLQuery(sql);
58
59 q.addEntity("Resource_", ResourceImpl.class);
60
61 QueryPos qPos = QueryPos.getInstance(q);
62
63 qPos.add(name);
64
65 return q.list();
66 }
67 catch (Exception e) {
68 throw new SystemException(e);
69 }
70 finally {
71 closeSession(session);
72 }
73 }
74
75 public List<Resource> findByC_P(long companyId, String primKey)
76 throws SystemException {
77
78 Session session = null;
79
80 try {
81 session = openSession();
82
83 String sql = CustomSQLUtil.get(FIND_BY_C_P);
84
85 SQLQuery q = session.createSQLQuery(sql);
86
87 q.addEntity("Resource_", ResourceImpl.class);
88
89 QueryPos qPos = QueryPos.getInstance(q);
90
91 qPos.add(companyId);
92 qPos.add(primKey);
93
94 return q.list();
95 }
96 catch (Exception e) {
97 throw new SystemException(e);
98 }
99 finally {
100 closeSession(session);
101 }
102 }
103
104 }