shiro-jdbc-Realm

1.jdbcrealm 默认查询语句：

获取用户密码：“select password from users w here username = ?” ；

获取用户角色：“select role_name from user_roles where username = ?” 

获取角色对应的权限信息：“sel ect permission from roles_permissions where role_name = ?” ；

也可以调用相应的api进行设置

2.添加相应的依赖

<dependency>
  <groupId>com.alibaba</groupId>
  <artifactId>druid</artifactId>
  <version>1.1.5</version>
</dependency>

连接池

<!--mysql相关依赖-->
<dependency>
  <groupId>mysql</groupId>
  <artifactId>mysql-connector-java</artifactId>
  <version>5.1.19</version>
</dependency>

mysql连接驱动依赖

3.配置jdbc-realm.ini 

[main]
# 配置JDBC数据库连接
dataSource=com.alibaba.druid.pool.DruidDataSource
dataSource.driverClassName=com.mysql.jdbc.Driver
dataSource.url=jdbc:mysql://localhost:3306/shiro_test
dataSource.username=root
dataSource.password=root

# JdbcRealm
jdbcRealm=org.apache.shiro.realm.jdbc.JdbcRealm
jdbcRealm.dataSource=$dataSource
jdbcRealm.authenticationQuery = select user_password from test_user where user_name=?

securityManager.realms=$jdbcRealm

jdbcRealm默认的SQL

通过相应的set方法进行替换