基于springboot和jwt的预约系统

1、依赖

  1.  <dependencies>
  2.         <dependency>
  3.             <groupId>org.springframework.boot</groupId>
  4.             <artifactId>spring-boot-starter-web</artifactId>
  5.         </dependency>
  7.         <dependency>
  8.             <groupId>mysql</groupId>
  9.             <artifactId>mysql-connector-java</artifactId>
  10.             <scope>runtime</scope>
  11.         </dependency>
  12.         <dependency>
  13.             <groupId>org.projectlombok</groupId>
  14.             <artifactId>lombok</artifactId>
  15.             <optional>true</optional>
  16.         </dependency>
  17.         <dependency>
  18.             <groupId>org.springframework.boot</groupId>
  19.             <artifactId>spring-boot-starter-test</artifactId>
  20.             <scope>test</scope>
  21.         </dependency>
  23.      <!-- mybatis plus -->
  24.         <dependency>
  25.             <groupId>com.baomidou</groupId>
  26.             <artifactId>mybatis-plus-boot-starter</artifactId>
  27.             <version>3.4.3.1</version>
  28.         </dependency>
  29.         <dependency>
  30.             <groupId>com.h2database</groupId>
  31.             <artifactId>h2</artifactId>
  32.             <scope>runtime</scope>
  33.         </dependency>
  34.           <!-- mybatis plus generator 代码生成器 -->
  35.         <dependency>
  36.             <groupId>com.baomidou</groupId>
  37.             <artifactId>mybatis-plus-generator</artifactId>
  38.             <version>3.4.1</version>
  39.         </dependency>
  40.         <dependency>
  41.             <groupId>org.apache.velocity</groupId>
  42.             <artifactId>velocity-engine-core</artifactId>
  43.             <version>2.0</version>
  44.         </dependency>
  46.           <!-- swagger2 -->
  47.         <dependency>
  48.             <groupId>io.springfox</groupId>
  49.             <artifactId>springfox-swagger-ui</artifactId>
  50.             <version>2.4.0</version>
  51.         </dependency>
  52.         <dependency>
  53.             <groupId>io.springfox</groupId>
  54.             <artifactId>springfox-swagger2</artifactId>
  55.             <version>2.4.0</version>
  56.         </dependency>
  58.           <!-- hutool -->
  59.         <dependency>
  60.             <groupId>cn.hutool</groupId>
  61.             <artifactId>hutool-all</artifactId>
  62.             <version>5.7.4</version>
  63.         </dependency>
  65.         <dependency>
  66.             <groupId>junit</groupId>
  67.             <artifactId>junit</artifactId>
  68.         </dependency>
  71.         <!-- JWT-->
  72.         <dependency>
  73.             <groupId>io.jsonwebtoken</groupId>
  74.             <artifactId>jjwt</artifactId>
  75.             <version>0.9.1</version>
  76.         </dependency>
  77.         <!--        坑！！ 不引入下面依赖JWT报错-->
  78.         <dependency>
  79.             <groupId>javax.xml.bind</groupId>
  80.             <artifactId>jaxb-api</artifactId>
  81.             <version>2.3.0</version>
  82.         </dependency>
  83.         <dependency>
  84.             <groupId>com.sun.xml.bind</groupId>
  85.             <artifactId>jaxb-impl</artifactId>
  86.             <version>2.3.0</version>
  87.         </dependency>
  88.         <dependency>
  89.             <groupId>com.sun.xml.bind</groupId>
  90.             <artifactId>jaxb-core</artifactId>
  91.             <version>2.3.0</version>
  92.         </dependency>
  93.         <dependency>
  94.             <groupId>javax.activation</groupId>
  95.             <artifactId>activation</artifactId>
  96.             <version>1.1.1</version>
  97.         </dependency>
  99.         <!--        easy excel-->
  100.         <dependency>
  101.             <groupId>com.alibaba</groupId>
  102.             <artifactId>easyexcel</artifactId>
  103.             <version>2.1.1</version>
  104.         </dependency>
  105.         <dependency>
  106.             <groupId>org.apache.poi</groupId>
  107.             <artifactId>poi</artifactId>
  108.             <version>3.17</version>
  109.         </dependency>
  110.         <dependency>
  111.             <groupId>org.apache.poi</groupId>
  112.             <artifactId>poi-ooxml</artifactId>
  113.             <version>3.17</version>
  114.         </dependency>
  116.      <!-- sureness鉴权 -->
  117.         <dependency>
  118.             <groupId>com.usthe.sureness</groupId>
  119.             <artifactId>sureness-core</artifactId>
  120.             <version>1.0.3</version>
  121.         </dependency>
  122.     </dependencies>

2、建表 使用mybatisplus代码生成器

  2. import com.baomidou.mybatisplus.generator.AutoGenerator;
  3. import com.baomidou.mybatisplus.generator.config.DataSourceConfig;
  4. import com.baomidou.mybatisplus.generator.config.GlobalConfig;
  5. import com.baomidou.mybatisplus.generator.config.PackageConfig;
  6. import com.baomidou.mybatisplus.generator.config.StrategyConfig;
  7. import com.baomidou.mybatisplus.generator.config.rules.NamingStrategy;
  9. public class Main {
  10.     public static void main(String[] args) {
  12.         //创建AutoGenerator对象
  13.         AutoGenerator autoGenerator = new AutoGenerator();
  14.         //数据源
  15.         DataSourceConfig dataSourceConfig = new DataSourceConfig();
  16.         dataSourceConfig.setUrl("jdbc:mysql://localhost:3306/yuyue?useUnicode=true&useSSL=false&characterEncoding=UTF-8");
  17.         dataSourceConfig.setDriverName("com.mysql.cj.jdbc.Driver");
  18.         dataSourceConfig.setUsername("root");
  19.         dataSourceConfig.setPassword("123456");
  20.         autoGenerator.setDataSource(dataSourceConfig);
  22.         //全局配置
  23.         GlobalConfig globalConfig = new GlobalConfig();
  24.         //System.getProperty("user.dir")工程绝对路径
  25.         globalConfig.setOutputDir(System.getProperty("user.dir") + "/src/main/java");
  26.         globalConfig.setAuthor("william");
  27.         //创建后不打开文件
  28.         globalConfig.setOpen(false);
  29.         autoGenerator.setGlobalConfig(globalConfig);
  31.         //    包信息
  32.         PackageConfig packageConfig = new PackageConfig();
  33.         packageConfig.setParent("com.william");
  34.         //各层存放位置
  35.         packageConfig.setController("controller");
  36.         packageConfig.setService("service");
  37.         packageConfig.setServiceImpl("service.impl");
  38.         packageConfig.setEntity("entity");
  39.         packageConfig.setMapper("mapper");
  40.         autoGenerator.setPackageInfo(packageConfig);
  42.         //    配置策略
  43.         StrategyConfig strategyConfig = new StrategyConfig();
  44.         //entity生成后自动使用lombok注解
  45.         strategyConfig.setEntityLombokModel(true);
  46.         //开启下划线转驼峰
  47.         strategyConfig.setNaming(NamingStrategy.underline_to_camel);
  48.         autoGenerator.setStrategy(strategyConfig);
  50.         //开始生成
  51.         autoGenerator.execute();
  52.     }
  53. }

