private static void findUser(Role r) throws Exception {
        
        RoleDAO rd = new RoleDAO();
//        UserDAO ud = new UserDAO();
//        User user = (User) ud.findById(u.getId());
        List<User> ur = rd.findUser(r);
//        UserRole o;
//        Role role;
        System.out.println("User's roles " + r.getName() + ": ");
        User u;
        for (int i = 0; i < ur.size(); i++) {
            u = (User) ur.get(i);
            System.out.println(u);
//            role = (Role) rd.findById(o.getRoleid());
//            System.out.println(i + " - " + role.getName());
        }
        
        
    }