/* * 查询用户的单个角色 */ public boolean boolUserPermission(PmRUserRole prur, PmPermission pp) throws Exception { StringBuffer sb = new StringBuffer(); sb.append( "select count(*) as count from pm_r_user_role prur LEFT JOIN pm_r_role_permissioin prrp on prur.ROLE_USER_RID=prrp.ROLE_PERMISSION_RID"); sb.append(" LEFT JOIN pm_permission pp on pp.PERMISSION_ID=prrp.ROLE_PERMISSION_PID"); sb.append(" where prur.ROLE_USER_UID=? and pp.PERMISSION_URI=?"); Object[] obj = new Object[2]; obj[0] = prur.getRoleUserUid(); obj[1] = pp.getPermissionUri(); // 判断传入参数是否为空,查询用户和uri是否存在 if (prur != null && pp != null) { List<Map> listCount = (List<Map>) this.executeQuery(sb.toString(), obj); // 返回的记录数是否大于0 if (listCount != null && listCount.size() > 0) { if (Integer.parseInt(listCount.get(0).get("count").toString()) > 0) { return true; } } } return false; }