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.PortletPreferences;
30 import com.liferay.portal.model.impl.PortletPreferencesImpl;
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
42 public class PortletPreferencesFinderImpl
43 extends BasePersistenceImpl implements PortletPreferencesFinder {
44
45 public static String FIND_BY_PORTLETID =
46 PortletPreferencesFinder.class.getName() + ".findByPortletId";
47
48 public List<PortletPreferences> findByPortletId(String portletId)
49 throws SystemException {
50
51 Session session = null;
52
53 try {
54 session = openSession();
55
56 String sql = CustomSQLUtil.get(FIND_BY_PORTLETID);
57
58 SQLQuery q = session.createSQLQuery(sql);
59
60 q.addEntity("PortletPreferences", PortletPreferencesImpl.class);
61
62 QueryPos qPos = QueryPos.getInstance(q);
63
64 qPos.add(portletId);
65
66 return q.list();
67 }
68 catch (Exception e) {
69 throw new SystemException(e);
70 }
71 finally {
72 closeSession(session);
73 }
74 }
75
76 }