然后在启动类加上@MapperScan("com.william.mapper")

  1. # application.yml
  2. server:
  3.   port: 8081
  5. spring:
  6.   datasource:
  7.     driver-class-name: com.mysql.cj.jdbc.Driver
  8.     username: root
  9.     password: 123456
  10.     url: jdbc:mysql://localhost:3306/yuyue?serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=UTF-8
  12.     # 环境设置：dev、test、prod
  13.   profiles:
  14.     active: dev
  17. #mybatis日志
  18. logging:
  19.   level:
  20.     root: warn
  22. #配置日志级别
  23. mybatis-plus:
  24.   configuration:
  25.     log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
  26.   mapper-locations: classpath*:**/mapper/xml/*.xml
  27.   type-enums-package: com.william.enums

3、统一结果返回

  1. public interface ResultCode {
  2.     public static Integer SUCCESS = 200;
  3.     public static Integer ERROR = 400;
  4. }
  1. package com.william.commonUtils;
  3. import lombok.Data;
  5. import java.util.HashMap;
  6. import java.util.Map;
  8. @Data
  9. public class R {
  10.     private Boolean success;
  12.     private Integer code;
  14.     private String msg;
  16.     private Map<String, Object> data = new HashMap<>();
  18.     private R() {
  19.     }
  21.     public static R ok() {
  22.         R r = new R();
  23.         r.setCode(ResultCode.SUCCESS);
  24.         r.setSuccess(true);
  25.         r.setMsg("成功");
  26.         return r;
  27.     }
  29.     public static R error() {
  30.         R r = new R();
  31.         r.setCode(ResultCode.ERROR);
  32.         r.setSuccess(false);
  33.         r.setMsg("失败");
  34.         return r;
  35.     }
  37.     public R success(Boolean success) {
  38.         this.setSuccess(success);
  39.         return this;
  40.     }
  42.     public R message(String message) {
  43.         this.setMsg(message);
  44.         return this;
  45.     }
  47.     public R code(Integer code) {
  48.         this.setCode(code);
  49.         return this;
  50.     }
  52.     public R data(String key, Object value) {
  53.         this.data.put(key, value);
  54.         return this;
  55.     }
  57.     public R data(Map<String, Object> map) {
  58.         this.setData(map);
  59.         return this;
  60.     }
  61. }

4、全局异常处理

  1. /**
  2.  * 自定义异常类
  3.  */
  4. @Data
  5. @AllArgsConstructor
  6. @NoArgsConstructor
  7. public class MyException extends RuntimeException {
  8.     /**
  9.      * 状态码
  10.      */
  11.     private Integer code;
  13.     /**
  14.      * 异常信息
  15.      */
  16.     private String msg;
  17. }
  1. /**
  2.  * 异常处理
  3.  */
  4. @ControllerAdvice
  5. @Slf4j
  6. public class GlobalExceptionHandler {
  7.     /**
  8.      * 全局异常处理
  9.      *
  10.      * @param e
  11.      * @return
  12.      */
  13.     @ExceptionHandler(Exception.class)
  14.     @ResponseBody
  15.     public R error(Exception e) {
  16.         e.printStackTrace();
  17.         return R.error().message("执行了全局异常处理：");
  18.     }
  20.     /**
  21.      * 特定异常处理
  22.      *
  23.      * @param e
  24.      * @return
  25.      */
  26.     @ExceptionHandler(ArithmeticException.class)
  27.     @ResponseBody
  28.     public R error(ArithmeticException e) {
  29.         e.printStackTrace();
  30.         return R.error().message("执行了特定异常");
  31.     }
  33.     /**
  34.      * 自定义异常处理
  35.      *
  36.      * @param e
  37.      * @return
  38.      */
  39.     @ExceptionHandler(MyException.class)
  40.     @ResponseBody
  41.     public R error(MyException e) {
  42.         e.printStackTrace();
  43.         log.error(e.getMsg());
  44.         return R.error().code(e.getCode()).message(e.getMsg());
  45.     }
  46. }

5、通用枚举

  1. public enum  AppointStatusEnum {
  2.     /**
  3.      * 用户登录状态的枚举类
  4.      */
  5.     EFFECTIVE(0,"effective"),
  6.     CANCELLED(1,"cancelled"),
  7.     EXPIRED(2,"expired");
  9.     @EnumValue
  10.     private Integer code;
  12.     @JsonValue
  13.     private String msg;
  15.     AppointStatusEnum(Integer code, String msg) {
  16.         this.code = code;
  17.         this.msg = msg;
  18.     }
  19. }
  1.   // 修改entity中属性的类型
  2.     /**
  3.      * 预约状态
  4.      */
  5.     private AppointStatusEnum status;

6、字段自动填充

  1. @Component
  2. public class MyMetaObjectHandler implements MetaObjectHandler {
  3.     @Override
  4.     public void insertFill(MetaObject metaObject) {
  5.         //属性名称，不是字段名称
  6.         this.setFieldValByName("createTime", new Date(), metaObject);
  7.         this.setFieldValByName("updateTime", new Date(), metaObject);
  8.     }
  10.     @Override
  11.     public void updateFill(MetaObject metaObject) {
  12.         this.setFieldValByName("updateTime", new Date(), metaObject);
  14.     }
  15. }
  1. /**
  2.  * 创建时间
  3.  */
  4. @TableField(fill = FieldFill.INSERT)
  5. private Date createTime;
  7. /**
  8.  * 更新时间
  9.  */
  10. @TableField(fill = FieldFill.INSERT_UPDATE)
  11. private Date updateTime;

7、逻辑删除

  1. /**
  2.  *     开启逻辑删除
  3.  *     未删除：1 已删除：0
  4.  */
  5. @TableLogic(value = "1", delval = "0")
  6. private Integer deleted;

8、编写业务代码

controller

  1. @CrossOrigin
  2. @RestController
  3. @RequestMapping("/xxx")

