devbox
喵喵爱编程
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

秒杀项目介绍&&登陆模块&&捕捉全局异常_layui对于后端抛异常怎么处理

作者：喵喵爱编程 | 2024-07-10 19:11:14

赞

踩

layui对于后端抛异常怎么处理

一、秒杀项目介绍

1、介绍

秒杀无论是双十一购物还是 12306 抢票，秒杀场景已随处可见。简单来说，秒杀就是在同一时刻大量请求争抢购买同一商品并完成交易的过程。从架构视角来看，秒杀系统本质是一个高性能、高一致、高可用的三高系统。

通俗一点讲就是网络商家为促销等目的组织的网上限时抢购活动

2、特点

  • 高并发：秒杀的特点就是这样时间极短、 瞬间用户量大。
  • 库存量少：一般秒杀活动商品量很少，这就导致了只有极少量用户能成功购买到。
  • 业务简单：流程比较简单，一般都是下订单、扣库存、支付订单
  • 恶意请求，数据库压力大
  • 秒杀的商品不需要添加到购物车
  • 秒杀系统独立部署

二、技术上点介绍

前端：Freemarker、LayUI、jQuery
后端：SpringBoot、MyBatisPlus、Lombok
中间件：RabbitMQ、Redis(redisson)
分布式协调框架：zookeeper

三、项目目标

1.安全优化：隐藏秒杀地址、验证码、接口限流
2.服务优化：RabbitMQ消息队列、接口优化、分布式锁
3.页面优化：缓存、静态化分离
4.分布式会话：用户登录、共享session
5.功能开发：商品列表、商品详情、秒杀、订单详情
6.系统压测：JMeter入门、自定义变量、压测

四、搭建环境

1、配置数据库以及表

导入sql代码

连接到IDEA

2、创建SpringBoot项目并配置POM

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  3.     xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
  4.     <modelVersion>4.0.0</modelVersion>
  5.     <groupId>com.xhy</groupId>
  6.     <artifactId>code</artifactId>
  7.     <version>0.0.1-SNAPSHOT</version>
  8.     <name>code</name>
  9.     <description>Demo project for Spring Boot</description>
  10.  
  11.     <properties>
  12.         <java.version>1.8</java.version>
  13.         <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
  14.         <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
  15.         <spring-boot.version>2.4.1</spring-boot.version>
  16.     </properties>
  17.  
  18.     <dependencies>
  19.         <dependency>
  20.             <groupId>org.springframework.boot</groupId>
  21.             <artifactId>spring-boot-starter</artifactId>
  22.         </dependency>
  23.         <dependency>
  24.             <groupId>org.springframework.boot</groupId>
  25.             <artifactId>spring-boot-starter-aop</artifactId>
  26.         </dependency>
  27.         <dependency>
  28.             <groupId>org.springframework.boot</groupId>
  29.             <artifactId>spring-boot-starter-test</artifactId>
  30.             <scope>test</scope>
  31.         </dependency>
  32.         <dependency>
  33.             <groupId>org.springframework.boot</groupId>
  34.             <artifactId>spring-boot-starter-freemarker</artifactId>
  35.         </dependency>
  36.         <dependency>
  37.             <groupId>org.springframework.boot</groupId>
  38.             <artifactId>spring-boot-starter-web</artifactId>
  39.         </dependency>
  40.         <dependency>
  41.             <groupId>mysql</groupId>
  42.             <artifactId>mysql-connector-java</artifactId>
  43.             <scope>runtime</scope>
  44.         </dependency>
  45.         <dependency>
  46.             <groupId>org.projectlombok</groupId>
  47.             <artifactId>lombok</artifactId>
  48.             <optional>true</optional>
  49.         </dependency>
  50.         <!-- mybatis plus依赖 -->
  51.         <dependency>
  52.             <groupId>com.baomidou</groupId>
  53.             <artifactId>mybatis-plus-boot-starter</artifactId>
  54.             <version>3.5.1</version>
  55.         </dependency>
  56.         <!--mybatis-plus生成器-->
  57.         <dependency>
  58.             <groupId>com.baomidou</groupId>
  59.             <artifactId>mybatis-plus-generator</artifactId>
  60.             <version>3.5.2</version>
  61.         </dependency>
  62.         <!-- MD5依赖 -->
  63.         <dependency>
  64.             <groupId>commons-codec</groupId>
  65.             <artifactId>commons-codec</artifactId>
  66.         </dependency>
  67.         <dependency>
  68.             <groupId>org.apache.commons</groupId>
  69.             <artifactId>commons-lang3</artifactId>
  70.             <version>3.12.0</version>
  71.         </dependency>
  72.         <!-- valid验证依赖 -->
  73.         <dependency>
  74.             <groupId>org.springframework.boot</groupId>
  75.             <artifactId>spring-boot-starter-validation</artifactId>
  76.         </dependency>
  77.         <!--redis-->
  78.         <dependency>
  79.             <groupId>org.springframework.boot</groupId>
  80.             <artifactId>spring-boot-starter-data-redis</artifactId>
  81.         </dependency>
  82.         <!--hariki-->
  83.         <dependency>
  84.             <groupId>com.zaxxer</groupId>
  85.             <artifactId>HikariCP</artifactId>
  86.         </dependency>
  87.     </dependencies>
  88.  
  89.     <dependencyManagement>
  90.         <dependencies>
  91.             <dependency>
  92.                 <groupId>org.springframework.boot</groupId>
  93.                 <artifactId>spring-boot-dependencies</artifactId>
  94.                 <version>${spring-boot.version}</version>
  95.                 <type>pom</type>
  96.                 <scope>import</scope>
  97.             </dependency>
  98.         </dependencies>
  99.     </dependencyManagement>
  100.  
  101.     <build>
  102.         <plugins>
  103.             <plugin>
  104.                 <groupId>org.apache.maven.plugins</groupId>
  105.                 <artifactId>maven-compiler-plugin</artifactId>
  106.                 <version>3.8.1</version>
  107.                 <configuration>
  108.                     <source>1.8</source>
  109.                     <target>1.8</target>
  110.                     <encoding>UTF-8</encoding>
  111.                 </configuration>
  112.             </plugin>
  113.             <plugin>
  114.                 <groupId>org.springframework.boot</groupId>
  115.                 <artifactId>spring-boot-maven-plugin</artifactId>
  116.                 <version>2.4.1</version>
  117.                 <configuration>
  118.                     <mainClass>com.xhy.code.CodeApplication</mainClass>
  119.                 </configuration>
  120.                 <executions>
  121.                     <execution>
  122.                         <id>repackage</id>
  123.                         <goals>
  124.                             <goal>repackage</goal>
  125.                         </goals>
  126.                     </execution>
  127.                 </executions>
  128.             </plugin>
  129.         </plugins>
  130.     </build>
  131.  
  132. </project>

