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