分页+条件+联表查询

  1. // mybatisplus分页插件配置
  2. @Configuration
  3. @MapperScan("com.william.mapper")
  4. public class MybatisPlusConfig {
  5.     // 最新版
  6.     @Bean
  7.     public MybatisPlusInterceptor mybatisPlusInterceptor() {
  8.         MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
  9.         interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));
  10.         return interceptor;
  11.     }
  12. }
  1. // VO
  2. @Data
  3. public class PageQueryVO {
  4.     /**
  5.      * 学号
  6.      */
  7.     public String studentId;
  8.     /**
  9.      * 实验室号
  10.      */
  11.     public String roomId;
  12.     /**
  13.      * 用户名
  14.      */
  15.     public String userName;
  16.     /**
  17.      * 预约状态
  18.      */
  19.     public Integer status;
  20. }
  1.     // controller
  2.     @ApiOperation(value = "分页+条件+联表查询预约信息")
  3.     @PostMapping("/getAppointPage/{curPage}/{pageSize}")
  4.     public R getAppointPage(@PathVariable Integer curPage, @PathVariable Integer pageSize, @RequestBody(required = false) PageQueryVO pageQueryVO) {
  5.         Page<AppointPageVO> page = appointmentService.getAppointPageVO(curPage, pageSize, pageQueryVO);
  6.         if (page != null) {
  7.             return R.ok().data("page", page).message("查询成功");
  8.         } else {
  9.             return R.error().message("查询失败");
  10.         }
  11.     }
  1. // service
  2. public interface IAppointmentService extends IService<Appointment> {
  3.     Page<AppointPageVO> getAppointPageVO(Integer curPage, Integer pageSize, PageQueryVO pageQueryVO);
  4. }
  6. // service.impl
  7. @Service
  8. public class AppointmentServiceImpl extends ServiceImpl<AppointmentMapper, Appointment> implements IAppointmentService {
  9.         @Override
  10.     public Page<AppointPageVO> getAppointPageVO(Integer curPage, Integer pageSize, PageQueryVO pageQueryVO)     {
  11.         Page<AppointPageVO> page = new Page<>(curPage, pageSize);
  12.         return  baseMapper.pageList(page, pageQueryVO);
  13.     }
  14. }
  1. // mapper
  2. public interface AppointmentMapper extends BaseMapper<Appointment> {
  3.     Page<AppointPageVO> pageList(@Param("page") Page<AppointPageVO> page, @Param("pageQueryVO") PageQueryVO pageQueryVO);
  4. }
  1. // mapper.xml
  2. <?xml version="1.0" encoding="UTF-8"?>
  3. <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  4. <mapper namespace="com.william.mapper.AppointmentMapper">
  6.     <select id="pageList" resultType="com.william.entity.vo.AppointPageVO">
  7.         select a.id,
  8.                a.room_id,
  9.                a.date,
  10.                a.time,
  11.                a.status,
  12.                u.user_name,
  13.                u.student_id
  14.         from appointment a, `user` u
  15.         <where>
  16.             a.user_id = u.user_id
  17.             and u.deleted = 1
  18.             <if test="pageQueryVO.studentId != null and !(pageQueryVO.studentId).equals('')">and u.student_id=#{pageQueryVO.studentId}</if>
  19.             <if test="pageQueryVO.roomId != null and !(pageQueryVO.roomId).equals('')">and a.room_id=#{pageQueryVO.roomId}</if>
  20.             <if test="pageQueryVO.status != null and !(pageQueryVO.status).equals('')">and a.status=#{pageQueryVO.status}</if>
  21.         </where>
  22.         order by a.id desc
  23.     </select>
  24. </mapper>

9、swagger2

  1. @Configuration
  2. @EnableSwagger2
  3. public class SwaggerConfig {
  5.     //默认文档地址为 http://localhost:port/swagger-ui.html
  6.     @Bean
  7.     public Docket createRestApi() {
  9.         return new Docket(DocumentationType.SWAGGER_2)          //指定Api类型为Swagger2
  10.                 .apiInfo(apiInfo())                             //指定文档汇总信息
  11.                 .select()
  12.                 .apis(RequestHandlerSelectors
  13.                         .basePackage("com.william.controller")) //指定controller包路径
  14.                 .paths(PathSelectors.any())                     //指定展示所有controller
  15.                 .build();
  16.     }
  18.     private ApiInfo apiInfo() {
  19.         //返回一个apiinfo
  20.         return new ApiInfoBuilder()
  21.                 .title("预约系统")                                       //文档页标题
  22.                 .description("api文档")                                       // 详细信息
  23.                 .version("1.0.0")                                           // 文档版本号
  24.                 .termsOfServiceUrl("https://www.baidu.com")                  //网站地址
  25.                 .build();
  26.     }
  27. }

10、登录功能

MD5

  1. /**
  2.  * MD5非对称加密工具类
  3.  */
  4. public final class MD5 {
  6.     public static String encrypt(String strSrc) {
  7.         try {
  8.             char hexChars[] = {'0', '1', '2', '3', '4', '5', '6', '7', '8',
  9.                     '9', 'a', 'b', 'c', 'd', 'e', 'f'};
  10.             byte[] bytes = strSrc.getBytes();
  11.             MessageDigest md = MessageDigest.getInstance("MD5");
  12.             md.update(bytes);
  13.             bytes = md.digest();
  14.             int j = bytes.length;
  15.             char[] chars = new char[j * 2];
  16.             int k = 0;
  17.             for (int i = 0; i < bytes.length; i++) {
  18.                 byte b = bytes[i];
  19.                 chars[k++] = hexChars[b >>> 4 & 0xf];
  20.                 chars[k++] = hexChars[b & 0xf];
  21.             }
  22.             return new String(chars);
  23.         } catch (NoSuchAlgorithmException e) {
  24.             e.printStackTrace();
  25.             throw new RuntimeException("MD5加密出错！！+" + e);
  26.         }
  27.     }
  29. }

