shiro-jdbc-Realm

1.jdbcrealm 默认查询语句：

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

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

获取角色对应的权限信息：“select 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.DruidDataSourcedataSource.driverClassName=com.mysql.jdbc.DriverdataSource.url=jdbc:mysql://localhost:3306/shiro_testdataSource.username=rootdataSource.password=root# JdbcRealmjdbcRealm=org.apache.shiro.realm.jdbc.JdbcRealmjdbcRealm.dataSource=$dataSourcejdbcRealm.authenticationQuery = select user_password from test_user where user_name=?securityManager.realms=$jdbcRealm

jdbcRealm默认的SQL

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