3 、配置application.yml

  1. spring:
  2.   application:
  3.     name: seckill
  4.   datasource:
  5.     url: jdbc:mysql://localhost:3306/seckill?useSSL=false&useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=Asia/Shanghai&characterEncoding=UTF8
  6.     driver-class-name: com.mysql.cj.jdbc.Driver
  7.     username: root
  8.     password: 123456
  9.     hikari:
  10.       # 最小空闲连接数量
  11.       minimum-idle: 5
  12.       # 空闲连接存活最大时间，默认600000（10分钟）
  13.       idle-timeout: 180000
  14.       # 连接池最大连接数，默认是10
  15.       maximum-pool-size: 10
  16.       # 此属性控制从池返回的连接的默认自动提交行为,默认值：true
  17.       auto-commit: true
  18.       # 连接池名称
  19.       pool-name: MyHikariCP
  20.       # 此属性控制池中连接的最长生命周期，值0表示无限生命周期，默认1800000即30分钟
  21.       max-lifetime: 1800000
  22.       # 数据库连接超时时间,默认30秒，即30000
  23.       connection-timeout: 30000
  24.   freemarker:
  25.     #设置编码格式
  26.     charset: UTF-8
  27.     #后缀
  28.     suffix: .ftl
  29.     #文档类型
  30.     content-type: text/html
  31.     #模板前端
  32.     template-loader-path: classpath:/templates/
  33.     #启用模板
  34.     enabled: true
  35.     #开启静态资源
  36.   mvc:
  37.     static-path-pattern: /static/**
  38. mybatis-plus:
  39.   mapper-locations: classpath*:/mapper/*Mapper.xml
  40.   type-aliases-package: com.xhy.seckill.pojo
  41.   configuration:
  42.     map-underscore-to-camel-case: true
  43. logging:
  44.   level:
  45.     com.xhy.seckill.mapper: debug

5、 使用Mybatis-plus反向生成代码

  1. package com.code.ceckill.generator;
  2.  
  3. import com.baomidou.mybatisplus.annotation.FieldFill;
  4. import com.baomidou.mybatisplus.generator.FastAutoGenerator;
  5. import com.baomidou.mybatisplus.generator.config.DataSourceConfig;
  6. import com.baomidou.mybatisplus.generator.config.OutputFile;
  7. import com.baomidou.mybatisplus.generator.config.rules.DateType;
  8. import com.baomidou.mybatisplus.generator.engine.FreemarkerTemplateEngine;
  9. import com.baomidou.mybatisplus.generator.fill.Column;
  10. import lombok.Data;
  11. import lombok.extern.slf4j.Slf4j;
  12.  
  13. import java.util.Arrays;
  14. import java.util.Collections;
  15. import java.util.List;
  16.  
  17. @SuppressWarnings("all")
  18. @Slf4j
  19. @Data
  20. public class MybatisPlusGenerator {
  21.    //url: jdbc:mysql://localhost:3306/seckill?useSSL=false&useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=Asia/Shanghai&characterEncoding=UTF8
  22.  
  23.     protected static String URL = "jdbc:mysql://localhost:3306/seckill?useSSL=false&useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=Asia/Shanghai&characterEncoding=UTF8";
  24.     protected static String USERNAME = "root";
  25.     protected static String PASSWORD = "123456";
  26.  
  27.     protected static DataSourceConfig.Builder DATA_SOURCE_CONFIG = new DataSourceConfig.Builder(URL, USERNAME, PASSWORD);
  28.  
  29.     public static void main(String[] args) {
  30.         FastAutoGenerator.create(DATA_SOURCE_CONFIG)
  31.                 .globalConfig(
  32.                         (scanner/*lamdba*/, builder/*变量*/) ->
  33.                                 builder.author(scanner.apply("请输入作者名称？"))
  34.                                         .enableSwagger()
  35.                                         .fileOverride()
  36.                                         .outputDir(System.getProperty("user.dir") + "\\src\\main\\java")
  37.                                         .commentDate("yyyy-MM-dd")
  38.                                         .dateType(DateType.TIME_PACK)
  39.                 )
  40.                 .packageConfig((builder) ->
  41.                         builder.parent("com.xhy.seckill")
  42.                                 .entity("pojo")
  43.                                 .service("service")
  44.                                 .serviceImpl("service.impl")
  45.                                 .mapper("mapper")
  46.                                 .xml("mapper.xml")
  47.                                 .pathInfo(Collections.singletonMap(OutputFile.xml, System.getProperty("user.dir") + "\\src\\main\\resources\\mapper"))
  48.                 )
  49.                 .injectionConfig((builder) ->
  50.                         builder.beforeOutputFile(
  51.                                 (a, b) -> log.warn("tableInfo: " + a.getEntityName())
  52.                         )
  53.                 )
  54.                 .strategyConfig((scanner, builder) ->
  55.                         builder.addInclude(getTables(scanner.apply("请输入表名，多个英文逗号分隔？所有输入 all")))
  56.                                 .addTablePrefix("tb_", "t_")
  57.                                 .entityBuilder()
  58.                                 .enableChainModel()
  59.                                 .enableLombok()
  60.                                 .enableTableFieldAnnotation()
  61.                                 .addTableFills(
  62.                                         new Column("create_time", FieldFill.INSERT)
  63.                                 )
  64.                                 .controllerBuilder()
  65.                                 .enableRestStyle()
  66.                                 .enableHyphenStyle()
  67.                                 .build())
  68.                 .templateEngine(new FreemarkerTemplateEngine())
  69.                 .execute();
  70.     }
  71.  
  72.     protected static List<String> getTables(String tables) {
  73.         return "all".equals(tables) ? Collections.emptyList() : Arrays.asList(tables.split(","));
  74.     }
  75.  
  76. }

 