JwtUtil

  1. public class JwtUtil {
  3.     private static String signature = "密钥";
  4.     private static String tokenName = "从request.header中取token的名称";
  7.     /**
  8.      * 根据用户信息生成JwtToken
  9.      *
  10.      * @param user 用户信息
  11.      * @return token
  12.      */
  13.     public static String createToken(User user) {
  14.         JwtBuilder jwtBuilder = Jwts.builder();
  16.         return jwtBuilder
  17.                 // header
  18.                 .setHeaderParam("typ", "JWT")
  19.                 .setHeaderParam("alg", "HS256")
  20.                 // payload
  21.                 .claim("password", user.getPassword())
  22.                 // userId存在Subject中
  23.                 .setSubject(user.getUserId().toString())
  24.                 // 24H过期
  25.                 .setExpiration(DateUtil.tomorrow())
  26.                 .setId(UUID.randomUUID().toString())
  27.                 // signature
  28.                 .signWith(SignatureAlgorithm.HS256, signature)
  29.                 .compact();
  30.     }
  33.     /**
  34.      * 解析request.header中的token获取用户id并返回
  35.      *
  36.      * @param request
  37.      * @return
  38.      */
  39.     public static String getUserIdByJwtToken(HttpServletRequest request) {
  41.         String jwtToken = request.getHeader(tokenName);
  43.         if (StrUtil.hasEmpty(jwtToken)) {
  44.             return "";
  45.         }
  47.         JwtParser parser = Jwts.parser();
  48.         Jws<Claims> claimsJws = parser.setSigningKey(signature).parseClaimsJws(jwtToken);
  49.         Claims jwsBody = claimsJws.getBody();
  51.         // 加密时Subject中存的是用户id
  52.         return jwsBody.getSubject();
  53.     }
  56.     /**
  57.      * 解析token返回body
  58.      */
  59.     public static Claims getBodyByJwtToken(String jwtToken) {
  61.         JwtParser parser = Jwts.parser();
  62.         Jws<Claims> claimsJws = parser.setSigningKey(signature).parseClaimsJws(jwtToken);
  64.         // 加密时Subject中存的是用户id
  65.         return claimsJws.getBody();
  66.     }
  67. }

service.impl

  1. public String login(User user) {
  2.     String studentId = user.getStudentId();
  3.     String password = user.getPassword();
  5.     // 非空校验
  6.     if (StrUtil.hasEmpty(studentId) || StrUtil.hasEmpty(password)) {
  7.         throw new MyException(ResultCode.ERROR, "登陆失败");
  8.     }
  10.     // 根据学号查数据
  11.     QueryWrapper<User> wrapper = new QueryWrapper<User>();
  12.     wrapper.eq("student_id", studentId);
  13.     User userInBase = baseMapper.selectOne(wrapper);
  15.     // 判断学号是否存在
  16.     if (userInBase == null) {
  17.         throw new MyException(ResultCode.ERROR, "登陆失败,用户不存在");
  18.     }
  20.     //判断密码是否符合  前端传来的密码通过MD5加密后和数据库中比较
  21.     if (!MD5.encrypt(password).equals(userInBase.getPassword())) {
  22.         throw new MyException(ResultCode.ERROR, "登录失败，密码错误");
  23.     }
  25.     // 登录成功，状态设为在线并返回token
  26.     userInBase.setStatus(UserStatusEnum.ACTIVE);
  27.     baseMapper.updateById(userInBase);
  28.     return JwtUtil.createToken(userInBase);
  29. }

根据token获取用户信息

  1. @ApiOperation(value = "根据token返回用户信息和权限", notes = "token在请求中的header中携带")
  2. @GetMapping("/getUserInfo")
  3. public R getUserInfo(HttpServletRequest request) {
  4.     String userId = JwtUtil.getUserIdByJwtToken(request);
  5.     User user = userService.getById(userId);
  7.     if (user != null) {
  8.         user.setStatus(UserStatusEnum.ACTIVE);
  9.         userService.updateById(user);
  10.         Role role = roleService.getById(user.getRoleId());
  11.         LinkedList<String> rolesList = new LinkedList<>();
  12.         rolesList.add(role.getRoleKey());
  13.         // 前端根据返回的roles动态生成路由
  14.         return R.ok().data("userInfo", user).data("roles", rolesList).message("获取用户信息成功");
  15.     } else {
  16.         return R.error().message("获取用户信息失败");
  17.     }
  18. }

11、使用excel导入用户

  1. @Data
  2. public class UserExcel {
  3.     /**
  4.      * 姓名
  5.      */
  6.     @ExcelProperty("姓名")
  7.     private String userName;
  9.     /**
  10.      * 学号
  11.      */
  12.     @ExcelProperty("学号")
  13.     private String studentId;
  15.     /**
  16.      * 学院
  17.      */
  18.     @ExcelProperty("学院")
  19.     private String college;
  21.     /**
  22.      * 专业班级
  23.      */
  24.     @ExcelProperty("专业班级")
  25.     private String major;
  26. }
  1. // 有个很重要的点 DemoDataListener 不能被spring管理，要每次读取excel都要new,然后里面用到spring可以构造方法传进去
  3. /**
  4.  * easyExcel监听器
  5.  * @author william
  6.  */
  7. public class UploadDataListener extends AnalysisEventListener<UserExcel> {
  8.     private static final Logger LOGGER = LoggerFactory.getLogger(UploadDataListener.class);
  9.     /**
  10.      * 每隔10条存储数据库，实际使用中可以3000条，然后清理list ，方便内存回收
  11.      */
  12.     private static final int BATCH_COUNT = 10;
  13.     List<UserExcel> list = new ArrayList<UserExcel>();
  14.     /**
  15.      * 假设这个是一个DAO，当然有业务逻辑这个也可以是一个service。当然如果不用存储这个对象没用。
  16.      */
  17.     private  IUserService userService;
  19.     /**
  20.      * 如果使用了spring,请使用这个构造方法。每次创建Listener的时候需要把spring管理的类传进来
  21.      */
  22.     public UploadDataListener(IUserService userService) {
  23.         this.userService = userService;
  24.     }
  25.     /**
  26.      * 这个每一条数据解析都会来调用
  27.      */
  28.     @Override
  29.     public void invoke(UserExcel data, AnalysisContext context) {
  30.         LOGGER.info("解析到一条数据:{}", JSONUtil.toJsonStr(data));
  31.         // 判断学号是否是已经存在数据库中的
  32.         String studentId = data.getStudentId();
  33.         QueryWrapper<User> wrapper = new QueryWrapper<>();
  34.         wrapper.eq("student_id", studentId);
  35.         User one = userService.getOne(wrapper);
  36.         if (one == null){
  37.             list.add(data);
  38.         } else {
  39.             LOGGER.error("学号为{}的数据已存在!", studentId);
  40.         }
  41.         // 达到BATCH_COUNT了，需要去存储一次数据库，防止数据几万条数据在内存，容易OOM
  42.         if (list.size() >= BATCH_COUNT) {
  43.             saveData();
  44.             // 存储完成清理 list
  45.             list.clear();
  46.         }
  47.     }
  48.     /**
  49.      * 所有数据解析完成了 都会来调用
  50.      *
  51.      * @param context
  52.      */
  53.     @Override
  54.     public void doAfterAllAnalysed(AnalysisContext context) {
  55.         // 这里也要保存数据，确保最后遗留的数据也存储到数据库
  56.         saveData();
  57.         LOGGER.info("所有数据解析完成！");
  58.     }
  59.     /**
  60.      * 加上存储数据库
  61.      */
  62.     private void saveData() {
  63.         LOGGER.info("{}条数据，开始存储数据库！", list.size());
  64.         userService.saveBatch(list);
  65.         LOGGER.info("存储数据库成功！");
  66.     }
  67. }
  1. @ApiOperation(value = "通过excel导入学生信息")
  2. @PostMapping("/addUserByExcel")
  3. public R addUserByExcel(MultipartFile file) throws IOException {
  4.     userService.saveUsers(file, userService);
  5.     return R.ok().message("导入成功");
  6. }
  1. public void saveUsers(MultipartFile file, IUserService userService) {
  2.     try {
  3.         //获取文件输入流
  4.         InputStream inputStream = file.getInputStream();
  5.         // 调用方法读取文件
  6.         EasyExcel.read(inputStream, UserExcel.class, new UploadDataListener(userService)).sheet().doRead();
  7.     } catch (IOException e) {
  8.         e.printStackTrace();
  9.     }
  10. }

