简单的shiro案例（springboot+mybatis）

浅浅的花香味﹌ 2022-01-14 16:19 180阅读 0赞

1，导入maven

<?xml version="1.0" encoding="UTF-8"?>
    <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
        <modelVersion>4.0.0</modelVersion>
        <parent>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-parent</artifactId>
            <version>2.1.5.RELEASE</version>
            <relativePath/> 
        </parent>
        <groupId>com.example</groupId>
        <artifactId>demo</artifactId>
        <version>0.0.1-SNAPSHOT</version>
        <packaging>war</packaging>
        <name>demo</name>
        <description>Demo project for Spring Boot</description>
    
        <properties>
            <java.version>1.8</java.version>
        </properties>
    
        <dependencies>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
            <dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>2.0.1</version>
            </dependency>
    
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <scope>runtime</scope>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-tomcat</artifactId>
                <scope>provided</scope>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <scope>test</scope>
            </dependency>
            
            <dependency>
                <groupId>org.apache.shiro</groupId>
                <artifactId>shiro-core</artifactId>
                <version>1.4.1</version>
            </dependency>
            
            <dependency>
                <groupId>org.apache.shiro</groupId>
                <artifactId>shiro-spring</artifactId>
                <version>1.4.1</version>
            </dependency>
            
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid</artifactId>
                <version>1.1.17</version>
            </dependency>
            
            <dependency>
                <groupId>org.apache.commons</groupId>
                <artifactId>commons-lang3</artifactId>
                <version>3.9</version>
            </dependency>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-context-support</artifactId>
                <version>5.1.7.RELEASE</version>
            </dependency>
            
            <dependency>
                <groupId>org.apache.tomcat.embed</groupId>
                <artifactId>tomcat-embed-jasper</artifactId>
                <version>9.0.21</version>
            </dependency>
            
            <dependency>
                <groupId>javax.servlet</groupId>
                <artifactId>javax.servlet-api</artifactId>
                <version>4.0.1</version>
                <scope>provided</scope>
            </dependency>
            
            <dependency>
                <groupId>javax.servlet</groupId>
                <artifactId>jstl</artifactId>
                <version>1.2</version>
            </dependency>
            
            <dependency>
                <groupId>com.google.guava</groupId>
                <artifactId>guava</artifactId>
                <version>27.1-jre</version>
            </dependency>
        </dependencies>
    
        <build>
            <plugins>
                <plugin>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-maven-plugin</artifactId>
                </plugin>
            </plugins>
        </build>
    
    </project>

2.配置druid文件

package com.example.demo.config;
    
    import com.alibaba.druid.filter.Filter;
    import com.alibaba.druid.filter.stat.StatFilter;
    import com.alibaba.druid.pool.DruidDataSource;
    import com.alibaba.druid.support.http.StatViewServlet;
    import com.google.common.collect.Lists;
    import org.springframework.boot.context.properties.ConfigurationProperties;
    import org.springframework.boot.web.servlet.ServletRegistrationBean;
    import org.springframework.context.annotation.Bean;
    import org.springframework.context.annotation.Configuration;
    
    /**druid的配置类
     * @author sy
     * @date 2019/3/14 17:35
     */
    
    @Configuration
    public class DruidConfig {
    
        //会扫描application.properties文件的以spring.druid开头的数据注入
        @ConfigurationProperties(prefix = "spring.druid")
        @Bean(initMethod = "init",destroyMethod = "close") //跟着spring一块启动，一块关闭
        public DruidDataSource dataSource(){
    
            DruidDataSource dataSource = new DruidDataSource();
            dataSource.setProxyFilters(Lists.newArrayList(statFilter()));//Lists是guava包
            return dataSource;
        }
    
        //alibaba的监听器，打印慢sql
        @Bean
        public Filter statFilter(){
    
            StatFilter filter = new StatFilter();
            filter.setSlowSqlMillis(1);
            filter.setLogSlowSql(true);
            filter.setMergeSql(true);
            return filter;
    
        }
    
        @Bean
        public ServletRegistrationBean servletRegistrationBean(){
            return new ServletRegistrationBean(new StatViewServlet(),"/druid/*");
    
        }
    
    
    }

3，配置application.xml