6、启动类添加注解开启一些启动器

五、 用户登陆

登录密码的加密

用户登录的时候，登录信息由前端传递到后端是通过http协议进行传输的，由于http协议是明文传输的。所有的登录信息都在其body里面，所以将用户的登录密码进行明文传输安全性较低。所以在传输之前，我们在前端需要对password进行加密，通过MD5进行对称加密。

整个加密过程分为两次MD5加密：
（1）客户端：PASS = MD5（明文）
（2）服务端：PASS = MD5（用户输入+随机salt）

MD5加密的原理：MD5 (Message -digest algorithm 5)就是信息摘要的一种实现，它可以从任意长度的明文字符串生成128位的哈希值，也就是32位的16进制。

1、后端搭建

逆向生成代码生成user表的代码

 2、前端搭建（使用freemarker搭建）

 login.ftl

  1. <!DOCTYPE html>
  2. <html lang="zh">
  3. <head>
  4.     <#include "common/head.ftl"/>
  5.     <style>
  6.         .layui-panel {
  7.             position: absolute;
  8.             width: 400px;
  9.             top: 50%;
  10.             left: 50%;
  11.             transform: translate(-50%, -50%);
  12.             padding: 15px 15px 0px 15px;
  13.             border-radius: 20px;
  14.         }
  15.  
  16.         .layui-form-label {
  17.             padding: 9px 0px;
  18.         }
  19.  
  20.         h3 {
  21.             text-align: center;
  22.             line-height: 45px;
  23.             font-size: 40px;
  24.             color: white;
  25.             padding-bottom: 15px;
  26.         }
  27.     </style>
  28. </head>
  29. <body>
  30. <div>
  31.     <div class="layui-panel layui-bg-cyan">
  32.         <h3>用户登录</h3>
  33.         <div class="layui-form-item">
  34.             <label class="layui-form-label">用户账号</label>
  35.             <div class="layui-input-block">
  36.                 <input type="text" id="mobile" autocomplete="on" class="layui-input" value="18684671234">
  37.             </div>
  38.         </div>
  39.         <div class="layui-form-item">
  40.             <label class="layui-form-label">用户密码</label>
  41.             <div class="layui-input-block">
  42.                 <input type="password" id="password" autocomplete="on" class="layui-input" value="123456">
  43.             </div>
  44.         </div>
  45.         <div class="layui-form-item" style="text-align:center;">
  46.             <button class="layui-btn" id="login" style="width:46%">登录</button>
  47.             <button class="layui-btn layui-btn-normal" id="register" style="width:46%">注册</button>
  48.         </div>
  49.     </div>
  50. </div>
  51. <script src="${ctx}/static/asset/js/project/md5.js"></script>
  52. <script src="${ctx}/static/asset/js/project/login.js"></script>
  53. </body>
  54. </html>

head.ftl

  1. <meta charset="UTF-8">
  2. <title>秒杀项目</title>
  3. <script src="/static/asset/js/layui/layui.js" type="text/javascript"></script>
  4. <link href="/static/asset/js/layui/css/layui.css" rel="stylesheet" type="text/css"/>
  5. <meta http-equiv="Expires" content="0">
  6. <meta http-equiv="Pragma" content="no-cache">
  7. <meta http-equiv="Cache-control" content="no-cache">
  8. <meta http-equiv="Cache" content="no-cache">
  9. <#assign ctx>
  10.     ${springMacroRequestContext.getContextPath()}
  11. </#assign>

Layui 开发使用文档 - 入门指南

layui定义模块（login.js）

  1. layui.define(()=>{
  2.     /**
  3.      * 得到layui中封装jQuery
  4.      *
  5.      */
  6.     let $=layui.jquery
  7.     //给登陆按钮设置事件
  8.     $(login).click(()=>{
  9.        // alert("-----")
  10.         var mobile = $(mobile).val();
  11.         var password=$(password).val();
  12.     })
  13.     //将数据给后台（前后端axios。普通开发ajax）
  14.     $.ajax({
  15.         url:"",//后台登录接口
  16.         data:{
  17.             // 需要携带的数据
  18.             mobile,
  19.             password
  20.         },
  21.         datatype: "json",//后端给你的数据类型
  22.         success(e){
  23.             // 成功的回调函数
  24.  
  25.         },
  26.         error(e){
  27.             // 报错的回调函数
  28.  
  29.         }
  30.  
  31.     })
  32.  
  33.  
  34. })

专门用于跳转路径：PathController类

  1. package com.code.seckill.controller;
  2.  
  3. import org.springframework.stereotype.Controller;
  4.  
  5. import org.springframework.web.bind.annotation.PathVariable;
  6. import org.springframework.web.bind.annotation.RequestMapping;
  7.  
  8. @Controller
  9. public class PathController {
  10.     //    登录跳首页
  11.     @RequestMapping("/")
  12.     public String toPath(){
  13.         return "login";
  14.     }
  15.  
  16.     //    跳所有二级页面
  17.     @RequestMapping("/{dir}/{path}")
  18.     public String toPath(@PathVariable("dir") String dir,@PathVariable("path") String path){
  19.         return dir+"/"+path;
  20.     }
  21.  
  22.  
  23.  
  24. }

解决端口占用找不到页面 

在yml文件中加入 

 访问端口8081

 六、MD5加密

MD5加密
* 用户端：password=MD5(明文+固定Salt)
* 服务端：password=MD5(用户输入+随机Salt)
* 用户端MD5加密是为了防止用户密码在网络中明文传输，服务端MD5加密是为了提高密码安全性，双重保险。

1、导入相关的工具包

