Spring Security的各种User Service

inline-user-service.xml

<authentication-manager>
        <authentication-provider>
            <user-service>
                <user name="sa" password="sa" authorities="ROLE_USER,ROLE_ADMIN,ROLE_UC_ADMIN" />
            </user-service>
        </authentication-provider>
    </authentication-manager>

jdbc-user-service.xml

<authentication-manager alias="authenticationManager">
        <authentication-provider>
            <jdbc-user-service data-source-ref="dataSource"
                               users-by-username-query="
         select username, `password`, 'true'
         from sys_user
         where username=?;"

                               authorities-by-username-query="
        select u.username , r.enName from sys_user_role ur
        left  join sys_user u on ur.user_id=u.id
        left  join sys_role r on ur.role_id =r.id where u.username=?"
                    />
        </authentication-provider>
    </authentication-manager>