环境配置

  • 后端权限认证采用Spring Security 实现，数据库访问使用Mybatis,同时使用Redis实现认证信息缓存。

添加依赖

  • 添加 mybatis，Spring Security,Redis，数据库连接池，数据库驱动依赖以及缓存依赖

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    33
    34
    35
    36
    37
    38
    39
    40
    41
    42
    43
    44
    45
    46
    47
    48
    49
    50
    51
    52
    53
    54
    55
    56
    57
    58
    59
    60
    61
    62
    63
    64
    <properties>
      <maven.compiler.source>17</maven.compiler.source>
      <maven.compiler.target>17</maven.compiler.target>
      <springboot.version>2.5.5</springboot.version>
      <mybatis.version>2.2.0</mybatis.version>
      <druid.version>1.2.6</druid.version>
      <mysql.version>8.0.26</mysql.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>${mybatis.version}</version>
      </dependency>
      <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-security</artifactId>
      </dependency>
      <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-data-redis</artifactId>
        <exclusions>
          <exclusion>
            <groupId>io.lettuce</groupId>
            <artifactId>lettuce-core</artifactId>
          </exclusion>
        </exclusions>
      </dependency>
      <dependency>
        <groupId>redis.clients</groupId>
        <artifactId>jedis</artifactId>
      </dependency>
      <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid-spring-boot-starter</artifactId>
        <version>${druid.version}</version>
      </dependency>
      <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>${mysql.version}</version>
      </dependency>
      <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-cache</artifactId>
      </dependency>
    </dependencies>

    <dependencyManagement>
      <dependencies>
        <dependency>
          <groupId>org.springframework.boot</groupId>
          <artifactId>spring-boot-dependencies</artifactId>
          <version>2.5.5</version>
          <type>pom</type>
          <scope>import</scope>
        </dependency>
      </dependencies>
    </dependencyManagement>

配置文件

  • 依赖添加完成后，配置数据库连接，redis连接，以及缓存等

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    server:
      port: 8082

    spring:
      # MYSQL配置
      datasource:
        type: com.alibaba.druid.pool.DruidDataSource
        url: jdbc:mysql://zy01:3306/vhr
        username: sun
        password: sun
      # Redis配置
      redis:
        database: 0
        host: zy01
        port: 6379
        password:
        jedis:
          pool:
            max-active: 8
            # 最大空闲数
            max-idle: 8
            max-wait: -1ms
            min-idle: 0
      # 缓存配置
      cache:
        cache-names: menus_cache
        redis:
          time-to-live: 1800s # 半小时

    # MyBatis 日志设置
    mybatis:
      config-location: classpath:/mybatis-config.xml

用户认证

  • 登录操作是Hr登录，根据hr表创建hr实体类，提供 UserDetails的实例 ，