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