12、logback日志

logback-spring.xml

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <configuration  scan="true" scanPeriod="10 seconds">
  3.     <!-- 日志级别从低到高分为TRACE < DEBUG < INFO < WARN < ERROR < FATAL，如果设置为WARN，则低于WARN的信息都不会输出 -->
  4.     <!-- scan:当此属性设置为true时，配置文件如果发生改变，将会被重新加载，默认值为true -->
  5.     <!-- scanPeriod:设置监测配置文件是否有修改的时间间隔，如果没有给出时间单位，默认单位是毫秒。当scan为true时，此属性生效。默认的时间间隔为1分钟。 -->
  6.     <!-- debug:当此属性设置为true时，将打印出logback内部日志信息，实时查看logback运行状态。默认值为false。 -->
  8.     <contextName>logback</contextName>
  9.     <!-- name的值是变量的名称，value的值时变量定义的值。通过定义的值会被插入到logger上下文中。定义变量后，可以使“${}”来使用变量。 -->
  10.     <property name="log.path" value="log" />
  12.     <!-- 彩色日志 -->
  13.     <!-- 配置格式变量：CONSOLE_LOG_PATTERN 彩色日志格式 -->
  14.     <!-- magenta:洋红 -->
  15.     <!-- boldMagenta:粗红-->
  16.     <!-- cyan:青色 -->
  17.     <!-- white:白色 -->
  18.     <!-- magenta:洋红 -->
  19.     <property name="CONSOLE_LOG_PATTERN"
  20.               value="%yellow(%date{yyyy-MM-dd HH:mm:ss}) |%highlight(%-5level) |%blue(%thread) |%blue(%file:%line) |%green(%logger) |%cyan(%msg%n)"/>
  23.     <!--输出到控制台-->
  24.     <appender name="CONSOLE" class="ch.qos.logback.core.ConsoleAppender">
  25.         <!--此日志appender是为开发使用，只配置最底级别，控制台输出的日志级别是大于或等于此级别的日志信息-->
  26.         <!-- 例如：如果此处配置了INFO级别，则后面其他位置即使配置了DEBUG级别的日志，也不会被输出 -->
  27.         <filter class="ch.qos.logback.classic.filter.ThresholdFilter">
  28.             <level>DEBUG</level>
  29.         </filter>
  30.         <encoder>
  31.             <Pattern>${CONSOLE_LOG_PATTERN}</Pattern>
  32.             <!-- 设置字符集 -->
  33.             <charset>UTF-8</charset>
  34.         </encoder>
  35.     </appender>
  38.     <!--输出到文件-->
  40.     <!-- 时间滚动输出 level为 INFO 日志 -->
  41.     <appender name="INFO_FILE" class="ch.qos.logback.core.rolling.RollingFileAppender">
  42.         <!-- 正在记录的日志文件的路径及文件名 -->
  43.         <file>${log.path}/log_info.log</file>
  44.         <!--日志文件输出格式-->
  45.         <encoder>
  46.             <pattern>%d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %-5level %logger{50} - %msg%n</pattern>
  47.             <charset>UTF-8</charset>
  48.         </encoder>
  49.         <!-- 日志记录器的滚动策略，按日期，按大小记录 -->
  50.         <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
  51.             <!-- 每天日志归档路径以及格式 -->
  52.             <fileNamePattern>${log.path}/info/log-info-%d{yyyy-MM-dd}.%i.log</fileNamePattern>
  53.             <timeBasedFileNamingAndTriggeringPolicy class="ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP">
  54.                 <maxFileSize>100MB</maxFileSize>
  55.             </timeBasedFileNamingAndTriggeringPolicy>
  56.             <!--日志文件保留天数-->
  57.             <maxHistory>15</maxHistory>
  58.         </rollingPolicy>
  59.         <!-- 此日志文件只记录info级别的 -->
  60.         <filter class="ch.qos.logback.classic.filter.LevelFilter">
  61.             <level>INFO</level>
  62.             <onMatch>ACCEPT</onMatch>
  63.             <onMismatch>DENY</onMismatch>
  64.         </filter>
  65.     </appender>
  67.     <!-- 时间滚动输出 level为 WARN 日志 -->
  68.     <appender name="WARN_FILE" class="ch.qos.logback.core.rolling.RollingFileAppender">
  69.         <!-- 正在记录的日志文件的路径及文件名 -->
  70.         <file>${log.path}/log_warn.log</file>
  71.         <!--日志文件输出格式-->
  72.         <encoder>
  73.             <pattern>%d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %-5level %logger{50} - %msg%n</pattern>
  74.             <charset>UTF-8</charset> <!-- 此处设置字符集 -->
  75.         </encoder>
  76.         <!-- 日志记录器的滚动策略，按日期，按大小记录 -->
  77.         <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
  78.             <fileNamePattern>${log.path}/warn/log-warn-%d{yyyy-MM-dd}.%i.log</fileNamePattern>
  79.             <timeBasedFileNamingAndTriggeringPolicy class="ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP">
  80.                 <maxFileSize>100MB</maxFileSize>
  81.             </timeBasedFileNamingAndTriggeringPolicy>
  82.             <!--日志文件保留天数-->
  83.             <maxHistory>15</maxHistory>
  84.         </rollingPolicy>
  85.         <!-- 此日志文件只记录warn级别的 -->
  86.         <filter class="ch.qos.logback.classic.filter.LevelFilter">
  87.             <level>warn</level>
  88.             <onMatch>ACCEPT</onMatch>
  89.             <onMismatch>DENY</onMismatch>
  90.         </filter>
  91.     </appender>
  94.     <!-- 时间滚动输出 level为 ERROR 日志 -->
  95.     <appender name="ERROR_FILE" class="ch.qos.logback.core.rolling.RollingFileAppender">
  96.         <!-- 正在记录的日志文件的路径及文件名 -->
  97.         <file>${log.path}/log_error.log</file>
  98.         <!--日志文件输出格式-->
  99.         <encoder>
  100.             <pattern>%d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %-5level %logger{50} - %msg%n</pattern>
  101.             <charset>UTF-8</charset> <!-- 此处设置字符集 -->
  102.         </encoder>
  103.         <!-- 日志记录器的滚动策略，按日期，按大小记录 -->
  104.         <rollingPolicy class="ch.qos.logback.core.rolling.TimeBasedRollingPolicy">
  105.             <fileNamePattern>${log.path}/error/log-error-%d{yyyy-MM-dd}.%i.log</fileNamePattern>
  106.             <timeBasedFileNamingAndTriggeringPolicy class="ch.qos.logback.core.rolling.SizeAndTimeBasedFNATP">
  107.                 <maxFileSize>100MB</maxFileSize>
  108.             </timeBasedFileNamingAndTriggeringPolicy>
  109.             <!--日志文件保留天数-->
  110.             <maxHistory>15</maxHistory>
  111.         </rollingPolicy>
  112.         <!-- 此日志文件只记录ERROR级别的 -->
  113.         <filter class="ch.qos.logback.classic.filter.LevelFilter">
  114.             <level>ERROR</level>
  115.             <onMatch>ACCEPT</onMatch>
  116.             <onMismatch>DENY</onMismatch>
  117.         </filter>
  118.     </appender>
  120.     <!--
  121.         <logger>用来设置某一个包或者具体的某一个类的日志打印级别、以及指定<appender>。
  122.         <logger>仅有一个name属性，
  123.         一个可选的level和一个可选的addtivity属性。
  124.         name:用来指定受此logger约束的某一个包或者具体的某一个类。
  125.         level:用来设置打印级别，大小写无关：TRACE, DEBUG, INFO, WARN, ERROR, ALL 和 OFF，
  126.               如果未设置此属性，那么当前logger将会继承上级的级别。
  127.     -->
  128.     <!--
  129.         使用mybatis的时候，sql语句是debug下才会打印，而这里我们只配置了info，所以想要查看sql语句的话，有以下两种操作：
  130.         第一种把<root level="INFO">改成<root level="DEBUG">这样就会打印sql，不过这样日志那边会出现很多其他消息
  131.         第二种就是单独给mapper下目录配置DEBUG模式，代码如下，这样配置sql语句会打印，其他还是正常DEBUG级别：
  132.      -->
  133.     <!--开发环境:打印控制台-->
  134.     <springProfile name="dev">
  135.         <!--可以输出项目中的debug日志，包括mybatis的sql日志-->
  136.         <logger name="com.william" level="INFO" />
  138.         <!--
  139.             root节点是必选节点，用来指定最基础的日志输出级别，只有一个level属性
  140.             level:用来设置打印级别，大小写无关：TRACE, DEBUG, INFO, WARN, ERROR, ALL 和 OFF，默认是DEBUG
  141.             可以包含零个或多个appender元素。
  142.         -->
  143.         <root level="INFO">
  144.             <appender-ref ref="CONSOLE" />
  145.             <appender-ref ref="INFO_FILE" />
  146.             <appender-ref ref="WARN_FILE" />
  147.             <appender-ref ref="ERROR_FILE" />
  148.         </root>
  149.     </springProfile>
  152.     <!--生产环境:输出到文件-->
  153.     <springProfile name="pro">
  155.         <root level="INFO">
  156.             <appender-ref ref="CONSOLE" />
  157.             <appender-ref ref="DEBUG_FILE" />
  158.             <appender-ref ref="INFO_FILE" />
  159.             <appender-ref ref="ERROR_FILE" />
  160.             <appender-ref ref="WARN_FILE" />
  161.         </root>
  162.     </springProfile>
  164. </configuration>