加入工具类：MD5Utils.java

  1. package com.code.seckill.util;
  2.  
  3. import org.apache.commons.codec.digest.DigestUtils;
  4. import org.springframework.stereotype.Component;
  5.  
  6. import java.util.UUID;
  7.  
  8. /**
  9.  * MD5加密
  10.  * 用户端：password=MD5(明文+固定Salt)
  11.  * 服务端：password=MD5(用户输入+随机Salt)
  12.  * 用户端MD5加密是为了防止用户密码在网络中明文传输，服务端MD5加密是为了提高密码安全性，双重保险。
  13.  */
  14. @Component
  15. @SuppressWarnings("all")
  16. public class MD5Utils {
  17.  
  18.     //加密盐，与前端一致
  19.     private static String salt = "f1g2h3j4";
  20.  
  21.     /**
  22.      * md5加密
  23.      *
  24.      * @param src
  25.      * @return
  26.      */
  27.     public static String md5(String src) {
  28.         return DigestUtils.md5Hex(src);
  29.     }
  30.  
  31.     /**
  32.      * 获取加密的盐
  33.      *
  34.      * @return
  35.      */
  36.     public static String createSalt() {
  37.         return UUID.randomUUID().toString().replace("-", "");
  38.     }
  39.  
  40.     /**
  41.      * 将前端的明文密码通过MD5加密方式加密成后端服务所需密码
  42.      * 注意：该步骤实际是在前端完成！！！
  43.      *
  44.      * @param inputPass 明文密码
  45.      * @return
  46.      */
  47.     public static String inputPassToFormpass(String inputPass) {
  48.         //混淆固定盐salt,安全性更可靠
  49.         String str = salt.charAt(1) + "" + salt.charAt(5) + inputPass + salt.charAt(0) + "" + salt.charAt(3);
  50.         return md5(str);
  51.     }
  52.  
  53.     /**
  54.      * 将后端密文密码+随机salt生成数据库的密码
  55.      *
  56.      * @param formPass
  57.      * @param salt
  58.      * @return
  59.      */
  60.     public static String formPassToDbPass(String formPass, String salt) {
  61.         //混淆固定盐salt,安全性更可靠
  62.         String str = salt.charAt(7) + "" + salt.charAt(9) + formPass + salt.charAt(1) + "" + salt.charAt(5);
  63.         return md5(str);
  64.     }
  65.  
  66.     /**
  67.      * 将用户输入的密码转换成数据库的密码
  68.      *
  69.      * @param inputPass 明文密码
  70.      * @param salt      盐
  71.      * @return
  72.      */
  73.     public static String inputPassToDbPass(String inputPass, String salt) {
  74.         String formPass = inputPassToFormpass(inputPass);
  75.         String dbPass = formPassToDbPass(formPass, salt);
  76.         return dbPass;
  77.     }
  78.  
  79.     public static void main(String[] args) {
  80.         String formPass = inputPassToFormpass("123456");
  81.         System.out.println("前端加密密码：" + formPass);
  82.         String salt = createSalt();
  83.         System.out.println("后端加密随机盐：" + salt);
  84.         String dbPass = formPassToDbPass(formPass, salt);
  85.         System.out.println("后端加密密码：" + dbPass);
  86.         String dbPass1 = inputPassToDbPass("123456", salt);
  87.         System.out.println("最终加密密码：" + dbPass1);
  88.     }
  89. }

2、新建vo类：userVo

用于前后端传值：

  1. package com.code.seckill.vo;
  2.  
  3. import lombok.Data;
  4.  
  5. @Data
  6. public class UserVo {
  7.     //手机号
  8.     private String mobile;
  9.     //密码
  10.         private String password;
  11. }

3、后端方法

IUserService

  1. package com.code.seckill.service;
  2.  
  3. import com.baomidou.mybatisplus.extension.service.IService;
  4. import com.code.seckill.pojo.User;
  5. import com.code.seckill.util.response.ResponseResult;
  6. import com.code.seckill.vo.UserVo;
  7.  
  8. /**
  9.  * <p>
  10.  * 用户信息表 服务类
  11.  * </p>
  12.  *
  13.  * @author xhy-gitHub
  14.  * @since 2022-03-15
  15.  */
  16. public interface IUserService extends IService<User> {
  17.  
  18.     ResponseResult<?> findByAccount(UserVo userVo);
  19. }

UserServiceImpl

  1. package com.code.seckill.service.impl;
  2.  
  3. import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
  4. import com.baomidou.mybatisplus.core.toolkit.StringUtils;
  5. import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
  6. import com.code.seckill.mapper.UserMapper;
  7. import com.code.seckill.pojo.User;
  8. import com.code.seckill.service.IUserService;
  9. import com.code.seckill.util.MD5Utils;
  10. import com.code.seckill.util.ValidatorUtils;
  11. import com.code.seckill.util.response.ResponseResult;
  12. import com.code.seckill.util.response.ResponseResultCode;
  13. import com.code.seckill.vo.UserVo;
  14. import org.springframework.stereotype.Service;
  15.  
  16. /**
  17.  * <p>
  18.  * 用户信息表 服务实现类
  19.  * </p>
  20.  *
  21.  * @author xhy-gitHub
  22.  * @since 2022-03-15
  23.  */
  24. @Service
  25. public class UserServiceImpl extends ServiceImpl<UserMapper, User> implements IUserService {
  26.  
  27.  
  28.     @Override
  29.     public ResponseResult<?> findByAccount(UserVo userVo) {
  30. //先判断信息是否符合（账号是否是手机号，密码是不是空的）
  31.         if (!ValidatorUtils.isMobile(userVo.getMobile())) {
  32.             return ResponseResult.failure(ResponseResultCode.USER_ACCOUNT_NOT_MOBLIE);
  33.         }
  34.         if (!StringUtils.isBlank(userVo.getPassword())) {
  35.             return ResponseResult.failure(ResponseResultCode.USER_PASSWORD_NOT_MATCH);
  36.         }
  37. //         再去数据库查出对应的用户（mobile）
  38.         User user = this.getOne(new QueryWrapper<User>().eq("id", userVo.getMobile()));
  39.         if (user == null) {
  40.             return ResponseResult.failure(ResponseResultCode.USER_ACCOUNT_NOT_FIND);
  41.         }
  42. //        比较密码
  43.         //        二重加密（前端->后端，后端->数据库）
  44.         String salt=user.getSalt();
  45. //        将前台的加密密码和后端的盐再次进行加密
  46.         String newPassword= MD5Utils.formPassToDbPass(userVo.getPassword(),salt);
  47.         if(!newPassword.equals(user.getPassword())){
  48.             return ResponseResult.failure(ResponseResultCode.USER_PASSWORD_NOT_MATCH);
  49.         }
  50.  
  51.         return ResponseResult.success();
  52.  
  53.     }
  54. }

