我如何仅使用一个包含用户名,密码和用户角色的表来集成弹簧安全性tbl_users那么它将在
<authentication-manager>
<authentication-provider>
<jdbc-user-service data-source-ref="dataSource"
users-by-username-query=""
authorities-by-username-query="" />
</authentication-provider>
</authentication-manager>
每一个帮助将不胜感激。提前谢谢。:)
<authentication-manager>
<authentication-provider>
<jdbc-user-service data-source-ref="dataSource"
users-by-username-query="
SELECT USERNAME, PASSWORD
FROM USER_TABLE
WHERE USERNAME=?;"
authorities-by-username-query="
SELECT u.USERNAME, r.ROLENAME
FROM USER_TABLE u, USER_TABLE r
WHERE u.ID = r.USERID
AND u.USERNAME=?;"
/>
</authentication-provider>
</authentication-manager>