PortletPreferencesFinderImpl.java |
1 /** 2 * Copyright (c) 2000-2009 Liferay, Inc. All rights reserved. 3 * 4 * Permission is hereby granted, free of charge, to any person obtaining a copy 5 * of this software and associated documentation files (the "Software"), to deal 6 * in the Software without restriction, including without limitation the rights 7 * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell 8 * copies of the Software, and to permit persons to whom the Software is 9 * furnished to do so, subject to the following conditions: 10 * 11 * The above copyright notice and this permission notice shall be included in 12 * all copies or substantial portions of the Software. 13 * 14 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR 15 * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, 16 * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE 17 * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER 18 * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, 19 * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE 20 * SOFTWARE. 21 */ 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 /** 37 * <a href="PortletPreferencesFinderImpl.java.html"><b><i>View Source</i></b> 38 * </a> 39 * 40 * @author Brian Wing Shun Chan 41 * 42 */ 43 public class PortletPreferencesFinderImpl 44 extends BasePersistenceImpl 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 }