UserController

  1. package com.code.seckill.controller;
  2.  
  3. import com.code.seckill.service.IUserService;
  4. import com.code.seckill.util.response.ResponseResult;
  5. import com.code.seckill.vo.UserVo;
  6. import org.springframework.beans.factory.annotation.Autowired;
  7. import org.springframework.web.bind.annotation.RequestMapping;
  8. import org.springframework.web.bind.annotation.RestController;
  9.  
  10. /**
  11.  * <p>
  12.  * 用户信息表 前端控制器
  13.  * </p>
  14.  *
  15.  * @author xhy-gitHub
  16.  * @since 2022-03-15
  17.  */
  18. @RestController
  19. @RequestMapping("/user")
  20. public class UserController {
  21.     @Autowired
  22.  
  23.     private IUserService userService;
  24.  
  25.     //    用户登录
  26.     @RequestMapping("/login")
  27.     public ResponseResult<?> login(UserVo userVo){
  28. //     调用service的登录验证
  29.         return userService.findByAccount(userVo);
  30.     }
  31.  
  32. }

4、前端代码

将md5.js放到js文件中的project文件下

  1. /*
  2.  * JavaScript MD5
  3.  * https://github.com/blueimp/JavaScript-MD5
  4.  *
  5.  * Copyright 2011, Sebastian Tschan
  6.  * https://blueimp.net
  7.  *
  8.  * Licensed under the MIT license:
  9.  * https://opensource.org/licenses/MIT
  10.  *
  11.  * Based on
  12.  * A JavaScript implementation of the RSA Data Security, Inc. MD5 Message
  13.  * Digest Algorithm, as defined in RFC 1321.
  14.  * Version 2.2 Copyright (C) Paul Johnston 1999 - 2009
  15.  * Other contributors: Greg Holt, Andrew Kepert, Ydnar, Lostinet
  16.  * Distributed under the BSD License
  17.  * See http://pajhome.org.uk/crypt/md5 for more info.
  18.  */
  20. /* global define */
  21.  
  22. (function ($) {
  23.     'use strict'
  24.  
  25.     /*
  26.     * Add integers, wrapping at 2^32. This uses 16-bit operations internally
  27.     * to work around bugs in some JS interpreters.
  28.     */
  29.     function safeAdd (x, y) {
  30.         var lsw = (x & 0xffff) + (y & 0xffff)
  31.         var msw = (x >> 16) + (y >> 16) + (lsw >> 16)
  32.         return (msw << 16) | (lsw & 0xffff)
  33.     }
  34.  
  35.     /*
  36.     * Bitwise rotate a 32-bit number to the left.
  37.     */
  38.     function bitRotateLeft (num, cnt) {
  39.         return (num << cnt) | (num >>> (32 - cnt))
  40.     }
  41.  
  42.     /*
  43.     * These functions implement the four basic operations the algorithm uses.
  44.     */
  45.     function md5cmn (q, a, b, x, s, t) {
  46.         return safeAdd(bitRotateLeft(safeAdd(safeAdd(a, q), safeAdd(x, t)), s), b)
  47.     }
  48.     function md5ff (a, b, c, d, x, s, t) {
  49.         return md5cmn((b & c) | (~b & d), a, b, x, s, t)
  50.     }
  51.     function md5gg (a, b, c, d, x, s, t) {
  52.         return md5cmn((b & d) | (c & ~d), a, b, x, s, t)
  53.     }
  54.     function md5hh (a, b, c, d, x, s, t) {
  55.         return md5cmn(b ^ c ^ d, a, b, x, s, t)
  56.     }
  57.     function md5ii (a, b, c, d, x, s, t) {
  58.         return md5cmn(c ^ (b | ~d), a, b, x, s, t)
  59.     }
  60.  
  61.     /*
  62.     * Calculate the MD5 of an array of little-endian words, and a bit length.
  63.     */
  64.     function binlMD5 (x, len) {
  65.         /* append padding */
  66.         x[len >> 5] |= 0x80 << (len % 32)
  67.         x[((len + 64) >>> 9 << 4) + 14] = len
  69.         var i
  70.         var olda
  71.         var oldb
  72.         var oldc
  73.         var oldd
  74.         var a = 1732584193
  75.         var b = -271733879
  76.         var c = -1732584194
  77.         var d = 271733878
  78.  
  79.         for (i = 0; i < x.length; i += 16) {
  80.             olda = a
  81.             oldb = b
  82.             oldc = c
  83.             oldd = d
  84.  
  85.             a = md5ff(a, b, c, d, x[i], 7, -680876936)
  86.             d = md5ff(d, a, b, c, x[i + 1], 12, -389564586)
  87.             c = md5ff(c, d, a, b, x[i + 2], 17, 606105819)
  88.             b = md5ff(b, c, d, a, x[i + 3], 22, -1044525330)
  89.             a = md5ff(a, b, c, d, x[i + 4], 7, -176418897)
  90.             d = md5ff(d, a, b, c, x[i + 5], 12, 1200080426)
  91.             c = md5ff(c, d, a, b, x[i + 6], 17, -1473231341)
  92.             b = md5ff(b, c, d, a, x[i + 7], 22, -45705983)
  93.             a = md5ff(a, b, c, d, x[i + 8], 7, 1770035416)
  94.             d = md5ff(d, a, b, c, x[i + 9], 12, -1958414417)
  95.             c = md5ff(c, d, a, b, x[i + 10], 17, -42063)
  96.             b = md5ff(b, c, d, a, x[i + 11], 22, -1990404162)
  97.             a = md5ff(a, b, c, d, x[i + 12], 7, 1804603682)
  98.             d = md5ff(d, a, b, c, x[i + 13], 12, -40341101)
  99.             c = md5ff(c, d, a, b, x[i + 14], 17, -1502002290)
  100.             b = md5ff(b, c, d, a, x[i + 15], 22, 1236535329)
  101.  
  102.             a = md5gg(a, b, c, d, x[i + 1], 5, -165796510)
  103.             d = md5gg(d, a, b, c, x[i + 6], 9, -1069501632)
  104.             c = md5gg(c, d, a, b, x[i + 11], 14, 643717713)
  105.             b = md5gg(b, c, d, a, x[i], 20, -373897302)
  106.             a = md5gg(a, b, c, d, x[i + 5], 5, -701558691)
  107.             d = md5gg(d, a, b, c, x[i + 10], 9, 38016083)
  108.             c = md5gg(c, d, a, b, x[i + 15], 14, -660478335)
  109.             b = md5gg(b, c, d, a, x[i + 4], 20, -405537848)
  110.             a = md5gg(a, b, c, d, x[i + 9], 5, 568446438)
  111.             d = md5gg(d, a, b, c, x[i + 14], 9, -1019803690)
  112.             c = md5gg(c, d, a, b, x[i + 3], 14, -187363961)
  113.             b = md5gg(b, c, d, a, x[i + 8], 20, 1163531501)
  114.             a = md5gg(a, b, c, d, x[i + 13], 5, -1444681467)
  115.             d = md5gg(d, a, b, c, x[i + 2], 9, -51403784)
  116.             c = md5gg(c, d, a, b, x[i + 7], 14, 1735328473)
  117.             b = md5gg(b, c, d, a, x[i + 12], 20, -1926607734)
  118.  
  119.             a = md5hh(a, b, c, d, x[i + 5], 4, -378558)
  120.             d = md5hh(d, a, b, c, x[i + 8], 11, -2022574463)
  121.             c = md5hh(c, d, a, b, x[i + 11], 16, 1839030562)
  122.             b = md5hh(b, c, d, a, x[i + 14], 23, -35309556)
  123.             a = md5hh(a, b, c, d, x[i + 1], 4, -1530992060)
  124.             d = md5hh(d, a, b, c, x[i + 4], 11, 1272893353)
  125.             c = md5hh(c, d, a, b, x[i + 7], 16, -155497632)
  126.             b = md5hh(b, c, d, a, x[i + 10], 23, -1094730640)
  127.             a = md5hh(a, b, c, d, x[i + 13], 4, 681279174)
  128.             d = md5hh(d, a, b, c, x[i], 11, -358537222)
  129.             c = md5hh(c, d, a, b, x[i + 3], 16, -722521979)
  130.             b = md5hh(b, c, d, a, x[i + 6], 23, 76029189)
  131.             a = md5hh(a, b, c, d, x[i + 9], 4, -640364487)
  132.             d = md5hh(d, a, b, c, x[i + 12], 11, -421815835)
  133.             c = md5hh(c, d, a, b, x[i + 15], 16, 530742520)
  134.             b = md5hh(b, c, d, a, x[i + 2], 23, -995338651)
  135.  
  136.             a = md5ii(a, b, c, d, x[i], 6, -198630844)
  137.             d = md5ii(d, a, b, c, x[i + 7], 10, 1126891415)
  138.             c = md5ii(c, d, a, b, x[i + 14], 15, -1416354905)
  139.             b = md5ii(b, c, d, a, x[i + 5], 21, -57434055)
  140.             a = md5ii(a, b, c, d, x[i + 12], 6, 1700485571)
  141.             d = md5ii(d, a, b, c, x[i + 3], 10, -1894986606)
  142.             c = md5ii(c, d, a, b, x[i + 10], 15, -1051523)
  143.             b = md5ii(b, c, d, a, x[i + 1], 21, -2054922799)
  144.             a = md5ii(a, b, c, d, x[i + 8], 6, 1873313359)
  145.             d = md5ii(d, a, b, c, x[i + 15], 10, -30611744)
  146.             c = md5ii(c, d, a, b, x[i + 6], 15, -1560198380)
  147.             b = md5ii(b, c, d, a, x[i + 13], 21, 1309151649)
  148.             a = md5ii(a, b, c, d, x[i + 4], 6, -145523070)
  149.             d = md5ii(d, a, b, c, x[i + 11], 10, -1120210379)
  150.             c = md5ii(c, d, a, b, x[i + 2], 15, 718787259)
  151.             b = md5ii(b, c, d, a, x[i + 9], 21, -343485551)
  152.  
  153.             a = safeAdd(a, olda)
  154.             b = safeAdd(b, oldb)
  155.             c = safeAdd(c, oldc)
  156.             d = safeAdd(d, oldd)
  157.         }
  158.         return [a, b, c, d]
  159.     }
  160.  
  161.     /*
  162.     * Convert an array of little-endian words to a string
  163.     */
  164.     function binl2rstr (input) {
  165.         var i
  166.         var output = ''
  167.         var length32 = input.length * 32
  168.         for (i = 0; i < length32; i += 8) {
  169.             output += String.fromCharCode((input[i >> 5] >>> (i % 32)) & 0xff)
  170.         }
  171.         return output
  172.     }
  173.  
  174.     /*
  175.     * Convert a raw string to an array of little-endian words
  176.     * Characters >255 have their high-byte silently ignored.
  177.     */
  178.     function rstr2binl (input) {
  179.         var i
  180.         var output = []
  181.         output[(input.length >> 2) - 1] = undefined
  182.         for (i = 0; i < output.length; i += 1) {
  183.             output[i] = 0
  184.         }
  185.         var length8 = input.length * 8
  186.         for (i = 0; i < length8; i += 8) {
  187.             output[i >> 5] |= (input.charCodeAt(i / 8) & 0xff) << (i % 32)
  188.         }
  189.         return output
  190.     }
  191.  
  192.     /*
  193.     * Calculate the MD5 of a raw string
  194.     */
  195.     function rstrMD5 (s) {
  196.         return binl2rstr(binlMD5(rstr2binl(s), s.length * 8))
  197.     }
  198.  
  199.     /*
  200.     * Calculate the HMAC-MD5, of a key and some data (raw strings)
  201.     */
  202.     function rstrHMACMD5 (key, data) {
  203.         var i
  204.         var bkey = rstr2binl(key)
  205.         var ipad = []
  206.         var opad = []
  207.         var hash
  208.         ipad[15] = opad[15] = undefined
  209.         if (bkey.length > 16) {
  210.             bkey = binlMD5(bkey, key.length * 8)
  211.         }
  212.         for (i = 0; i < 16; i += 1) {
  213.             ipad[i] = bkey[i] ^ 0x36363636
  214.             opad[i] = bkey[i] ^ 0x5c5c5c5c
  215.         }
  216.         hash = binlMD5(ipad.concat(rstr2binl(data)), 512 + data.length * 8)
  217.         return binl2rstr(binlMD5(opad.concat(hash), 512 + 128))
  218.     }
  219.  
  220.     /*
  221.     * Convert a raw string to a hex string
  222.     */
  223.     function rstr2hex (input) {
  224.         var hexTab = '0123456789abcdef'
  225.         var output = ''
  226.         var x
  227.         var i
  228.         for (i = 0; i < input.length; i += 1) {
  229.             x = input.charCodeAt(i)
  230.             output += hexTab.charAt((x >>> 4) & 0x0f) + hexTab.charAt(x & 0x0f)
  231.         }
  232.         return output
  233.     }
  234.  
  235.     /*
  236.     * Encode a string as utf-8
  237.     */
  238.     function str2rstrUTF8 (input) {
  239.         return unescape(encodeURIComponent(input))
  240.     }
  241.  
  242.     /*
  243.     * Take string arguments and return either raw or hex encoded strings
  244.     */
  245.     function rawMD5 (s) {
  246.         return rstrMD5(str2rstrUTF8(s))
  247.     }
  248.     function hexMD5 (s) {
  249.         return rstr2hex(rawMD5(s))
  250.     }
  251.     function rawHMACMD5 (k, d) {
  252.         return rstrHMACMD5(str2rstrUTF8(k), str2rstrUTF8(d))
  253.     }
  254.     function hexHMACMD5 (k, d) {
  255.         return rstr2hex(rawHMACMD5(k, d))
  256.     }
  257.  
  258.     function md5 (string, key, raw) {
  259.         if (!key) {
  260.             if (!raw) {
  261.                 return hexMD5(string)
  262.             }
  263.             return rawMD5(string)
  264.         }
  265.         if (!raw) {
  266.             return hexHMACMD5(key, string)
  267.         }
  268.         return rawHMACMD5(key, string)
  269.     }
  270.  
  271.     if (typeof define === 'function' && define.amd) {
  272.         define(function () {
  273.             return md5
  274.         })
  275.     } else if (typeof module === 'object' && module.exports) {
  276.         module.exports = md5
  277.     } else {
  278.         $.md5 = md5
  279.     }
  280. })(this)