在全局异常处理类上加

  1. @ControllerAdvice
  2. @Slf4j

13、sureness鉴权

根据角色分配资源（RESTapi）

基于springboot和jwt的预约系统 - 图1

  1. @Component
  2. public class DatabaseAccountProvider implements SurenessAccountProvider {
  3.     @Resource
  4.     private IUserService userService;
  6.     @Override
  7.     public SurenessAccount loadAccount(String appId) {
  8.         return userService.loadAccount(appId);
  9.     }
  10. }
  1.     // userService.impl
  2.     @Override
  3.     public SurenessAccount loadAccount(String appId) {
  4.         User user = baseMapper.selectById(appId);
  5.         if (user != null) {
  6.             DefaultAccount.Builder accountBuilder = DefaultAccount.builder(appId)
  7.                     .setPassword(user.getPassword())
  8.                     .setDisabledAccount(user.getDeleted() == 0);
  9.             Role role = roleMapper.selectById(user.getRoleId());
  10.             if (role != null) {
  11.                 List<String> roles = new LinkedList<>();
  12.                 roles.add(role.getRoleKey());
  13.                 accountBuilder.setOwnRoles(roles);
  14.             }
  15.             return accountBuilder.build();
  16.         } else {
  17.             return null;
  18.         }
  19.     }
  1. public class RefreshExpiredTokenException extends SurenessAuthenticationException {
  2.     public RefreshExpiredTokenException(String message) {
  3.         super(message);
  4.     }
  5. }
  1. public class PasswdSubjectCreator implements SubjectCreate {
  3.     private static final String jwtName = "token名字";
  5.     @Override
  6.     public boolean canSupportSubject(Object context) {
  7.         // define which request can be access
  8.         if (context instanceof HttpServletRequest) {
  9.             String token = ((HttpServletRequest) context).getHeader(jwtName);
  10.             return token != null;
  11.         } else {
  12.             return false;
  13.         }
  14.     }
  16.     @Override
  17.     public Subject createSubject(Object context) {
  18.         // create PasswordSubject from request
  19.         // 从jwt中拿用户名和密码做鉴权
  20.         String token = ((HttpServletRequest) context).getHeader(jwtName);
  21.         Claims body = JwtUtil.getBodyByJwtToken(token);
  22.         String username = body.getSubject();
  23.         String password = (String) body.get("password");
  26.         String remoteHost = ((HttpServletRequest) context).getRemoteHost();
  27.         String requestUri = ((HttpServletRequest) context).getRequestURI();
  28.         String requestType = ((HttpServletRequest) context).getMethod();
  29.         String targetUri = requestUri.concat("===").concat(requestType).toLowerCase();
  30.         return PasswordSubject.builder(username, password)
  31.                 .setRemoteHost(remoteHost)
  32.                 .setTargetResource(targetUri)
  33.                 .build();
  34.     }
  35. }
  1. @Configuration
  2. public class SurenessConfiguration {
  3.     @Bean
  4.     ProcessorManager processorManager(SurenessAccountProvider accountProvider) {
  5.         //    处理器processor初始化
  6.         List<Processor> processorList = new LinkedList<>();
  7.         //     使用了默认的支持NoneSubject的处理器NoneProcessor
  8.         NoneProcessor noneProcessor = new NoneProcessor();
  9.         processorList.add(noneProcessor);
  10.         // 使用了默认的支持JwtSubject的处理器JwtProcessor
  11.         JwtProcessor jwtProcessor = new JwtProcessor();
  12.         processorList.add(jwtProcessor);
  13.         // 使用了默认的支持PasswordSubject的处理器PasswordProcessor
  14.         PasswordProcessor passwordProcessor = new PasswordProcessor();
  15.         // 这里注意，PasswordProcessor需要对用户账户密码验证，所以其需要账户信息提供者来给他提供想要的账户数据，
  16.         // 这里的 SurenessAccountProvider accountProvider bean就是这个账户数据提供源，
  17.         // 其实现bean是上面讲到的 DatabaseAccountProvider bean,即数据库实现的账户数据提供者。
  18.         passwordProcessor.setAccountProvider(accountProvider);
  19.         processorList.add(passwordProcessor);
  20.         return new DefaultProcessorManager(processorList);
  21.     }
  23.     @Bean
  24.     TreePathRoleMatcher pathRoleMatcher() {
  25.         // 这里的PathTreeProvider databasePathTreeProvider 就是通过数据库来提供资源权限配置信息bean实例
  26.         // 下面我们再实例化一个通过文件sureness.yml提供资源权限配置信息的提供者
  27.         PathTreeProvider documentPathTreeProvider = new DocumentPathTreeProvider();
  28.         // 下面我们再实例化一个通过注解形式@RequiresRoles @WithoutAuth提供资源权限配置信息的提供者
  29.         AnnotationPathTreeProvider annotationPathTreeProvider = new AnnotationPathTreeProvider();
  30.         annotationPathTreeProvider.setScanPackages(Collections.singletonList("com.william.controller"));
  31.         // 设置注解扫描包路径，也就是你提供api的controller路径 annotationPathTreeProvider.setScanPackages(Collections.singletonList("com.usthe.sureness.sample.tom.controller"));
  32.         // 开始初始化资源权限匹配器，我们可以把上面三种提供者都加入到匹配器中为其提供资源权限数据，匹配器中的数据就是这三个提供者提供的数据集合。t
  33.         DefaultPathRoleMatcher pathRoleMatcher = new DefaultPathRoleMatcher();
  34.         pathRoleMatcher.setPathTreeProviderList(Arrays.asList(
  35.                 documentPathTreeProvider,
  36.                 annotationPathTreeProvider));
  37.         // 使用资源权限配置数据来建立对应的匹配树
  38.         pathRoleMatcher.buildTree();
  39.         return pathRoleMatcher;
  40.     }
  42.     @Bean
  43.     SubjectFactory subjectFactory() {
  44.         // 我们之前知道了可以有各种Processor来处理对应的Jwt，那这Subject怎么得到呢，就需要不同的SubjectCreator来根据请求信息创建对应的Subject对象供之后的流程使用
  45.         SubjectFactory subjectFactory = new SurenessSubjectFactory();
  46.         // 这里我们注册我们需要的SubjectCreator
  47.         subjectFactory.registerSubjectCreator(Arrays.asList(
  48.                 // 注意! 强制必须首先添加一个 noSubjectCreator
  49.                 new NoneSubjectServletCreator(),
  50.                 // 注册用来创建PasswordSubject的creator
  51.                 new BasicSubjectServletCreator(),
  52.                 // 注册用来创建JwtSubject的creator
  53.                 new JwtSubjectServletCreator(),
  54.                 // 当然你可以自己实现一个自定义的creator，实现SubjectCreate接口即可
  55.                 new PasswdSubjectCreator()));
  56.         return subjectFactory;
  57.     }
  59.     @Bean
  60.     SurenessSecurityManager securityManager(ProcessorManager processorManager,
  61.                                             TreePathRoleMatcher pathRoleMatcher, SubjectFactory subjectFactory) {
  62.         // 我们把上面初始化好的配置bean整合到一起初始化surenessSecurityManager
  63.         SurenessSecurityManager securityManager = SurenessSecurityManager.getInstance();
  64.         // 设置资源权限匹配者
  65.         securityManager.setPathRoleMatcher(pathRoleMatcher);
  66.         // 设置subject创建工厂
  67.         securityManager.setSubjectFactory(subjectFactory);
  68.         // 设置处理器processor管理者
  69.         securityManager.setProcessorManager(processorManager);
  70.         return securityManager;
  71.     }
  72. }