#druid 阿里巴巴下的一个开源连接池：功能强大，可以监控，稳定。
    spring.druid.driverClassName=com.mysql.cj.jdbc.Driver
    spring.druid.url=jdbc:mysql://localhost:3306/shiro?characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&useSSL=false
    spring.druid.username=root
    spring.druid.password=root
    #最大连接数
    spring.druid.maxActive=30
    #最小连接数
    spring.druid.minIdle=5
    #获取连接的最大等待时间
    spring.druid.maxWait=10000
    #解决mysql8小时的问题
    spring.druid.validationQuery=SELECT 'x'
    
    #Mybatis配置
    mybatis.mapper-locations=mapper/*.xml
    mybatis.type-aliases-package=com.example.demo.model

4，创建简单的对象：permission,role ,user

package com.example.demo.model;
    
    import java.io.Serializable;
    
    public class Permission implements Serializable {
    
        private Integer pid;
    
        private String name;
    
        public Integer getPid() {
            return pid;
        }
    
        public void setPid(Integer pid) {
            this.pid = pid;
        }
    
        public String getName() {
            return name;
        }
    
        public void setName(String name) {
            this.name = name;
        }
    }

package com.example.demo.model;
    
    import org.eclipse.jdt.internal.compiler.util.HashSetOfInt;
    
    import java.io.Serializable;
    import java.util.HashSet;
    import java.util.Set;
    
    public class Role implements Serializable {
    
        private Integer rid;
    
        private String name;
    
        private Set<Permission> permissionSet = new HashSet<Permission>();
    
    
        public Integer getRid() {
            return rid;
        }
    
        public void setRid(Integer rid) {
            this.rid = rid;
        }
    
        public String getName() {
            return name;
        }
    
        public void setName(String name) {
            this.name = name;
        }
    
        public Set<Permission> getPermissionSet() {
            return permissionSet;
        }
    
        public void setPermissionSet(Set<Permission> permissionSet) {
            this.permissionSet = permissionSet;
        }
    }

package com.example.demo.model;
    
    import java.io.Serializable;
    import java.util.HashSet;
    import java.util.Set;
    
    public class User implements Serializable {
    
        private Integer uid;
    
        private String username;
    
        private String password;
    
        private Set<Role> roleSet = new  HashSet<Role>();
    
        public Integer getUid() {
            return uid;
        }
    
        public void setUid(Integer uid) {
            this.uid = uid;
        }
    
        public String getUsername() {
            return username;
        }
    
        public void setUsername(String username) {
            this.username = username;
        }
    
        public String getPassword() {
            return password;
        }
    
        public void setPassword(String password) {
            this.password = password;
        }
    
        public Set<Role> getRoleSet() {
            return roleSet;
        }
    
        public void setRoleSet(Set<Role> roleSet) {
            this.roleSet = roleSet;
        }
    }

5，创建controller，service，dao

//controller
    @Controller
    @RequestMapping("/user")
    public class UserController {
    
        @Autowired
        private UserService userService;
    
        @RequestMapping("/getUserRole")
        @ResponseBody
        public User getUserRole(@RequestParam("username") String username){
            return userService.getUserByUsername(username);
        }
    
    }
    
    
    //service
    
    @Service
    public class UserServiceImpl implements UserService{
    
        @Autowired
        private UserMapper userMapper;
    
        /**
         * 通过username获取user
         * @return
         */
        @Override
        public User getUserByUsername(String username) {
           return userMapper.getUserByUsername(username);
        }
    }
    
    //mapper
    @Repository
    public interface UserMapper {
    
        User getUserByUsername(@Param("username") String username);
    
    }

6，写xml文件，，，

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
                    "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    
    <mapper namespace="com.example.demo.mapper.UserMapper">
    
        
        <resultMap id="userResultMap" type="com.example.demo.model.User">
            <id property="uid" column="uid"></id>
            <result property="username" column="username"></result>
            <result property="password" column="password"></result>
            <collection property="roleSet" ofType="com.example.demo.model.Role">
                <id property="rid" column="rid"></id>
                <result property="name" column="name"></result>
                <collection property="permissionSet" ofType="com.example.demo.model.Permission">
                    <id property="pid" column="pid"></id>
                    <result property="name" column="name"></result>
                </collection>
            </collection>
        </resultMap>
    
        <select id="getUserByUsername" parameterType="string" resultMap="userResultMap">
            select *
            from user u left join user_role ru on u.uid=ru.uid
            left join role r on r.rid=ru.rid
            left join role_permission rp on r.rid=rp.rid
            left join permission p on p.pid=rp.pid
            where u.username=#{username}
        </select>
    
    
    </mapper>