前端密码进行加密

login.js(上面基础上)

  1. layui.define(()=>{
  2.     // 得到layui中封装的jquery
  3.     let $=layui.jquery
  4.     let layer=layui.layer
  5.     // 给登录按钮设置事件
  6.     $(login).click(()=>{
  7.         // 取到表单的值
  8.         let mobile = $("#mobile").val();
  9.         let password=$("#password").val();
  10.         // 前端加密的盐
  11.         let salt= "f1g2h3j4";
  12.         if(password){
  13.             // 将密码和盐混在一起
  14.             password=salt.charAt(1) + "" + salt.charAt(5) + password + salt.charAt(0) + "" + salt.charAt(3);
  15.             // 进行MD5加密
  16.             password=md5(password)
  17.         }
  18.         console.log(password)
  19.         // 将数据给后台（前后端分离axios,普通开发ajax）
  20.         $.ajax({
  21.             url:"/user/login",//后台登录接口
  22.             data:{
  23.                 // 需要携带的数据
  24.                 mobile,
  25.                 password
  26.             },
  27.             datatype: "json",//后端给你的数据类型
  28.             success(e){
  29.                 // 成功的回调函数
  30.                 layer.msg(e.message,{icon: 6});
  31.             },
  32.             error(e){
  33.                 // 报错的回调函数
  34.  
  35.             }
  36.  
  37.         })
  38.     })
  39.  
  40.  
  41. })

 

 七、全局异常抓获