过滤器

在启动类中开启@ServletComponentScan

  1. @Order(1)
  2. @WebFilter(filterName = "SurenessFilter", urlPatterns = "/*", asyncSupported = true)
  3. public class SurenessFilter implements Filter {
  5.     /** logger **/
  6.     private static final Logger logger = LoggerFactory.getLogger(SurenessFilter.class);
  8.     @Override
  9.     public void doFilter(ServletRequest servletRequest, ServletResponse servletResponse, FilterChain filterChain) throws IOException, ServletException {
  11.         try {
  12.             SubjectSum subject = SurenessSecurityManager.getInstance().checkIn(servletRequest);
  13.             // You can consider using SurenessContextHolder to bind subject in threadLocal
  14.             // if bind, please remove it when end
  15.             if (subject != null) {
  16.                 SurenessContextHolder.bindSubject(subject);
  17.             }
  18.         } catch (IncorrectCredentialsException | UnknownAccountException | ExpiredCredentialsException e1) {
  19.             logger.debug("this request account info is illegal, {}", e1.getMessage());
  20.             responseWrite(ResponseEntity
  21.                     .status(HttpStatus.UNAUTHORIZED).body("Username or password is incorrect or expired"), servletResponse);
  22.             return;
  23.         } catch (DisabledAccountException | ExcessiveAttemptsException e2 ) {
  24.             logger.debug("the account is disabled, {}", e2.getMessage());
  25.             responseWrite(ResponseEntity
  26.                     .status(HttpStatus.UNAUTHORIZED).body("Account is disabled"), servletResponse);
  27.             return;
  28.         } catch (RefreshExpiredTokenException e4) {
  29.             logger.debug("this account credential token is expired, return refresh value");
  30.             Map<String, String> refreshTokenMap = Collections.singletonMap("refresh-token", e4.getMessage());
  31.             responseWrite(ResponseEntity
  32.                     .status(HttpStatus.UNAUTHORIZED).body(refreshTokenMap), servletResponse);
  33.             return;
  34.         } catch (UnauthorizedException e5) {
  35.             logger.debug("this account can not access this resource, {}", e5.getMessage());
  36.             responseWrite(ResponseEntity
  37.                     .status(HttpStatus.FORBIDDEN)
  38.                     .body("This account has no permission to access this resource"), servletResponse);
  39.             return;
  40.         } catch (RuntimeException e) {
  41.             logger.error("other exception happen: ", e);
  42.             responseWrite(ResponseEntity.status(HttpStatus.INTERNAL_SERVER_ERROR).build(),
  43.                     servletResponse);
  44.             return;
  45.         }
  46.         try {
  47.             // if ok, doFilter and add subject in request
  48.             filterChain.doFilter(servletRequest, servletResponse);
  49.         } finally {
  50.             SurenessContextHolder.clear();
  51.         }
  52.     }
  54.     /**
  55.      * write response json data
  56.      * @param content content
  57.      * @param response response
  58.      */
  59.     private void responseWrite(ResponseEntity<?> content, ServletResponse response) {
  60.         response.setCharacterEncoding("UTF-8");
  61.         response.setContentType("application/json;charset=utf-8");
  62.         ((HttpServletResponse)response).setStatus(content.getStatusCodeValue());
  63.         content.getHeaders().forEach((key, value) ->
  64.                 ((HttpServletResponse) response).addHeader(key, value.get(0)));
  65.         try (PrintWriter printWriter = response.getWriter()) {
  66.             if (content.getBody() != null) {
  67.                 if (content.getBody() instanceof String) {
  68.                     printWriter.write(content.getBody().toString());
  69.                 } else {
  70.                     ObjectMapper objectMapper = new ObjectMapper();
  71.                     printWriter.write(objectMapper.writeValueAsString(content.getBody()));
  72.                 }
  73.             } else {
  74.                 printWriter.flush();
  75.             }
  76.         } catch (IOException e) {
  77.             logger.error("responseWrite response error: ", e);
  78.         }
  79.     }
  80. }

