//權限查詢
String?permissionSql="SELECT?t1.permission?FROM?roles_permissions?t1?INNER?JOIN?test_user_role?t2?"?+
????????"ON?t1.rolename=?t2.rolename?"?+
????????"AND?t2.username=??";
jdbcRealm.setPermissionsQuery(permissionSql);


//1.?構建securityManager環境
DefaultSecurityManager?defaultSecurityManager=new?DefaultSecurityManager();
defaultSecurityManager.setRealm(jdbcRealm);
//2.?主體提交認證請求
SecurityUtils.setSecurityManager(defaultSecurityManager);
Subject?subject=SecurityUtils.getSubject();

UsernamePasswordToken?token?=new?UsernamePasswordToken("xiaoming","123");
//subject.login(token);

//System.out.println("loginresult:"+subject.isAuthenticated());
//System.out.println("++++");
//subject.checkRole("user");
//System.out.println("roleresult:"+subject.hasRole("user"));

//System.out.println("=====");
System.out.println("permissionresult:"+subject.isPermitted("user:delete"));

輸出結果：

permissionresult:false

這個permission結果怎么總是false？數據庫中執行這個sql 結果就是 user:delete 。但是這里執行就是false

求講解