1、创建validate文件下自定义注解

IsMobile
  1. package com.code.seckill.util.validate;
  2.  
  3. import com.code.seckill.util.response.ResponseResultCode;
  4.  
  5. import javax.validation.Constraint;
  6. import javax.validation.Payload;
  7. import java.lang.annotation.*;
  8.  
  9. @SuppressWarnings("all")
  10. @Documented
  11. @Constraint(
  12.         validatedBy = {IsMobileValidator.class}
  13. )
  14. @Target({ElementType.FIELD, ElementType.PARAMETER})
  15. @Retention(RetentionPolicy.RUNTIME)
  16. public @interface IsMobile {
  17.  
  18.     ResponseResultCode code() default ResponseResultCode.UNKNOWN;
  19.  
  20.     String message() default "";
  21.  
  22.     Class<?>[] groups() default {};
  23.  
  24.     Class<? extends Payload>[] payload() default {};
  25.  
  26. }
IsRequired
  1. package com.code.seckill.util.validate;
  2.  
  3. import com.code.seckill.util.response.ResponseResultCode;
  4.  
  5. import javax.validation.Constraint;
  6. import javax.validation.Payload;
  7. import java.lang.annotation.*;
  8.  
  9. @SuppressWarnings("all")
  10. @Documented
  11. @Constraint(
  12.         validatedBy = {IsRequiredValidator.class}
  13. )
  14. @Target({ElementType.FIELD, ElementType.PARAMETER})
  15. @Retention(RetentionPolicy.RUNTIME)
  16. public @interface IsRequired {
  17.  
  18.     ResponseResultCode code() default ResponseResultCode.UNKNOWN;
  19.  
  20.     String message() default "";
  21.  
  22.     Class<?>[] groups() default {};
  23.  
  24.     Class<? extends Payload>[] payload() default {};
  25.  
  26. }

加入各自的解析器

IsMobileValidator
  1. package com.code.seckill.util.validate;
  2.  
  3. import com.code.seckill.util.ValidatorUtils;
  4.  
  5. import javax.validation.ConstraintValidator;
  6. import javax.validation.ConstraintValidatorContext;
  7.  
  8. @SuppressWarnings("all")
  9. public class IsMobileValidator implements ConstraintValidator<IsMobile, String> {
  10.  
  11.     @Override
  12.     public boolean isValid(String mobile, ConstraintValidatorContext context) {
  13.         return ValidatorUtils.isMobile(mobile);
  14.     }
  15.  
  16. }