sureness.yml

  1. ## -- sureness.yml document dataSource-- ##
  3. # load api resource which need be protected, config role who can access these resource.
  4. # resources that are not configured are also authenticated and protected by default, but not authorized
  5. # eg: /api/v2/host===post===[role2,role3,role4] means /api/v2/host===post can be access by role2,role3,role4
  6. # eg: /api/v1/getSource3===get===[] means /api/v1/getSource3===get can not be access by any role
  7. resourceRole:
  8.   - /room/editRoomInfoById===post===[admin,teacher]
  9.   - /room/getRoomList===get===[admin,teacher]
  10.   - /user/addUserByExcel===post===[admin,teacher]
  11.   - /user/changePassword===post===[student]
  12.   - /user/changePasswordById===post===[admin,teacher]
  13.   - /user/editUserInfo===post===[admin,teacher]
  14.   - /user/getUserList/**===post===[admin,teacher]
  15.   - /user/logout===post===[admin,teacher,student]
  16.   - /appointment/cancelAppointmentById/**===delete===[admin,teacher,student]
  17.   - /appointment/doAppointment===post===[admin,teacher,student]
  18.   - /appointment/getAppointPage/**===post===[admin,teacher]
  21. # load api resource which do not need be protected, means them need be excluded.
  22. # these api resource can be access by everyone
  23. excludedResource:
  24.   - /user/login===post
  25.   - /room/getRoomInfoById/**===get
  26.   - /user/getUserInfo===get
  27.   - /user/getUserInfoById/*===get
  28.   - /appointment/getHistory/**===get
  29.   - /appointment/getRecent/**===get
  30.   - /**/*.css===get
  31.   - /**/*.ico===get
  32.   - /**/*.png===get
  33.   - /swagger-ui.html===*
  34.   - /swagger/**===*
  35.   - /swagger-resources/**===*
  36.   - /v2/**===*
  37.   - /webjars/**===*
  38.   - /configuration/**===*
  39. st===[role2,role3,role4] means /api/v2/host===post can be access by role2,role3,role4
  40. # eg: /api/v1/getSource3===get===[] means /api/v1/getSource3===get can not be access by any role
  41. resourceRole:
  42.   - /room/editRoomInfoById===post===[admin,teacher]
  43.   - /room/getRoomList===get===[admin,teacher]
  44.   - /user/addUserByExcel===post===[admin,teacher]
  45.   - /user/changePassword===post===[student]
  46.   - /user/changePasswordById===post===[admin,teacher]
  47.   - /user/editUserInfo===post===[admin,teacher]
  48.   - /user/getUserList/**===post===[admin,teacher]
  49.   - /user/logout===post===[admin,teacher,student]
  50.   - /appointment/cancelAppointmentById/**===delete===[admin,teacher,student]
  51.   - /appointment/doAppointment===post===[admin,teacher,student]
  52.   - /appointment/getAppointPage/**===post===[admin,teacher]
  55. # load api resource which do not need be protected, means them need be excluded.
  56. # these api resource can be access by everyone
  57. excludedResource:
  58.   - /user/login===post
  59.   - /room/getRoomInfoById/**===get
  60.   - /user/getUserInfo===get
  61.   - /user/getUserInfoById/*===get
  62.   - /appointment/getHistory/**===get
  63.   - /appointment/getRecent/**===get
  64.   - /**/*.css===get
  65.   - /**/*.ico===get
  66.   - /**/*.png===get
  67.   - /swagger-ui.html===*
  68.   - /swagger/**===*
  69.   - /swagger-resources/**===*
  70.   - /v2/**===*
  71.   - /webjars/**===*
  72.   - /configuration/**===*