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.UserGroupRole;
30 import com.liferay.portal.model.impl.UserGroupRoleImpl;
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
41 public class UserGroupRoleFinderImpl
42 extends BasePersistenceImpl<UserGroupRole> implements UserGroupRoleFinder {
43
44 public static String FIND_BY_USER_USER_GROUP_GROUP_ROLE =
45 UserGroupRoleFinder.class.getName() + ".findByUserUserGroupGroupRole";
46
47 public List<UserGroupRole> findByUserUserGroupGroupRole(
48 long userId, long groupId)
49 throws SystemException {
50
51 Session session = null;
52
53 try {
54 session = openSession();
55
56 String sql = CustomSQLUtil.get(FIND_BY_USER_USER_GROUP_GROUP_ROLE);
57
58 SQLQuery q = session.createSQLQuery(sql);
59
60 q.addEntity("UserGroupRole", UserGroupRoleImpl.class);
61
62 QueryPos qPos = QueryPos.getInstance(q);
63
64 qPos.add(userId);
65 qPos.add(groupId);
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 }