关于Hibernate查询获取多个字段的记录并封装的方法

小鱼儿 2022-08-26 15:29 6阅读 0赞

public Map<String, List<String>> findByC\_N\_S\_P(  
long companyId, String name, int scope, String primKey)  
throws SystemException \{  
  
  
Session session = null;  
  
  
try \{  
session = openSession();  
  
  
String sql = CustomSQLUtil.get(FIND\_BY\_C\_N\_S\_P);  
  
  
SQLQuery q = session.createSQLQuery(sql);  
  
  
q.addScalar("roleName", Type.STRING);  
q.addScalar("actionId", Type.STRING);  
  
  
QueryPos qPos = QueryPos.getInstance(q);  
  
  
qPos.add(companyId);  
qPos.add(name);  
qPos.add(scope);  
qPos.add(primKey);  
  
  
Map<String, List<String>> roleMap =  
new HashMap<String, List<String>>();  
  
  
Iterator<Object\[\]> itr = q.list().iterator();  
  
  
while (itr.hasNext()) \{  
Object\[\] array = itr.next();  
  
  
String roleName = (String)array\[0\];  
String actionId = (String)array\[1\];  
  
  
List<String> roleList = roleMap.get(roleName);  
  
  
if (roleList == null) \{  
roleList = new ArrayList<String>();  
\}  
  
  
roleList.add(actionId);  
  
  
roleMap.put(roleName, roleList);  
\}  
  
  
return roleMap;  
\}  
catch (Exception e) \{  
throw new SystemException(e);  
\}  
finally \{  
closeSession(session);  
\}

其中FIND\_BY\_C\_N\_S\_P为：