7，建表，数据库表：shiro

SET FOREIGN_KEY_CHECKS=0;
    
    -- ----------------------------
    -- Table structure for permission
    -- ----------------------------
    DROP TABLE IF EXISTS `permission`;
    CREATE TABLE `permission` (
      `pid` int(11) NOT NULL AUTO_INCREMENT,
      `name` varchar(20) CHARACTER SET utf8 NOT NULL,
      PRIMARY KEY (`pid`)
    ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
    
    -- ----------------------------
    -- Records of permission
    -- ----------------------------
    INSERT INTO `permission` VALUES ('1', 'update');
    INSERT INTO `permission` VALUES ('2', 'delete');
    INSERT INTO `permission` VALUES ('3', 'create');
    INSERT INTO `permission` VALUES ('4', 'read');
    
    -- ----------------------------
    -- Table structure for role
    -- ----------------------------
    DROP TABLE IF EXISTS `role`;
    CREATE TABLE `role` (
      `rid` int(11) NOT NULL AUTO_INCREMENT,
      `name` varchar(20) CHARACTER SET utf8 NOT NULL,
      PRIMARY KEY (`rid`)
    ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
    
    -- ----------------------------
    -- Records of role
    -- ----------------------------
    INSERT INTO `role` VALUES ('1', 'admin');
    INSERT INTO `role` VALUES ('2', 'user');
    
    -- ----------------------------
    -- Table structure for role_permission
    -- ----------------------------
    DROP TABLE IF EXISTS `role_permission`;
    CREATE TABLE `role_permission` (
      `pid` int(11) NOT NULL,
      `rid` int(11) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    
    -- ----------------------------
    -- Records of role_permission
    -- ----------------------------
    INSERT INTO `role_permission` VALUES ('1', '1');
    INSERT INTO `role_permission` VALUES ('2', '1');
    INSERT INTO `role_permission` VALUES ('3', '1');
    INSERT INTO `role_permission` VALUES ('4', '1');
    INSERT INTO `role_permission` VALUES ('4', '2');
    
    -- ----------------------------
    -- Table structure for user
    -- ----------------------------
    DROP TABLE IF EXISTS `user`;
    CREATE TABLE `user` (
      `uid` int(11) NOT NULL AUTO_INCREMENT,
      `username` varchar(20) CHARACTER SET utf8 NOT NULL,
      `password` varchar(255) CHARACTER SET utf8 NOT NULL,
      PRIMARY KEY (`uid`)
    ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
    
    -- ----------------------------
    -- Records of user
    -- ----------------------------
    INSERT INTO `user` VALUES ('1', '张三', '123456');
    INSERT INTO `user` VALUES ('2', '王五', '123546');
    
    -- ----------------------------
    -- Table structure for user_role
    -- ----------------------------
    DROP TABLE IF EXISTS `user_role`;
    CREATE TABLE `user_role` (
      `uid` int(11) NOT NULL,
      `rid` int(11) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    
    -- ----------------------------
    -- Records of user_role
    -- ----------------------------
    INSERT INTO `user_role` VALUES ('1', '1');
    INSERT INTO `user_role` VALUES ('2', '2');

8，在springboot启动类添加MapperScan扫描

//扫描Mapper文件，注入service的成员变量中。
    @SpringBootApplication
    @MapperScan(basePackages = "com.example.demo.mapper")
    public class DemoApplication {
    
        public static void main(String[] args) {
            SpringApplication.run(DemoApplication.class, args);
        }
    
    }

9，启动tomcat，然后访问：  [http://localhost:8080/user/getUserRole?username=][http_localhost_8080_user_getUserRole_username]张三

此文章如有雷同，纯属意外

[http_localhost_8080_user_getUserRole_username]: http://localhost:8080/user/getUserRole?username=%E5%BC%A0%E4%B8%89