发布于 2014-10-06 19:32:35
JdbcRealm不依赖于特定的表模式:它使用一些默认查询,您可以重写这些查询(通过子类化或通过特定的setter方法),以便使其适应您的需要。
正如javadoc中所述,您可以使用默认查询作为构建自己模式的基础。查看一下来源,您可以开始创建三个基本表:users、user_roles和roles_permissions。
protected static final String DEFAULT_AUTHENTICATION_QUERY = "select password from users where username = ?";
/**
* The default query used to retrieve account data for the user when {@link #saltStyle} is COLUMN.
*/
protected static final String DEFAULT_SALTED_AUTHENTICATION_QUERY = "select password, password_salt from users where username = ?";
/**
* The default query used to retrieve the roles that apply to a user.
*/
protected static final String DEFAULT_USER_ROLES_QUERY = "select role_name from user_roles where username = ?";
/**
* The default query used to retrieve permissions that apply to a particular role.
*/
protected static final String DEFAULT_PERMISSIONS_QUERY = "select permission from roles_permissions where role_name = ?";https://stackoverflow.com/questions/26223179
复制相似问题