IsRequiredValidator
  1. package com.code.seckill.util.validate;
  2.  
  3. import lombok.extern.slf4j.Slf4j;
  4. import org.apache.commons.lang3.StringUtils;
  5.  
  6. import javax.validation.ConstraintValidator;
  7. import javax.validation.ConstraintValidatorContext;
  8.  
  9. @SuppressWarnings("all")
  10. @Slf4j
  11. public class IsRequiredValidator implements ConstraintValidator<IsRequired, String> {
  12.  
  13.     @Override
  14.     public boolean isValid(String str, ConstraintValidatorContext context) {
  15.         return StringUtils.isNotBlank(str);
  16.     }
  17.  
  18. }

2、给Vo类加上注解（解析器）

  1. package com.code.seckill.vo;
  2.  
  3. import com.code.seckill.util.response.ResponseResultCode;
  4. import com.code.seckill.util.validate.IsMobile;
  5. import com.code.seckill.util.validate.IsRequired;
  6. import lombok.Data;
  7.  
  8. @Data
  9. public class UserVo {
  10.     //手机号
  11.     @IsMobile(code = ResponseResultCode.USER_ACCOUNT_NOT_FIND)
  12.     private String mobile;
  13.     //密码
  14.     @IsRequired(code = ResponseResultCode.USER_CREDENTIAL_NOT_BE_EMPTY)
  15.     private String password;
  16. }

3、创建response文件下的ThrowableAdvice(获取异常类)

  1. package com.code.seckill.util.response;
  2.  
  3. import com.code.seckill.exception.BusinessException;
  4. import lombok.extern.slf4j.Slf4j;
  5. import org.springframework.ui.Model;
  6. import org.springframework.validation.BindException;
  7. import org.springframework.web.bind.annotation.ExceptionHandler;
  8. import org.springframework.web.bind.annotation.RestControllerAdvice;
  9.  
  10. @SuppressWarnings("all")
  11. @RestControllerAdvice
  12. @Slf4j
  13. public class ThrowableAdvice {
  14.  
  15.     @JsonResponseResult
  16.     @ExceptionHandler(value = {BusinessException.class})
  17.     public ResponseResultCode globalBusinessException(Model m, Exception e) {
  18.         log.error(e.toString());
  19.         return ((BusinessException) e).getResponseResultCode();
  20.     }
  21.  
  22.     @JsonResponseResult
  23.     @ExceptionHandler(value = {BindException.class})
  24.     public ResponseResultCode globalBindException(Model m, Exception e) {
  25.         log.error(e.toString());
  26.         BindException error = (BindException) e;
  27.         return (ResponseResultCode) error.getFieldError().getArguments()[1];
  28.     }
  29.  
  30.     @JsonResponseResult
  31.     @ExceptionHandler(value = {Throwable.class})
  32.     public ResponseResultCode globalException(Model m, Exception e) {
  33.         log.error(e.toString());
  34.         return ResponseResultCode.UNKNOWN;
  35.     }
  36.  
  37. }
  38.

4、在UserController类方法中加入注解开启jsr303验证

@Valid

5、在实现类抛出异常

  1. package com.code.seckill.service.impl;
  2.  
  3. import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
  4. import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
  5. import com.baomidou.mybatisplus.core.toolkit.StringUtils;
  6. import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
  7. import com.code.seckill.exception.BusinessException;
  8. import com.code.seckill.mapper.UserMapper;
  9. import com.code.seckill.pojo.User;
  10. import com.code.seckill.service.IUserService;
  11. import com.code.seckill.util.MD5Utils;
  12. import com.code.seckill.util.ValidatorUtils;
  13. import com.code.seckill.util.response.ResponseResult;
  14. import com.code.seckill.util.response.ResponseResultCode;
  15. import com.code.seckill.vo.UserVo;
  16. import org.springframework.stereotype.Service;
  17.  
  18. import java.util.Date;
  19.  
  20. /**
  21.  * <p>
  22.  * 用户信息表 服务实现类
  23.  * </p>
  24.  *
  25.  * @author xhy-gitHub
  26.  * @since 2022-03-15
  27.  */
  28. @Service
  29. public class UserServiceImpl extends ServiceImpl<UserMapper, User> implements IUserService {
  30.  
  31.     @Override
  32.     public ResponseResult<?> findByAccount(UserVo userVo) {
  33. //        先判断信息是否符合（账号是否是手机号码，密码是不是空）
  34.         if(!ValidatorUtils.isMobile(userVo.getMobile())){
  35.             throw new BusinessException(ResponseResultCode.USER_ACCOUNT_NOT_MOBLIE);
  36.         }
  37.         if(StringUtils.isBlank(userVo.getPassword())){
  38.             throw new BusinessException(ResponseResultCode.USER_PASSWORD_NOT_MATCH);
  39.         }
  40. //         再去数据库查出对应的用户（mobile）
  41.         User user=this.getOne(new QueryWrapper<User>().eq("id",userVo.getMobile()));
  42.         if(user==null){
  43.             throw new BusinessException(ResponseResultCode.USER_ACCOUNT_NOT_FIND);
  44.         }
  45. //        比较密码
  46. //        二重加密（前端->后端，后端->数据库）
  47.         String salt=user.getSalt();
  48. //        将前台的加密密码和后端的盐再次进行加密
  49.         String newPassword=MD5Utils.formPassToDbPass(userVo.getPassword(),salt);
  50.         if(!newPassword.equals(user.getPassword())){
  51.             throw new BusinessException(ResponseResultCode.USER_PASSWORD_NOT_MATCH);
  52.         }
  53. //        修改最后的登录时间
  54.         this.update(new UpdateWrapper<User>().eq("id",userVo.getMobile()).set("last_login_date",new Date()).setSql("login_count=login_count+1"));
  55.         return ResponseResult.success();
  56.     }
  57. }

密码错误时不会报错

登陆模块完成！

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/喵喵爱编程/article/detail/807335?site
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号