• springboot项目：前后端搭建

    目录

    一、springboot项目简介

    二、构建springboot项目

    创建SpringBoot项目并配置POM

    pom.xml

    application.yml

    启动类的配置

    SpbootproApplication 

    测试一下是否能访问前端

    IndexController 

    ​三、首页功能

     导入mybatisplus的代码生成器

    首页方法改造

     IndexController 

    页面数据展示

    index.html

    将页面的展示格式改变

    index.html

    四、用户明文登录 

    PageController

    UserDto 

    IUserService 

     UserServiceImpl 

    五、前端及数据库密码加密

    login.js

     UserServiceImpl 

    login.html

    六、服务端客户端登录密码管理

    UserServiceImpl 

    IRedisService

     IRedisServiceImpl 

     用的工具类

    CookieUtils 

     DataUtils 

     JsonResponseBody

     JsonResponseStatus

     MD5Utils 

     MybatisPlusConfig 

     PageBean 

     ValidatorUtils 

    一、springboot项目简介

    项目前期准备

    使用技术

    前端：Freemarker、jQuery
    后端：SpringBoot、MyBatisPlus、Lombok
    中间件：Redis

    数据表介绍

    用户表：t_user

    商品表：t_goods

    订单表：t_order

    订单项表：t_order_item

    数据源表：t_dict_type

    数据项表：t_dict_dat

     后期开发项目肯定是还要修改的 现在浅看一下

    二、构建springboot项目

    创建SpringBoot项目并配置POM

    构建项目时并没有选择任何组件（避免于所准备的依赖因为版本的问题导致出现问题）

    spring-boot-starter-freemarker
    spring-boot-starter-web
    mysql-connector-java 5.1.44
    lombok

    mybatis-plus-boot-starter 3.4.0
    mybatis-plus-generator 3.4.0

    HikariCP

    commons-codec
    commons-lang3 3.6

    spring-boot-starter-validation

    spring-boot-starter-data-redis

    参考

    pom.xml

    1. "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.0modelVersion>
    5.     <parent>
    6.         <groupId>org.springframework.bootgroupId>
    7.         <artifactId>spring-boot-starter-parentartifactId>
    8.         <version>2.3.9.RELEASEversion>
    9.         <relativePath/> 
    10.     parent>
    11.     <groupId>com.cdlgroupId>
    12.     <artifactId>spbootproartifactId>
    13.     <version>0.0.1-SNAPSHOTversion>
    14.     <name>spbootproname>
    15.     <description>Demo project for Spring Bootdescription>
    16.  
    17.     <properties>
    18.         <java.version>1.8java.version>
    19.     properties>
    20.     <dependencies>
    21.         
    22.         <dependency>
    23.             <groupId>org.springframework.bootgroupId>
    24.             <artifactId>spring-boot-starter-freemarkerartifactId>
    25.         dependency>
    26.  
    27.         
    28.         <dependency>
    29.             <groupId>org.springframework.bootgroupId>
    30.             <artifactId>spring-boot-starter-webartifactId>
    31.         dependency>
    32.  
    33.         
    34.         <dependency>
    35.             <groupId>mysqlgroupId>
    36.             <artifactId>mysql-connector-javaartifactId>
    37.             <scope>runtimescope>
    38.             <version>5.1.44version>
    39.         dependency>
    40.  
    41.         
    42.         <dependency>
    43.             <groupId>org.projectlombokgroupId>
    44.             <artifactId>lombokartifactId>
    45.             <optional>trueoptional>
    46.         dependency>
    47.  
    48.         
    49.         <dependency>
    50.             <groupId>org.springframework.bootgroupId>
    51.             <artifactId>spring-boot-starter-testartifactId>
    52.             <scope>testscope>
    53.             <exclusions>
    54.                 <exclusion>
    55.                     <groupId>org.junit.vintagegroupId>
    56.                     <artifactId>junit-vintage-engineartifactId>
    57.                 exclusion>
    58.             exclusions>
    59.         dependency>
    60.  
    61.         <dependency>
    62.             <groupId>junitgroupId>
    63.             <artifactId>junitartifactId>
    64.             <scope>testscope>
    65.         dependency>
    66.  
    67.         
    68.         <dependency>
    69.             <groupId>com.baomidougroupId>
    70.             <artifactId>mybatis-plus-boot-starterartifactId>
    71.             <version>3.4.0version>
    72.         dependency>
    73.         
    74.         <dependency>
    75.             <groupId>com.baomidougroupId>
    76.             <artifactId>mybatis-plus-generatorartifactId>
    77.             <version>3.4.0version>
    78.         dependency>
    79.  
    80.         
    81.         <dependency>
    82.             <groupId>com.zaxxergroupId>
    83.             <artifactId>HikariCPartifactId>
    84.         dependency>
    85.  
    86.         
    87.         <dependency>
    88.             <groupId>commons-codecgroupId>
    89.             <artifactId>commons-codecartifactId>
    90.         dependency>
    91.  
    92.         <dependency>
    93.             <groupId>org.apache.commonsgroupId>
    94.             <artifactId>commons-lang3artifactId>
    95.             <version>3.6version>
    96.         dependency>
    97.  
    98.         
    99.         <dependency>
    100.             <groupId>org.springframework.bootgroupId>
    101.             <artifactId>spring-boot-starter-validationartifactId>
    102.         dependency>
    103.  
    104.         
    105.         <dependency>
    106.             <groupId>org.springframework.bootgroupId>
    107.             <artifactId>spring-boot-starter-data-redisartifactId>
    108.         dependency>
    109.  
    110.         
    111.         <dependency>
    112.             <groupId>org.apache.commonsgroupId>
    113.             <artifactId>commons-pool2artifactId>
    114.         dependency>
    115.  
    116.         
    117.         
    118.         <dependency>
    119.             <groupId>com.alipay.sdkgroupId>
    120.             <artifactId>alipay-easysdkartifactId>
    121.             <version>2.0.1version>
    122.         dependency>
    123.     dependencies>
    124.  
    125.     <build>
    126.         <plugins>
    127.             <plugin>
    128.                 <groupId>org.springframework.bootgroupId>
    129.                 <artifactId>spring-boot-maven-pluginartifactId>
    130.             plugin>
    131.         plugins>
    132.     build>
    133.  
    134. project>

    application.yml参考如下

    application.yml

    1. server:
    2.     port: 8081
    3.     servlet:
    4.         context-path: /
    5. spring:
    6.     datasource:
    7.         url: jdbc:mysql://localhost:3306/spbootpro?useSSL=false&useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC&characterEncoding=UTF8
    8.         driver-class-name: com.mysql.jdbc.Driver
    9.         password: 123456
    10.         username: root
    11.         hikari:
    12.             # 最小空闲连接数量
    13.             minimum-idle: 5
    14.             # 空闲连接存活最大时间，默认600000（10分钟）
    15.             idle-timeout: 180000
    16.             # 连接池最大连接数，默认是10
    17.             maximum-pool-size: 10
    18.             # 此属性控制从池返回的连接的默认自动提交行为,默认值：true
    19.             auto-commit: true
    20.             # 连接池名称
    21.             pool-name: MyHikariCP
    22.             # 此属性控制池中连接的最长生命周期，值0表示无限生命周期，默认1800000即30分钟
    23.             max-lifetime: 1800000
    24.             # 数据库连接超时时间,默认30秒，即30000
    25.             connection-timeout: 30000
    26.     freemarker:
    27.         #设置编码格式
    28.         charset: UTF-8
    29.         #后缀
    30.         suffix:
    31.         #文档类型
    32.         content-type: text/html
    33.         #模板前端
    34.         template-loader-path: classpath:/templates/
    35.         #启用模板
    36.         enabled: true
    37.     mvc:
    38.         static-path-pattern: /static/**
    39.     redis:
    40.         #服务端IP
    41.         host: 192.168.26.128
    42.         #端口
    43.         port: 6379
    44.         #密码
    45.         password: 123456
    46.         #选择数据库
    47.         database: 0
    48.         #超时时间
    49.         timeout: 10000ms
    50.         #Lettuce的连接是基于Netty的，连接实例（StatefulRedisConnection）可以在多个线程间并发访问
    51.         #Lettuce线程安全，Jedis线程非安全
    52.         lettuce:
    53.             pool:
    54.                 #最大连接数，默认8
    55.                 max-active: 8
    56.                 #最大连接阻塞等待时间，默认-1
    57.                 max-wait: 10000ms
    58.                 #最大空闲连接，默认8
    59.                 max-idle: 200
    60.                 #最小空闲连接，默认0
    61.                 min-idle: 5
    62. #mybatis-plus配置
    63. mybatis-plus:
    64.     #所对应的 XML 文件位置
    65.     mapper-locations: classpath*:/mapper/*Mapper.xml
    66.     #别名包扫描路径
    67.     type-aliases-package: com.cdl.spbootpro.model
    68.     configuration:
    69.         #驼峰命名规则
    70.         map-underscore-to-camel-case: true
    71. #日志配置
    72. logging:
    73.     level:
    74.         com.cdl.spbootpro.mapper: debug

    redis使用的连接的IP是虚拟机所分配的

    启动类的配置

    SpbootproApplication 

    1. package com.cdl.spbootpro;
    2.  
    3. import org.mybatis.spring.annotation.MapperScan;
    4. import org.springframework.boot.SpringApplication;
    5. import org.springframework.boot.autoconfigure.SpringBootApplication;
    6. import org.springframework.transaction.annotation.EnableTransactionManagement;
    7.  
    8. @MapperScan({"com.cdl.spbootpro.mapper"})//扫描接口
    9. @EnableTransactionManagement//开启事务
    10. @SpringBootApplication
    11. public class SpbootproApplication {
    12.  
    13.     public static void main(String[] args) {
    14.         SpringApplication.run(SpbootproApplication.class, args);
    15.     }
    16.  
    17. }

    将准备的页面资料以及图片等复制放入resources下

    测试一下是否能访问前端

    新建一个controller的包

    IndexController 

    1. package com.cdl.spbootpro.controller;
    2.  
    3. import org.springframework.stereotype.Controller;
    4. import org.springframework.web.bind.annotation.RequestMapping;
    5. import org.springframework.web.bind.annotation.RestController;
    6.  
    7. /**
    8.  * @author cdl
    9.  * @site www.cdl.com
    10.  * @create 2022-11-05 17:31
    11.  */
    12. @Controller
    13. public class IndexController {
    14.  
    15.     @RequestMapping("/")
    16.     public String index(){
    17. //        模板前端
    18. //        /templates+index.html+""
    19.         //前缀+逻辑视图名+后缀
    20.         return "index.html";
    21.     }
    22.  
    23. }

    运行启动类 浏览器输入地址 可以访问到我们准备的资源页面中

    但是此时的数据全都是静态的资源 页面中写的一样的



    三、首页功能

    目标：将数据库中的数据展示在首页的页面上

    数据库数据将这些数据展示到对应的商品上

     导入mybatisplus的代码生成器

    CodeGenerator 

    1. package com.cdl.spbootpro.generator;
    2.  
    3. import com.baomidou.mybatisplus.core.exceptions.MybatisPlusException;
    4. import com.baomidou.mybatisplus.core.toolkit.StringPool;
    5. import com.baomidou.mybatisplus.core.toolkit.StringUtils;
    6. import com.baomidou.mybatisplus.generator.AutoGenerator;
    7. import com.baomidou.mybatisplus.generator.InjectionConfig;
    8. import com.baomidou.mybatisplus.generator.config.*;
    9. import com.baomidou.mybatisplus.generator.config.po.TableInfo;
    10. import com.baomidou.mybatisplus.generator.config.rules.NamingStrategy;
    11. import com.baomidou.mybatisplus.generator.engine.FreemarkerTemplateEngine;
    12.  
    13. import java.util.ArrayList;
    14. import java.util.List;
    15. import java.util.Scanner;
    16.  
    17. public class CodeGenerator {
    18.  
    19.     /**
    20.      * 
    21.      * 读取控制台内容
    22.      * 
    23.      */
    24.     public static String scanner(String tip) {
    25.         Scanner scanner = new Scanner(System.in);
    26.         StringBuilder help = new StringBuilder();
    27.         help.append("请输入" + tip + "：");
    28.         System.out.println(help.toString());
    29.         if (scanner.hasNext()) {
    30.             String ipt = scanner.next();
    31.             if (StringUtils.isNotBlank(ipt)) {
    32.                 return ipt;
    33.             }
    34.         }
    35.         throw new MybatisPlusException("请输入正确的" + tip + "！");
    36.     }
    37.  
    38.     public static void main(String[] args) {
    39.         // 代码生成器
    40.         AutoGenerator mpg = new AutoGenerator();
    41.  
    42.         // 全局配置
    43.         GlobalConfig gc = new GlobalConfig();
    44.         String projectPath = System.getProperty("user.dir") + "/spbootpro";
    45.         gc.setOutputDir(projectPath + "/src/main/java");
    46.         gc.setAuthor("cdl");
    47.         gc.setOpen(false);
    48.         gc.setBaseColumnList(true);
    49.         gc.setBaseResultMap(true);
    50.         // gc.setSwagger2(true); 实体属性 Swagger2 注解
    51.         mpg.setGlobalConfig(gc);
    52.  
    53.         // 数据源配置
    54.         DataSourceConfig dsc = new DataSourceConfig();
    55.         dsc.setUrl("jdbc:mysql://localhost:3306/spbootpro?useUnicode=true&useSSL=false&characterEncoding=utf8");
    56.         // dsc.setSchemaName("public");
    57.         dsc.setDriverName("com.mysql.jdbc.Driver");
    58.         dsc.setUsername("root");
    59.         dsc.setPassword("123456");
    60.         mpg.setDataSource(dsc);
    61.  
    62.         // 包配置
    63.         PackageConfig pc = new PackageConfig();
    64.         //pc.setModuleName(scanner("模块名"));
    65.         pc.setParent("com.cdl.spbootpro");
    66.         //设置包名
    67.         pc.setEntity("model");
    68.         mpg.setPackageInfo(pc);
    69.  
    70.         // 自定义配置
    71.         InjectionConfig cfg = new InjectionConfig() {
    72.             @Override
    73.             public void initMap() {
    74.                 // to do nothing
    75.             }
    76.         };
    77.  
    78.         // 如果模板引擎是 freemarker
    79.         String templatePath = "/templates/mybatis-generator/mapper2.xml.ftl";
    80.         // 如果模板引擎是 velocity
    81.         // String templatePath = "/templates/mapper.xml.vm";
    82.  
    83.         // 自定义输出配置
    84.         List focList = new ArrayList<>();
    85.         // 自定义配置会被优先输出
    86.         focList.add(new FileOutConfig(templatePath) {
    87.             @Override
    88.             public String outputFile(TableInfo tableInfo) {
    89.                 // 自定义输出文件名 ， 如果你 Entity 设置了前后缀、此处注意 xml 的名称会跟着发生变化！！
    90.                 return projectPath + "/src/main/resources/mapper/" + pc.getModuleName()
    91.                         + "/" + tableInfo.getEntityName() + "Mapper" + StringPool.DOT_XML;
    92.             }
    93.         });
    94.         /*
    95.         cfg.setFileCreate(new IFileCreate() {
    96.             @Override
    97.             public boolean isCreate(ConfigBuilder configBuilder, FileType fileType, String filePath) {
    98.                 // 判断自定义文件夹是否需要创建
    99.                 checkDir("调用默认方法创建的目录，自定义目录用");
    100.                 if (fileType == FileType.MAPPER) {
    101.                     // 已经生成 mapper 文件判断存在，不想重新生成返回 false
    102.                     return !new File(filePath).exists();
    103.                 }
    104.                 // 允许生成模板文件
    105.                 return true;
    106.             }
    107.         });
    108.         */
    109.         cfg.setFileOutConfigList(focList);
    110.         mpg.setCfg(cfg);
    111.  
    112.         // 配置模板
    113.         TemplateConfig templateConfig = new TemplateConfig();
    114.  
    115.         // 配置自定义输出模板
    116.         //指定自定义模板路径，注意不要带上.ftl/.vm, 会根据使用的模板引擎自动识别
    117.         templateConfig.setMapper("templates/mybatis-generator/mapper2.java");
    118.         templateConfig.setEntity("templates/mybatis-generator/entity2.java");
    119.         templateConfig.setService("templates/mybatis-generator/service2.java");
    120.         templateConfig.setServiceImpl("templates/mybatis-generator/serviceImpl2.java");
    121.         templateConfig.setController("templates/mybatis-generator/controller2.java");
    122.         templateConfig.setXml(null);
    123.         mpg.setTemplate(templateConfig);
    124.  
    125.         // 策略配置
    126.         StrategyConfig strategy = new StrategyConfig();
    127.         strategy.setNaming(NamingStrategy.underline_to_camel);
    128.         strategy.setColumnNaming(NamingStrategy.underline_to_camel);
    129.         //strategy.setSuperEntityClass("你自己的父类实体,没有就不用设置!");
    130.         strategy.setEntityLombokModel(true);
    131.         strategy.setRestControllerStyle(true);
    132.         strategy.setEntitySerialVersionUID(false);
    133.         // 公共父类
    134.         //strategy.setSuperControllerClass("你自己的父类控制器,没有就不用设置!");
    135.         // 写于父类中的公共字段
    136.         strategy.setSuperEntityColumns("id");
    137.         strategy.setInclude(scanner("表名，多个英文逗号分割").split(","));
    138.         strategy.setControllerMappingHyphenStyle(true);
    139.         strategy.setTablePrefix("t_");
    140.         mpg.setStrategy(strategy);
    141.         mpg.setTemplateEngine(new FreemarkerTemplateEngine());
    142.         mpg.execute();
    143.     }
    144. }

    将自定义的代码生成模板放到templates目录下，覆盖Mybatis-plus默认的代码生成模板

    名为mybatis-generator的文件夹，将该文件夹放入resources下的templates下

    controller2.java.ftl

    1. package ${package.Controller};
    2.  
    3.  
    4. import org.springframework.web.bind.annotation.RequestMapping;
    5.  
    6. <#if restControllerStyle>
    7. import org.springframework.web.bind.annotation.RestController;
    8. <#else>
    9. import org.springframework.stereotype.Controller;
    11. <#if superControllerClassPackage??>
    12. import ${superControllerClassPackage};
    14.  
    15. /**
    16.  * <p>
    17.  * ${table.comment!} 前端控制器
    18.  * p>
    19.  *
    20.  * @author ${author}
    21.  * @since ${date}
    22.  */
    23. <#if restControllerStyle>
    24. @RestController
    25. <#else>
    26. @Controller
    28. @RequestMapping("<#if package.ModuleName?? && package.ModuleName != "">/${package.ModuleName}/<#if controllerMappingHyphenStyle??>${controllerMappingHyphen}<#else>${table.entityPath}")
    29. <#if kotlin>
    30. class ${table.controllerName}<#if superControllerClass??> : ${superControllerClass}()
    31. <#else>
    32. <#if superControllerClass??>
    33. public class ${table.controllerName} extends ${superControllerClass} {
    34. <#else>
    35. public class ${table.controllerName} {
    37.  
    38. }

    entity2.java.ftl

    1. package ${package.Entity};
    2.  
    3. <#list table.importPackages as pkg>
    4. import ${pkg};
    6. <#if swagger2>
    7. import io.swagger.annotations.ApiModel;
    8. import io.swagger.annotations.ApiModelProperty;
    9. if>
    10. <#if entityLombokModel>
    11. import lombok.Data;
    12. import lombok.EqualsAndHashCode;
    13.     <#if chainModel>
    14. import lombok.experimental.Accessors;
    15.     if>
    16. if>
    17.  
    18. /**
    19.  * 
    20.  * ${table.comment!}
    21.  * 
    22.  *
    23.  * @author ${author}
    24.  * @since ${date}
    25.  */
    26. <#if entityLombokModel>
    27. @Data
    28.     <#if superEntityClass??>
    29. @EqualsAndHashCode(callSuper = true)
    30.     <#else>
    31. @EqualsAndHashCode(callSuper = false)
    32.     if>
    33.     <#if chainModel>
    34. @Accessors(chain = true)
    35.     if>
    36. if>
    37. <#if table.convert>
    38. @TableName("${table.name}")
    39. if>
    40. <#if swagger2>
    41. @ApiModel(value="${entity}对象", description="${table.comment!}")
    42. if>
    43. <#if superEntityClass??>
    44. public class ${entity} extends ${superEntityClass}<#if activeRecord><${entity}>if> {
    45. <#elseif activeRecord>
    46. public class ${entity} extends Model<${entity}> {
    47. <#else>
    48. public class ${entity} implements Serializable {
    49. if>
    50.  
    51. <#if entitySerialVersionUID>
    52.     private static final long serialVersionUID = 1L;
    53. if>
    54. <#-- ----------  BEGIN 字段循环遍历  ---------->
    55. <#list table.fields as field>
    56.     <#if field.keyFlag>
    57.         <#assign keyPropertyName="${field.propertyName}"/>
    58.     if>
    59.  
    60.     <#if field.comment!?length gt 0>
    61.         <#if swagger2>
    62.     @ApiModelProperty(value = "${field.comment}")
    63.         <#else>
    64.     /**
    65.      * ${field.comment}
    66.      */
    67.         if>
    68.     if>
    69.     <#if field.keyFlag>
    70.         <#-- 主键 -->
    71.         <#if field.keyIdentityFlag>
    72.     @TableId(value = "${field.annotationColumnName}", type = IdType.AUTO)
    73.         <#elseif idType??>
    74.     @TableId(value = "${field.annotationColumnName}", type = IdType.${idType})
    75.         <#elseif field.convert>
    76.     @TableId("${field.annotationColumnName}")
    77.         if>
    78.         <#-- 普通字段 -->
    79.     <#elseif field.fill??>
    80.     <#-- -----   存在字段填充设置   ----->
    81.         <#if field.convert>
    82.     @TableField(value = "${field.annotationColumnName}", fill = FieldFill.${field.fill})
    83.         <#else>
    84.     @TableField(fill = FieldFill.${field.fill})
    85.         if>
    86.     <#elseif field.convert>
    87.     @TableField("${field.annotationColumnName}")
    88.     if>
    89.     <#-- 乐观锁注解 -->
    90.     <#if (versionFieldName!"") == field.name>
    91.     @Version
    92.     if>
    93.     <#-- 逻辑删除注解 -->
    94.     <#if (logicDeleteFieldName!"") == field.name>
    95.     @TableLogic
    96.     if>
    97.     private ${field.propertyType} ${field.propertyName};
    99. <#------------  END 字段循环遍历  ---------->
    100.  
    101. <#if !entityLombokModel>
    102.     <#list table.fields as field>
    103.         <#if field.propertyType == "boolean">
    104.             <#assign getprefix="is"/>
    105.         <#else>
    106.             <#assign getprefix="get"/>
    107.         if>
    108.     public ${field.propertyType} ${getprefix}${field.capitalName}() {
    109.         return ${field.propertyName};
    110.     }
    111.  
    112.     <#if chainModel>
    113.     public ${entity} set${field.capitalName}(${field.propertyType} ${field.propertyName}) {
    114.     <#else>
    115.     public void set${field.capitalName}(${field.propertyType} ${field.propertyName}) {
    116.     if>
    117.         this.${field.propertyName} = ${field.propertyName};
    118.         <#if chainModel>
    119.         return this;
    120.         if>
    121.     }
    122.     
    123. if>
    124.  
    125. <#if entityColumnConstant>
    126.     <#list table.fields as field>
    127.     public static final String ${field.name?upper_case} = "${field.name}";
    128.  
    129.     
    130. if>
    131. <#if activeRecord>
    132.     @Override
    133.     protected Serializable pkVal() {
    134.     <#if keyPropertyName??>
    135.         return this.${keyPropertyName};
    136.     <#else>
    137.         return null;
    138.     if>
    139.     }
    140.  
    141. if>
    142. <#if !entityLombokModel>
    143.     @Override
    144.     public String toString() {
    145.         return "${entity}{" +
    146.     <#list table.fields as field>
    147.         <#if field_index==0>
    148.             "${field.propertyName}=" + ${field.propertyName} +
    149.         <#else>
    150.             ", ${field.propertyName}=" + ${field.propertyName} +
    151.         if>
    152.     
    153.         "}";
    154.     }
    155. if>
    156. }

    mapper2.java.ftl

    1. package ${package.Mapper};
    2.  
    3. import ${package.Entity}.${entity};
    4. import ${superMapperClassPackage};
    5.  
    6. /**
    7.  * 
    8.  * ${table.comment!} Mapper 接口
    9.  * 
    10.  *
    11.  * @author ${author}
    12.  * @since ${date}
    13.  */
    14. <#if kotlin>
    15. interface ${table.mapperName} : ${superMapperClass}<${entity}>
    16. <#else>
    17. public interface ${table.mapperName} extends ${superMapperClass}<${entity}> {
    18.  
    19. }
    20. if>

    mapper2.xml.ftl

    1. "1.0" encoding="UTF-8"?>
    2. "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    3. "${package.Mapper}.${table.mapperName}">
    4.  
    5. <#if enableCache>
    6.     
    7.     "org.mybatis.caches.ehcache.LoggingEhcache"/>
    8.  
    9. if>
    10. <#if baseResultMap>
    11.     
    12.     "BaseResultMap" type="${package.Entity}.${entity}">
    13. <#list table.fields as field>
    14. <#if field.keyFlag><#--生成主键排在第一位-->
    15.         "${field.name}" property="${field.propertyName}" />
    16. if>
    18. <#list table.commonFields as field><#--生成公共字段 -->
    19.         "${field.name}" property="${field.propertyName}" />
    21. <#list table.fields as field>
    22. <#if !field.keyFlag><#--生成普通字段 -->
    23.         "${field.name}" property="${field.propertyName}" />
    24. if>
    26.     
    27.  
    28. if>
    29. <#if baseColumnList>
    30.     
    31.     "Base_Column_List">
    32. <#list table.commonFields as field>
    33.         ${field.columnName},
    35.         ${table.fieldNames}
    36.     
    37.  
    38. if>

    service2.java.ftl

    1. package ${package.Service};
    2.  
    3. import ${package.Entity}.${entity};
    4. import ${superServiceClassPackage};
    5.  
    6. /**
    7.  * 
    8.  * ${table.comment!} 服务类
    9.  * 
    10.  *
    11.  * @author ${author}
    12.  * @since ${date}
    13.  */
    14. <#if kotlin>
    15. interface ${table.serviceName} : ${superServiceClass}<${entity}>
    16. <#else>
    17. public interface ${table.serviceName} extends ${superServiceClass}<${entity}> {
    18.  
    19. }
    20. if>

    serviceImpl2.java.ftl

    1. package ${package.ServiceImpl};
    2.  
    3. import ${package.Entity}.${entity};
    4. import ${package.Mapper}.${table.mapperName};
    5. import ${package.Service}.${table.serviceName};
    6. import ${superServiceImplClassPackage};
    7. import org.springframework.stereotype.Service;
    8.  
    9. /**
    10.  * 
    11.  * ${table.comment!} 服务实现类
    12.  * 
    13.  *
    14.  * @author ${author}
    15.  * @since ${date}
    16.  */
    17. @Service
    18. <#if kotlin>
    19. open class ${table.serviceImplName} : ${superServiceImplClass}<${table.mapperName}, ${entity}>(), ${table.serviceName} {
    20.  
    21. }
    22. <#else>
    23. public class ${table.serviceImplName} extends ${superServiceImplClass}<${table.mapperName}, ${entity}> implements ${table.serviceName} {
    24.  
    25. }
    26. if>

    运行代码生成类 输入要生成的表名

     生成成功

     编辑IndexController并定义商品查询请求处理方法

    主要查询出 装饰摆件 和 墙式壁挂两个类别的上坪在首页进行展示

    SELECT * FROM t_goods;
    SELECT * FROM t_goods where goods_type = '01';
    SELECT * FROM t_goods where goods_type = '07';

    SELECT * FROM t_dict_type;
    SELECT * FROM t_dict_data;

    首页数据绑定语法

    1) list集合判空
    <#if goods07?? && goods07?size gt 0>

    2) 遍历map集合，获取所有的keys
    <#list goods07?keys as key>

    3) 根据key获取对应value值goods01[key]
    <#list goods07[key] as g>

    首页方法改造

    注意：

     IndexController 

    1. package com.cdl.spbootpro.controller;
    2.  
    3. import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
    4. import com.cdl.spbootpro.model.Goods;
    5. import com.cdl.spbootpro.service.IGoodsService;
    6. import com.cdl.spbootpro.utils.DataUtils;
    7. import org.springframework.beans.factory.annotation.Autowired;
    8. import org.springframework.stereotype.Controller;
    9. import org.springframework.ui.Model;
    10. import org.springframework.web.bind.annotation.RequestMapping;
    11. import org.springframework.web.bind.annotation.RestController;
    12.  
    13. import java.util.List;
    14. import java.util.Map;
    15.  
    16. /**
    17.  * @author cdl
    18.  * @site www.cdl.com
    19.  * @create 2022-11-05 17:31
    20.  */
    21. @Controller
    22. public class IndexController {
    23.     @Autowired
    24.     private IGoodsService goodsService;
    25.  
    26.     @RequestMapping("/")
    27.     public String index(Model model){
    28. //        模板前端
    29. //        /templates+index.html+""
    30.         //前缀+逻辑视图名+后缀
    31.         //        主要查询出 装饰摆件 和 墙式壁挂两个类别的上坪在首页进行展示
    32.         List goods01 = goodsService.list(new QueryWrapper().eq("goods_type", "01").last("limit 6"));
    33.         List goods07 = goodsService.list(new QueryWrapper().eq("goods_type", "07").last("limit 12"));
    34. //        将数据转换成容易在页面上进行展现的数据格式
    35.         DataUtils dataUtils = new DataUtils<>();
    36.         Map> gt01 = dataUtils.transfor(3, goods01);
    37.         Map> gt07 = dataUtils.transfor(4, goods07);
    38.         model.addAttribute("gt01",gt01);
    39.         model.addAttribute("gt07",gt07);
    40.         return "index.html";
    41.     }
    42.  
    43. }

    页面数据展示

    index.html

    1. html>
    2. <html>
    3. 	<head lang="en">
    4. 		<#include "common/head.html">
    5. 		<link rel="stylesheet" type="text/css" href="css/public.css"/>
    6. 		<link rel="stylesheet" type="text/css" href="css/index.css" />
    7. 	head>
    8. 	<body>
    9. 		
    10. 		<#include "common/top.html">
    11.  
    12. 		
    13. 		<div class="block_home_slider">
    14. 			<div id="home_slider" class="flexslider">
    15. 				<ul class="slides">
    16. 					<li>
    17. 						<div class="slide">
    18. 							<img src="img/banner2.jpg"/>
    19. 						div>
    20. 					li>
    21. 					<li>
    22. 						<div class="slide">
    23. 							<img src="img/banner1.jpg"/>
    24. 						div>
    25. 					li>
    26. 				ul>
    27. 			div>
    28. 		div>
    29. 		
    30. 		
    31. 		<div class="thImg">
    32. 			<div class="clearfix">
    33. 				<a href="${ctx}/page/vase_proList.html"><img src="img/i1.jpg"/>a>
    34. 				<a href="${ctx}/page/proList.html"><img src="img/i2.jpg"/>a>
    35. 				<a href="#2"><img src="img/i3.jpg"/>a>
    36. 			div>
    37. 		div>
    38. 		
    39. 		
    40. 		<div class="news">
    41. 			<div class="wrapper">
    42. 				<h2><img src="img/ih1.jpg"/>h2>
    43. 				<div class="top clearfix">
    44. 					<a href="${ctx}/page/proDetail.html"><img src="img/n1.jpg"/><p>p>a>
    45. 					<a href="${ctx}/page/proDetail.html"><img src="img/n2.jpg"/><p>p>a>
    46. 					<a href="${ctx}/page/proDetail.html"><img src="img/n3.jpg"/><p>p>a>
    47. 				div>
    48. 				<div class="bott clearfix">
    49. 					<a href="${ctx}/page/proDetail.html"><img src="img/n4.jpg"/><p>p>a>
    50. 					<a href="${ctx}/page/proDetail.html"><img src="img/n5.jpg"/><p>p>a>
    51. 					<a href="${ctx}/page/proDetail.html"><img src="img/n6.jpg"/><p>p>a>
    52. 				div>
    53. 				<h2><img src="img/ih2.jpg"/>h2>
    54. 				<#if gt01?? && gt01?size gt 0>
    55. 				<#list gt01?keys as key>
    56. 				<div class="flower clearfix tran">
    57. 					
    58. 					<#list gt01[key] as g>
    59. 					<a href="proDetail.html" class="clearfix">
    60. 						<dl>
    61. 							<dt>
    62. 								<span class="abl">span>
    63. 								<img src="${g.goodsImg}"/>
    64. 								<span class="abr">span>
    65. 							dt>
    66. 							<dd>${g.goodsName}dd>
    67. 							<dd><span>¥ ${g.goodsPrice}span>dd>
    68. 						dl>
    69. 					a>
    70. 				
    71. 			div>
    72. 		
    73. 	
    74.  
    75. 				
    76. 			div>
    77. 		div>
    78. 		
    79. 		
    80. 		<a href="#" class="ad"><img src="img/ib1.jpg"/>a>
    81. 		
    82. 		
    83. 		<div class="people">
    84. 			<div class="wrapper">
    85. 				<h2><img src="img/ih3.jpg"/>h2>
    86. 				<div class="pList clearfix tran">
    87. 					<a href="proDetail.html">
    88. 						<dl>
    89. 							<dt>
    90. 								<span class="abl">span>
    91. 								<img src="img/s7.jpg"/>
    92. 								<span class="abr">span>
    93. 							dt>
    94. 							<dd>【最家】不锈钢壁饰墙饰软装dd>
    95. 							<dd><span>￥688.00span>dd>
    96. 						dl>
    97. 					a>
    98. 					<a href="proDetail.html">
    99. 						<dl>
    100. 							<dt>
    101. 								<span class="abl">span>
    102. 								<img src="img/s10.jpg"/>
    103. 								<span class="abr">span>
    104. 							dt>
    105. 							<dd>【最家】小城动物木板画壁挂北欧dd>
    106. 							<dd><span>￥188.00span>dd>
    107. 						dl>
    108. 					a>
    109. 					<a href="proDetail.html">
    110. 						<dl>
    111. 							<dt>
    112. 								<span class="abl">span>
    113. 								<img src="img/s4.jpg"/>
    114. 								<span class="abr">span>
    115. 							dt>
    116. 							<dd>【最家】玄关假山水壁饰背景墙饰挂件创意dd>
    117. 							<dd><span>￥599.00span>dd>
    118. 						dl>
    119. 					a>
    120. 					<a href="proDetail.html">
    121. 						<dl>
    122. 							<dt>
    123. 								<span class="abl">span>
    124. 								<img src="img/s9.jpg"/>
    125. 								<span class="abr">span>
    126. 							dt>
    127. 							<dd>【最家】金属树枝壁饰铜鸟装饰品dd>
    128. 							<dd><span>￥928.00span>dd>
    129. 						dl>
    130. 					a>
    131. 				div>
    132. 				<div class="pList clearfix tran">
    133. 					<a href="proDetail.html">
    134. 						<dl>
    135. 							<dt>
    136. 								<span class="abl">span>
    137. 								<img src="img/s6.jpg"/>
    138. 								<span class="abr">span>
    139. 							dt>
    140. 							<dd>【最家】金属壁饰创意背景墙面挂件创意dd>
    141. 							<dd><span>￥228.00span>dd>
    142. 						dl>
    143. 					a>
    144. 					<a href="proDetail.html">
    145. 						<dl>
    146. 							<dt>
    147. 								<span class="abl">span>
    148. 								<img src="img/s8.jpg"/>
    149. 								<span class="abr">span>
    150. 							dt>
    151. 							<dd>【最家】小城动物木板画壁挂北欧dd>
    152. 							<dd><span>￥199.00span>dd>
    153. 						dl>
    154. 					a>
    155. 					<a href="proDetail.html">
    156. 						<dl>
    157. 							<dt>
    158. 								<span class="abl">span>
    159. 								<img src="img/s12.jpg"/>
    160. 								<span class="abr">span>
    161. 							dt>
    162. 							<dd>【最家】欧式复古挂钟创意餐厅钟表家居挂件dd>
    163. 							<dd><span>￥666.00span>dd>
    164. 						dl>
    165. 					a>
    166. 					<a href="proDetail.html">
    167. 						<dl>
    168. 							<dt>
    169. 								<span class="abl">span>
    170. 								<img src="img/s1.jpg"/>
    171. 								<span class="abr">span>
    172. 							dt>
    173. 							<dd>【最家】客厅地中海欧式现代相片墙创意dd>
    174. 							<dd><span>￥59.80span>dd>
    175. 						dl>
    176. 					a>
    177. 				div>
    178. 				<div class="pList clearfix tran">
    179. 					<a href="proDetail.html">
    180. 						<dl>
    181. 							<dt>
    182. 								<span class="abl">span>
    183. 								<img src="img/s5.jpg"/>
    184. 								<span class="abr">span>
    185. 							dt>
    186. 							<dd>【最家】铁艺荷叶壁挂软装背景墙上装饰品dd>
    187. 							<dd><span>￥800.00span>dd>
    188. 						dl>
    189. 					a>
    190. 					<a href="proDetail.html">
    191. 						<dl>
    192. 							<dt>
    193. 								<span class="abl">span>
    194. 								<img src="img/s3.jpg"/>
    195. 								<span class="abr">span>
    196. 							dt>
    197. 							<dd>【最家】欧式照片墙 创意组合结婚礼物dd>
    198. 							<dd><span>￥189.00span>dd>
    199. 						dl>
    200. 					a>
    201. 					<a href="proDetail.html">
    202. 						<dl>
    203. 							<dt>
    204. 								<span class="abl">span>
    205. 								<img src="img/s2.jpg"/>
    206. 								<span class="abr">span>
    207. 							dt>
    208. 							<dd>【最家】欧式钟表相框墙挂墙创意组合dd>
    209. 							<dd><span>￥148.00span>dd>
    210. 						dl>
    211. 					a>
    212. 					<a href="proDetail.html">
    213. 						<dl>
    214. 							<dt>
    215. 								<span class="abl">span>
    216. 								<img src="img/s11.jpg"/>
    217. 								<span class="abr">span>
    218. 							dt>
    219. 							<dd>【最家】小城动物木板画壁挂北欧dd>
    220. 							<dd><span>￥188.00span>dd>
    221. 						dl>
    222. 					a>
    223. 				div>
    224. 			div>
    225. 		div>
    226.  
    227. 		<#include "common/footer.html"/>
    228.  
    229. 		<script src="js/public.js" type="text/javascript" charset="utf-8">script>
    230. 		<script src="js/nav.js" type="text/javascript" charset="utf-8">script>
    231. 		<script src="js/jquery.flexslider-min.js" type="text/javascript" charset="utf-8">script>
    232. 		<script type="text/javascript">
    233. 			$(function() {
    234. 				$('#home_slider').flexslider({
    235. 					animation: 'slide',
    236. 					controlNav: true,
    237. 					directionNav: true,
    238. 					animationLoop: true,
    239. 					slideshow: true,
    240. 					slideshowSpeed:2000,
    241. 					useCSS: false
    242. 				});
    243.  
    244. 			});
    245. 		script>
    246. 	body>
    247. html>

    运行结果：

     可以发现所有的数据已经不一样了

    将页面的展示格式改变

    index.html

    1. html>
    2. <html>
    3. 	<head lang="en">
    4. 		<#include "common/head.html">
    5. 		<link rel="stylesheet" type="text/css" href="css/public.css"/>
    6. 		<link rel="stylesheet" type="text/css" href="css/index.css" />
    7. 	head>
    8. 	<body>
    9. 		
    10. 		<#include "common/top.html">
    11.  
    12. 		
    13. 		<div class="block_home_slider">
    14. 			<div id="home_slider" class="flexslider">
    15. 				<ul class="slides">
    16. 					<li>
    17. 						<div class="slide">
    18. 							<img src="img/banner2.jpg"/>
    19. 						div>
    20. 					li>
    21. 					<li>
    22. 						<div class="slide">
    23. 							<img src="img/banner1.jpg"/>
    24. 						div>
    25. 					li>
    26. 				ul>
    27. 			div>
    28. 		div>
    29. 		
    30. 		
    31. 		<div class="thImg">
    32. 			<div class="clearfix">
    33. 				<a href="${ctx}/page/vase_proList.html"><img src="img/i1.jpg"/>a>
    34. 				<a href="${ctx}/page/proList.html"><img src="img/i2.jpg"/>a>
    35. 				<a href="#2"><img src="img/i3.jpg"/>a>
    36. 			div>
    37. 		div>
    38. 		
    39. 		
    40. 		<div class="news">
    41. 			<div class="wrapper">
    42. 				<h2><img src="img/ih1.jpg"/>h2>
    43. 				<div class="top clearfix">
    44. 					<a href="${ctx}/page/proDetail.html"><img src="img/n1.jpg"/><p>p>a>
    45. 					<a href="${ctx}/page/proDetail.html"><img src="img/n2.jpg"/><p>p>a>
    46. 					<a href="${ctx}/page/proDetail.html"><img src="img/n3.jpg"/><p>p>a>
    47. 				div>
    48. 				<div class="bott clearfix">
    49. 					<a href="${ctx}/page/proDetail.html"><img src="img/n4.jpg"/><p>p>a>
    50. 					<a href="${ctx}/page/proDetail.html"><img src="img/n5.jpg"/><p>p>a>
    51. 					<a href="${ctx}/page/proDetail.html"><img src="img/n6.jpg"/><p>p>a>
    52. 				div>
    53. 				<h2><img src="img/ih2.jpg"/>h2>
    54. 				<#if gt01?? && gt01?size gt 0>
    55. 				<#list gt01?keys as key>
    56. 				<div class="flower clearfix tran">
    57. 					
    58. 					<#list gt01[key] as g>
    59. 					<a href="proDetail.html" class="clearfix">
    60. 						<dl>
    61. 							<dt>
    62. 								<span class="abl">span>
    63. 								<img src="${g.goodsImg}"/>
    64. 								<span class="abr">span>
    65. 							dt>
    66. 							<dd>${g.goodsName}dd>
    67. 							<dd><span>¥ ${g.goodsPrice}span>dd>
    68. 						dl>
    69. 					a>
    70. 				
    71. 			div>
    72. 		
    73. 	
    74.  
    75. 				
    76. 			div>
    77. 		div>
    78. 		
    79. 		
    80. 		<a href="#" class="ad"><img src="img/ib1.jpg"/>a>
    81. 		
    82. 		
    83. 		<div class="people">
    84. 			< class="wrapper">
    85. 				<h2><img src="img/ih3.jpg"/>h2>
    86. 				<#if gt07?? && gt07?size gt 0>
    87. 				<#list gt07?keys as key>
    88. 			<div class="pList clearfix tran">
    89. 				<#list gt07[key] as g>
    90. 				<a href="proDetail.html">
    91. 					<dl>
    92. 						<dt>
    93. 							<span class="abl">span>
    94. 							<img src="${g.goodsImg}"/>
    95. 							<span class="abr">span>
    96. 						dt>
    97. 						<dd>${g.goodsName}dd>
    98. 						<dd><span>￥ ${g.goodsPrice}span>dd>
    99. 					dl>
    100. 				a>
    101. 		
    102. 		div>
    105.  
    106. 			div>
    107. 		div>
    108.  
    109. 		<#include "common/footer.html"/>
    110.  
    111. 		<script src="js/public.js" type="text/javascript" charset="utf-8">script>
    112. 		<script src="js/nav.js" type="text/javascript" charset="utf-8">script>
    113. 		<script src="js/jquery.flexslider-min.js" type="text/javascript" charset="utf-8">script>
    114. 		<script type="text/javascript">
    115. 			$(function() {
    116. 				$('#home_slider').flexslider({
    117. 					animation: 'slide',
    118. 					controlNav: true,
    119. 					directionNav: true,
    120. 					animationLoop: true,
    121. 					slideshow: true,
    122. 					slideshowSpeed:2000,
    123. 					useCSS: false
    124. 				});
    125.  
    126. 			});
    127. 		script>
    128. 	body>
    129. html>

    此时的页面还是不能够跳转的

    四、用户明文登录 

    要实现登录功能，要确保页面间能够跳转

    公共跳转控制器PageController

    PageController

    1. package com.cdl.spbootpro.controller;
    2.  
    3. import org.springframework.stereotype.Controller;
    4. import org.springframework.web.bind.annotation.PathVariable;
    5. import org.springframework.web.bind.annotation.RequestMapping;
    6.  
    7. /**
    8.  * @author cdl
    9.  * @site www.cdl.com
    10.  * @create 2022-11-05 21:45
    11.  */
    12. @Controller
    13. public class PageController {
    14.  
    15.     /**
    16.      * 直接跳转页面（没有层级文件夹的情况）
    17.      * 列如：
    18.      *  http://localhost:8081/page/paint.html
    19.      *  http://localhost:8081/page/perfume.html
    20.      *
    21.      * @return
    22.      */
    23.     @RequestMapping("/page/{page}")
    24.     public String page(@PathVariable(value = "page") String page) {
    25.         return page;
    26.     }
    27.  
    28.     /**
    29.      * 直接跳转页面（存在层级文件夹的情况）
    30.      *
    31.      * @return
    32.      */
    33.     @RequestMapping("/page/{dir}/{page}")
    34.     public String dir(@PathVariable(value = "dir") String dir, @PathVariable(value = "page") String page) {
    35.         return dir + "/" + page;
    36.     }
    37.  
    38.  
    39. }

    跳转成功

     在js下建一个包（login）再建一个文件（login.js）用于写登录的内容

    1. $(function () {
    2.    // alert(1);
    3.     //    给登录按钮添加事件
    4.     $("#login").click(function () {
    5.         let mobile = $("#mobile").val();
    6.         let password = $("#password").val();
    7.  
    8.         //2.向后台发起登录ajax请求
    9.         $.post('/user/userLogin',{
    10.             mobile:mobile,
    11.             password:password
    12.         },function(rs){
    13.             if(rs.code!=200){
    14.                 alert(rs.msg);
    15.             }else
    16.             //alert(rs.msg);
    17.                 location.href='/';
    18.         },'json');
    19.     });
    20. });

    定义UserDto.java接受前台传递的参数

    UserDto 

    1. package com.cdl.spbootpro.model.dto;
    2.  
    3. import com.cdl.spbootpro.validator.IsMobile;
    4. import lombok.Data;
    5.  
    6. import javax.validation.constraints.NotBlank;
    7.  
    8. @Data
    9. public class UserDto {
    10.     @NotBlank(message = "手机号码不能为空！")
    11.     @IsMobile
    12.     private String mobile;
    13.     @NotBlank(message = "密码不能为空！")
    14.     private String password;
    15. }

    处理浏览器端的请求 UserController

    1. package com.cdl.spbootpro.controller;
    2.  
    3.  
    4. import com.cdl.spbootpro.model.dto.UserDto;
    5. import com.cdl.spbootpro.service.IUserService;
    6. import com.cdl.spbootpro.utils.JsonResponseBody;
    7. import org.springframework.beans.factory.annotation.Autowired;
    8. import org.springframework.web.bind.annotation.RequestMapping;
    9.  
    10. import org.springframework.web.bind.annotation.RestController;
    11.  
    12. import javax.servlet.http.HttpServletRequest;
    13. import javax.servlet.http.HttpServletResponse;
    14. import javax.validation.Valid;
    15.  
    16. /**
    17.  * 
    18.  * 用户信息表 前端控制器
    19.  * 
    20.  *
    21.  * @author cdl
    22.  * @since 2022-11-05
    23.  */
    24. @RestController
    25. @RequestMapping("/user")
    26. public class UserController {
    27.  
    28.     @Autowired
    29.     private IUserService userService;
    30.  
    31.     @RequestMapping("/userLogin")
    32.     public JsonResponseBody userLogin(@Valid UserDto userDto,
    33.                                       HttpServletRequest req,
    34.                                       HttpServletResponse resp){
    35.         return userService.userLogin(userDto,req,resp);
    36.     }
    37.  
    38. }

    对应的业务代码

    IUserService 

    1. package com.cdl.spbootpro.service;
    2.  
    3. import com.cdl.spbootpro.model.User;
    4. import com.baomidou.mybatisplus.extension.service.IService;
    5. import com.cdl.spbootpro.model.dto.UserDto;
    6. import com.cdl.spbootpro.utils.JsonResponseBody;
    7.  
    8. import javax.servlet.http.HttpServletRequest;
    9. import javax.servlet.http.HttpServletResponse;
    10.  
    11. /**
    12.  * 
    13.  * 用户信息表 服务类
    14.  * 
    15.  *
    16.  * @author cdl
    17.  * @since 2022-11-05
    18.  */
    19. public interface IUserService extends IService {
    20.  
    21.     JsonResponseBody userLogin(UserDto userDto, HttpServletRequest req, HttpServletResponse resp);
    22. }

     UserServiceImpl 

    1. package com.cdl.spbootpro.service.impl;
    2.  
    3. import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
    4. import com.cdl.spbootpro.exception.BusinessException;
    5. import com.cdl.spbootpro.model.User;
    6. import com.cdl.spbootpro.mapper.UserMapper;
    7. import com.cdl.spbootpro.model.dto.UserDto;
    8. import com.cdl.spbootpro.service.IUserService;
    9. import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
    10. import com.cdl.spbootpro.utils.JsonResponseBody;
    11. import com.cdl.spbootpro.utils.JsonResponseStatus;
    12. import org.springframework.beans.factory.annotation.Autowired;
    13. import org.springframework.stereotype.Service;
    14.  
    15. import javax.servlet.http.HttpServletRequest;
    16. import javax.servlet.http.HttpServletResponse;
    17.  
    18. /**
    19.  * 
    20.  * 用户信息表 服务实现类
    21.  * 
    22.  *
    23.  * @author cdl
    24.  * @since 2022-11-05
    25.  */
    26. @Service
    27. public class UserServiceImpl extends ServiceImpl implements IUserService {
    28.  
    29.     @Autowired
    30.     private UserMapper userMapper;
    31.  
    32.  
    33.     @Override
    34.     public JsonResponseBody userLogin(UserDto userDto, HttpServletRequest req, HttpServletResponse resp) {
    35. //要做的事情：
    36. // 判断mobile和password是否为空 已由JSP303完成（在controller中的UserDto添加@Valid便可解决）
    37. //判断mobile格式是否正确  （自定义验证注解@IsMobile）
    38. //根据用户手机号码查询用户
    39.  User user = userMapper.selectOne(new QueryWrapper()
    40.                 .eq("id", userDto.getMobile()));
    41. // 判断所查询的用户是否存在(校验账号)
    42.         if(null==user)
    43.             throw new BusinessException(JsonResponseStatus.USER_USERNAME_ERROR);
    44. //校验密码
    45.         if(!user.getPassword().equals(userDto.getPassword()))
    46.             throw new BusinessException(JsonResponseStatus.USER_PASSWORD_ERROR);
    47.         return new JsonResponseBody<>();
    48.     }
    49. }

    注意：

     此时的数据库（没有使用盐加密）

     测试一下

    什么也不填

    输入正确的手机号码和密码(123456)

    会进入主页面

     输入错的密码 

    五、前端及数据库密码加密

    盐加密

    前端加密：防止客户端浏览器F12导致密码泄露

    后端加密：防止数据库数据泄露导致密码泄露

    login.js变更如下

    login.js

    1. $(function () {
    2.    // alert(1);
    3.     //    给登录按钮添加事件
    4.     $("#login").click(function () {
    5.         let mobile = $("#mobile").val();
    6.         let password = $("#password").val();
    7.  
    8.         //1.密码加密
    9.         //1) 定义固定盐
    10.         let salt='f1g2h3j4';
    11.         //2) 固定盐混淆
    12.         let temp=salt.charAt(1)+""+salt.charAt(5)+password+salt.charAt(0)+""+salt.charAt(3);
    13.         //3) 使用MD5完成前端第一次加密
    14.         let pwd=md5(temp);
    15.  
    16.         console.log("mobile=%s,password=%s",mobile,pwd);
    17.  
    18.         //2.向后台发起登录ajax请求
    19.         $.post('/user/userLogin',{
    20.             mobile:mobile,
    21.             password:pwd
    22.         },function(rs){
    23.             if(rs.code!=200){
    24.                 alert(rs.msg);
    25.             }else
    26.             //alert(rs.msg);
    27.                 location.href='/';
    28.         },'json');
    29.     });
    30. });

     UserServiceImpl 

    1. package com.cdl.spbootpro.service.impl;
    2.  
    3. import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
    4. import com.cdl.spbootpro.exception.BusinessException;
    5. import com.cdl.spbootpro.model.User;
    6. import com.cdl.spbootpro.mapper.UserMapper;
    7. import com.cdl.spbootpro.model.dto.UserDto;
    8. import com.cdl.spbootpro.service.IUserService;
    9. import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
    10. import com.cdl.spbootpro.utils.JsonResponseBody;
    11. import com.cdl.spbootpro.utils.JsonResponseStatus;
    12. import com.cdl.spbootpro.utils.MD5Utils;
    13. import org.springframework.beans.factory.annotation.Autowired;
    14. import org.springframework.stereotype.Service;
    15.  
    16. import javax.servlet.http.HttpServletRequest;
    17. import javax.servlet.http.HttpServletResponse;
    18.  
    19. /**
    20.  * 
    21.  * 用户信息表 服务实现类
    22.  * 
    23.  *
    24.  * @author cdl
    25.  * @since 2022-11-05
    26.  */
    27. @Service
    28. public class UserServiceImpl extends ServiceImpl implements IUserService {
    29.  
    30.     @Autowired
    31.     private UserMapper userMapper;
    32.  
    33.  
    34.     @Override
    35.     public JsonResponseBody userLogin(UserDto userDto, HttpServletRequest req, HttpServletResponse resp) {
    36. //要做的事情：
    37. // 判断mobile和password是否为空 已由JSP303完成（在controller中的UserDto添加@Valid便可解决）
    38. //判断mobile格式是否正确  （自定义验证注解@IsMobile）
    39. //根据用户手机号码查询用户
    40.  User user = userMapper.selectOne(new QueryWrapper()
    41.                 .eq("id", userDto.getMobile()));
    42. // 判断所查询的用户是否存在(校验账号)
    43.         if(null==user)
    44.             throw new BusinessException(JsonResponseStatus.USER_USERNAME_ERROR);
    45. //前台传递到后台的密码 要经过工具类MD5加密一次才有可能跟数据库密码匹配上
    46.         String pwd = MD5Utils.formPassToDbPass(userDto.getPassword(), user.getSalt());
    47.         //校验密码
    48.         if(!user.getPassword().equals(pwd))
    49.             throw new BusinessException(JsonResponseStatus.USER_PASSWORD_ERROR);
    50.         return new JsonResponseBody<>();
    51.     }
    52. }

    在login.html中引入md5.js

    login.html

    1. html>
    2. <html>
    3. 	<head>
    4. 		<#include "common/head.html">
    5. 		<link rel="stylesheet" type="text/css" href="css/public.css"/>
    6. 		<link rel="stylesheet" type="text/css" href="css/login.css"/>
    7. 		<script type="text/javascript" src="js/jquery-1.12.4.min.js">script>
    8. 		<script type="text/javascript" src="js/md5.js">script>
    9. 		<script type="text/javascript" src="js/login/login.js">script>
    10.  
    11. 	head>
    12. 	<body>
    13. 		
    14. 		<div class="login">
    15. 			<form action="#" method="post">
    16. 				<h1><a href="${ctx}/"><img src="img/temp/logo.png">a>h1>
    17. 				<p>p>
    18. 				<div class="msg-warn hide"><b>b>公共场所不建议自动登录，以防账号丢失div>
    19. 				<p><input style="font-size:14px;" type="text" id="mobile" value="" placeholder="邮箱/手机号">p>
    20. 				<p><input style="font-size:14px;" type="password" id="password" value="" placeholder="密码">p>
    21. 				<p><input type="button" id="login" value="登  录">p>
    22. 				<p class="txt"><a class="" href="${ctx}/page/reg.html">免费注册a><a href="${ctx}/page/forget.html">忘记密码？a>p>
    23. 			form>
    24. 		div>
    25. 		
    26. 	body>
    27. html>

    加密成功

    六、服务端客户端登录密码管理

    登录令牌管理

    将登录的用户数据分别保留在客户端以及服务端

     UserServiceImpl.java变更如下

    UserServiceImpl 

    1. package com.cdl.spbootpro.service.impl;
    2.  
    3. import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
    4. import com.cdl.spbootpro.exception.BusinessException;
    5. import com.cdl.spbootpro.model.User;
    6. import com.cdl.spbootpro.mapper.UserMapper;
    7. import com.cdl.spbootpro.model.dto.UserDto;
    8. import com.cdl.spbootpro.service.IRedisService;
    9. import com.cdl.spbootpro.service.IUserService;
    10. import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
    11. import com.cdl.spbootpro.utils.CookieUtils;
    12. import com.cdl.spbootpro.utils.JsonResponseBody;
    13. import com.cdl.spbootpro.utils.JsonResponseStatus;
    14. import com.cdl.spbootpro.utils.MD5Utils;
    15. import org.springframework.beans.factory.annotation.Autowired;
    16. import org.springframework.stereotype.Service;
    17.  
    18. import javax.servlet.http.HttpServletRequest;
    19. import javax.servlet.http.HttpServletResponse;
    20. import java.util.UUID;
    21.  
    22. /**
    23.  * 
    24.  * 用户信息表 服务实现类
    25.  * 
    26.  *
    27.  * @author cdl
    28.  * @since 2022-11-05
    29.  */
    30. @Service
    31. public class UserServiceImpl extends ServiceImpl implements IUserService {
    32.  
    33.     @Autowired
    34.     private UserMapper userMapper;
    35.     @Autowired
    36.     private IRedisService redisService;
    37.  
    38.  
    39.     @Override
    40.     public JsonResponseBody userLogin(UserDto userDto, HttpServletRequest req, HttpServletResponse resp) {
    41. //要做的事情：
    42. // 判断mobile和password是否为空 已由JSP303完成（在controller中的UserDto添加@Valid便可解决）
    43. //判断mobile格式是否正确  （自定义验证注解@IsMobile）
    44. //根据用户手机号码查询用户
    45.  User user = userMapper.selectOne(new QueryWrapper()
    46.                 .eq("id", userDto.getMobile()));
    47. // 判断所查询的用户是否存在(校验账号)
    48.         if(null==user)
    49.             throw new BusinessException(JsonResponseStatus.USER_USERNAME_ERROR);
    50. //前台传递到后台的密码 要经过工具类MD5加密一次才有可能跟数据库密码匹配上
    51.         String pwd = MD5Utils.formPassToDbPass(userDto.getPassword(), user.getSalt());
    52.         //校验密码
    53.         if(!user.getPassword().equals(pwd))
    54.             throw new BusinessException(JsonResponseStatus.USER_PASSWORD_ERROR);
    55.         //将登陆用户对象与token令牌进行绑定保存到cookie和redis
    56.         //创建登陆令牌token
    57.         String token= UUID.randomUUID().toString().replace("-","");
    58.         //将token令牌保存到cookie中
    59.         CookieUtils.setCookie(req,resp,"token",token,7200);
    60.         //将登陆token令牌与用户对象user绑定到redis中
    61.         redisService.setUserToRedis(token,user);
    62.         //将用户登陆的昵称设置到cookie中
    63.         CookieUtils.setCookie(req,resp,"nickname",user.getNickname());
    64.         return new JsonResponseBody<>();
    65.     }
    66. }

    IRedisService

    1. package com.cdl.spbootpro.service;
    2.  
    3. import com.cdl.spbootpro.model.User;
    4.  
    5. /**
    6.  * @author cdl
    7.  * @site www.cdl.com
    8.  * @create 2022-11-06 0:43
    9.  */
    10. public interface IRedisService {
    11.     //存贮数据
    12.     void setUserToRedis(String token, User user);
    13.  
    14.     User getUserToRedis(String token);
    15. }

     IRedisServiceImpl 

    1. package com.cdl.spbootpro.service.impl;
    2.  
    3. import com.cdl.spbootpro.model.User;
    4. import com.cdl.spbootpro.service.IRedisService;
    5. import org.springframework.beans.factory.annotation.Autowired;
    6. import org.springframework.data.redis.core.RedisTemplate;
    7. import org.springframework.stereotype.Service;
    8.  
    9. import java.util.concurrent.TimeUnit;
    10.  
    11. /**
    12.  * @author cdl
    13.  * @site www.cdl.com
    14.  * @create 2022-11-06 0:45
    15.  */
    16. @Service
    17. public class IRedisServiceImpl implements IRedisService {
    18.     @Autowired
    19.     private RedisTemplate redisTemplate;
    20.  
    21.     @Override
    22.     public void setUserToRedis(String token, User user) {
    23.         redisTemplate.opsForValue().set("user:"+token,user,7200L, TimeUnit.SECONDS);//进reids
    24.     }
    25.  
    26.     @Override
    27.     public User getUserToRedis(String token) {
    28.         User user = (User) redisTemplate.opsForValue().get("user:" + token);
    29.        return user;
    30.     }
    31. }

    运行

     

     用的工具类

    utils下

    CookieUtils 

    1. package com.cdl.spbootpro.utils;
    2.  
    3. import lombok.extern.slf4j.Slf4j;
    4.  
    5. import javax.servlet.http.Cookie;
    6. import javax.servlet.http.HttpServletRequest;
    7. import javax.servlet.http.HttpServletResponse;
    8. import java.io.UnsupportedEncodingException;
    9. import java.net.URLDecoder;
    10. import java.net.URLEncoder;
    11.  
    12. @Slf4j
    13. public class CookieUtils {
    14.  
    15.     /**
    16.      *
    17.      * @Description: 得到Cookie的值, 不编码
    18.      * @param request
    19.      * @param cookieName
    20.      * @return
    21.      */
    22.     public static String getCookieValue(HttpServletRequest request, String cookieName) {
    23.         return getCookieValue(request, cookieName, false);
    24.     }
    25.  
    26.     /**
    27.      *
    28.      * @Description: 得到Cookie的值
    29.      * @param request
    30.      * @param cookieName
    31.      * @param isDecoder
    32.      * @return
    33.      */
    34.     public static String getCookieValue(HttpServletRequest request, String cookieName, boolean isDecoder) {
    35.         Cookie[] cookieList = request.getCookies();
    36.         if (cookieList == null || cookieName == null) {
    37.             return null;
    38.         }
    39.         String retValue = null;
    40.         try {
    41.             for (int i = 0; i < cookieList.length; i++) {
    42.                 if (cookieList[i].getName().equals(cookieName)) {
    43.                     if (isDecoder) {
    44.                         retValue = URLDecoder.decode(cookieList[i].getValue(), "UTF-8");
    45.                     } else {
    46.                         retValue = cookieList[i].getValue();
    47.                     }
    48.                     break;
    49.                 }
    50.             }
    51.         } catch (UnsupportedEncodingException e) {
    52.             e.printStackTrace();
    53.         }
    54.         return retValue;
    55.     }
    56.  
    57.     /**
    58.      *
    59.      * @Description: 得到Cookie的值
    60.      * @param request
    61.      * @param cookieName
    62.      * @param encodeString
    63.      * @return
    64.      */
    65.     public static String getCookieValue(HttpServletRequest request, String cookieName, String encodeString) {
    66.         Cookie[] cookieList = request.getCookies();
    67.         if (cookieList == null || cookieName == null) {
    68.             return null;
    69.         }
    70.         String retValue = null;
    71.         try {
    72.             for (int i = 0; i < cookieList.length; i++) {
    73.                 if (cookieList[i].getName().equals(cookieName)) {
    74.                     retValue = URLDecoder.decode(cookieList[i].getValue(), encodeString);
    75.                     break;
    76.                 }
    77.             }
    78.         } catch (UnsupportedEncodingException e) {
    79.             e.printStackTrace();
    80.         }
    81.         return retValue;
    82.     }
    83.  
    84.     /**
    85.      *
    86.      * @Description: 设置Cookie的值 不设置生效时间默认浏览器关闭即失效,也不编码
    87.      * @param request
    88.      * @param response
    89.      * @param cookieName
    90.      * @param cookieValue
    91.      */
    92.     public static void setCookie(HttpServletRequest request, HttpServletResponse response, String cookieName,
    93.                                  String cookieValue) {
    94.         setCookie(request, response, cookieName, cookieValue, -1);
    95.     }
    96.  
    97.     /**
    98.      *
    99.      * @Description: 设置Cookie的值 在指定时间内生效,但不编码
    100.      * @param request
    101.      * @param response
    102.      * @param cookieName
    103.      * @param cookieValue
    104.      * @param cookieMaxage
    105.      */
    106.     public static void setCookie(HttpServletRequest request, HttpServletResponse response, String cookieName,
    107.                                  String cookieValue, int cookieMaxage) {
    108.         setCookie(request, response, cookieName, cookieValue, cookieMaxage, false);
    109.     }
    110.  
    111.     /**
    112.      *
    113.      * @Description: 设置Cookie的值 不设置生效时间,但编码
    114.      * 在服务器被创建，返回给客户端，并且保存客户端
    115.      * 如果设置了SETMAXAGE(int seconds)，会把cookie保存在客户端的硬盘中
    116.      * 如果没有设置，会默认把cookie保存在浏览器的内存中
    117.      * 一旦设置setPath()：只能通过设置的路径才能获取到当前的cookie信息
    118.      * @param request
    119.      * @param response
    120.      * @param cookieName
    121.      * @param cookieValue
    122.      * @param isEncode
    123.      */
    124.     public static void setCookie(HttpServletRequest request, HttpServletResponse response, String cookieName,
    125.                                  String cookieValue, boolean isEncode) {
    126.         setCookie(request, response, cookieName, cookieValue, -1, isEncode);
    127.     }
    128.  
    129.     /**
    130.      *
    131.      * @Description: 设置Cookie的值 在指定时间内生效, 编码参数
    132.      * @param request
    133.      * @param response
    134.      * @param cookieName
    135.      * @param cookieValue
    136.      * @param cookieMaxage
    137.      * @param isEncode
    138.      */
    139.     public static void setCookie(HttpServletRequest request, HttpServletResponse response, String cookieName,
    140.                                  String cookieValue, int cookieMaxage, boolean isEncode) {
    141.         doSetCookie(request, response, cookieName, cookieValue, cookieMaxage, isEncode);
    142.     }
    143.  
    144.     /**
    145.      *
    146.      * @Description: 设置Cookie的值 在指定时间内生效, 编码参数(指定编码)
    147.      * @param request
    148.      * @param response
    149.      * @param cookieName
    150.      * @param cookieValue
    151.      * @param cookieMaxage
    152.      * @param encodeString
    153.      */
    154.     public static void setCookie(HttpServletRequest request, HttpServletResponse response, String cookieName,
    155.                                  String cookieValue, int cookieMaxage, String encodeString) {
    156.         doSetCookie(request, response, cookieName, cookieValue, cookieMaxage, encodeString);
    157.     }
    158.  
    159.     /**
    160.      *
    161.      * @Description: 删除Cookie带cookie域名
    162.      * @param request
    163.      * @param response
    164.      * @param cookieName
    165.      */
    166.     public static void deleteCookie(HttpServletRequest request, HttpServletResponse response,
    167.                                     String cookieName) {
    168.         doSetCookie(request, response, cookieName, null, -1, false);
    169.     }
    170.  
    171.  
    172.     /**
    173.      *
    174.      * @Description: 设置Cookie的值，并使其在指定时间内生效
    175.      * @param request
    176.      * @param response
    177.      * @param cookieName
    178.      * @param cookieValue
    179.      * @param cookieMaxage	cookie生效的最大秒数
    180.      * @param isEncode
    181.      */
    182.     private static final void doSetCookie(HttpServletRequest request, HttpServletResponse response,
    183.                                           String cookieName, String cookieValue, int cookieMaxage, boolean isEncode) {
    184.         try {
    185.             if (cookieValue == null) {
    186.                 cookieValue = "";
    187.             } else if (isEncode) {
    188.                 cookieValue = URLEncoder.encode(cookieValue, "utf-8");
    189.             }
    190.             Cookie cookie = new Cookie(cookieName, cookieValue);
    191.             if (cookieMaxage > 0)
    192.                 cookie.setMaxAge(cookieMaxage);
    193.             if (null != request) {// 设置域名的cookie
    194.                 String domainName = getDomainName(request);
    195.                 log.info("========== domainName: {} ==========", domainName);
    196.                 if (!"localhost".equals(domainName)) {
    197.                     cookie.setDomain(domainName);
    198.                 }
    199.             }
    200.             cookie.setPath("/");
    201.             response.addCookie(cookie);
    202.         } catch (Exception e) {
    203.             e.printStackTrace();
    204.         }
    205.     }
    206.  
    207.     /**
    208.      *
    209.      * @Description: 设置Cookie的值，并使其在指定时间内生效
    210.      * @param request
    211.      * @param response
    212.      * @param cookieName
    213.      * @param cookieValue
    214.      * @param cookieMaxage	cookie生效的最大秒数
    215.      * @param encodeString
    216.      */
    217.     private static final void doSetCookie(HttpServletRequest request, HttpServletResponse response,
    218.                                           String cookieName, String cookieValue, int cookieMaxage, String encodeString) {
    219.         try {
    220.             if (cookieValue == null) {
    221.                 cookieValue = "";
    222.             } else {
    223.                 cookieValue = URLEncoder.encode(cookieValue, encodeString);
    224.             }
    225.             Cookie cookie = new Cookie(cookieName, cookieValue);
    226.             if (cookieMaxage > 0)
    227.                 cookie.setMaxAge(cookieMaxage);
    228.             if (null != request) {// 设置域名的cookie
    229.                 String domainName = getDomainName(request);
    230.                 log.info("========== domainName: {} ==========", domainName);
    231.                 if (!"localhost".equals(domainName)) {
    232.                     cookie.setDomain(domainName);
    233.                 }
    234.             }
    235.             cookie.setPath("/");
    236.             response.addCookie(cookie);
    237.         } catch (Exception e) {
    238.             e.printStackTrace();
    239.         }
    240.     }
    241.  
    242.     /**
    243.      *
    244.      * @Description: 得到cookie的域名
    245.      * @return
    246.      */
    247.     private static final String getDomainName(HttpServletRequest request) {
    248.         String domainName = null;
    249.  
    250.         String serverName = request.getRequestURL().toString();
    251.         if (serverName == null || serverName.equals("")) {
    252.             domainName = "";
    253.         } else {
    254.             serverName = serverName.toLowerCase();
    255.             serverName = serverName.substring(7);
    256.             final int end = serverName.indexOf("/");
    257.             serverName = serverName.substring(0, end);
    258.             if (serverName.indexOf(":") > 0) {
    259.                 String[] ary = serverName.split("\\:");
    260.                 serverName = ary[0];
    261.             }
    262.  
    263.             final String[] domains = serverName.split("\\.");
    264.             int len = domains.length;
    265.             if (len > 3 && !isIp(serverName)) {
    266.                 // www.xxx.com.cn
    267.                 domainName = "." + domains[len - 3] + "." + domains[len - 2] + "." + domains[len - 1];
    268.             } else if (len <= 3 && len > 1) {
    269.                 // xxx.com or xxx.cn
    270.                 domainName = "." + domains[len - 2] + "." + domains[len - 1];
    271.             } else {
    272.                 domainName = serverName;
    273.             }
    274.         }
    275.         return domainName;
    276.     }
    277.  
    278.     public static String trimSpaces(String IP){//去掉IP字符串前后所有的空格
    279.         while(IP.startsWith(" ")){
    280.             IP= IP.substring(1,IP.length()).trim();
    281.         }
    282.         while(IP.endsWith(" ")){
    283.             IP= IP.substring(0,IP.length()-1).trim();
    284.         }
    285.         return IP;
    286.     }
    287.  
    288.     public static boolean isIp(String IP){//判断是否是一个IP
    289.         boolean b = false;
    290.         IP = trimSpaces(IP);
    291.         if(IP.matches("\\d{1,3}\\.\\d{1,3}\\.\\d{1,3}\\.\\d{1,3}")){
    292.             String s[] = IP.split("\\.");
    293.             if(Integer.parseInt(s[0])<255)
    294.                 if(Integer.parseInt(s[1])<255)
    295.                     if(Integer.parseInt(s[2])<255)
    296.                         if(Integer.parseInt(s[3])<255)
    297.                             b = true;
    298.         }
    299.         return b;
    300.     }
    301. }

     DataUtils 

    1. package com.cdl.spbootpro.utils;
    2.  
    3. import java.util.ArrayList;
    4. import java.util.HashMap;
    5. import java.util.List;
    6. import java.util.Map;
    7.  
    8. public class DataUtils {
    9.     /**
    10.      * 转换方法，基于商品的排版情况（一行三列、一行四列等等）进行数据分行处理
    11.      * @param cols  一行显示几列
    12.      * @param goods 需要筛选的数据集
    13.      * @return
    14.      */
    15.     public Map> transfor(int cols, List goods){
    16.         Map> data=new HashMap<>();
    17.         List rs=new ArrayList<>();
    18.         int len=goods.size();
    19.         for (int i = 0; i < len; i++) {
    20.             rs.add(goods.get(i));
    21.             if((i+1)%cols==0){
    22.                 data.put("goods"+(i+1),rs);
    23.                 if(i==len-1)
    24.                     break;
    25.                 rs=new ArrayList<>();
    26.                 continue;
    27.             }
    28.             if(i==len-1){
    29.                 data.put("goods"+(i+1),rs);
    30.             }
    31.         }
    32.         return data;
    33.     }
    34. }

     JsonResponseBody

    1. package com.cdl.spbootpro.utils;
    2.  
    3. import lombok.Data;
    4.  
    5. import java.io.Serializable;
    6.  
    7. /**
    8.  * 响应封装类
    9.  */
    10. @Data
    11. public class JsonResponseBody implements Serializable {
    12.  
    13.     private String msg="OK";
    14.     private T data;
    15.     private Integer code;
    16.     private Integer total;
    17.  
    18.     public JsonResponseBody(){
    19.         this.data=null;
    20.         this.code=JsonResponseStatus.SUCCESS.getCode();
    21.     }
    22.  
    23.     public JsonResponseBody(T data){
    24.         this.data=data;
    25.         this.code=JsonResponseStatus.SUCCESS.getCode();
    26.     }
    27.  
    28.     public JsonResponseBody(T data,Integer total){
    29.         this.data=data;
    30.         this.total=total;
    31.         this.code=JsonResponseStatus.SUCCESS.getCode();
    32.     }
    33.  
    34.     public JsonResponseBody(JsonResponseStatus jsonResponseStatus){
    35.         this.msg=jsonResponseStatus.getMsg();
    36.         this.code=jsonResponseStatus.getCode();
    37.     }
    38.  
    39.     public JsonResponseBody(JsonResponseStatus jsonResponseStatus,T data){
    40.         this.data=data;
    41.         this.msg=jsonResponseStatus.getMsg();
    42.         this.code=jsonResponseStatus.getCode();
    43.     }
    44. }

     JsonResponseStatus

    1. package com.cdl.spbootpro.utils;
    2.  
    3. import lombok.AllArgsConstructor;
    4. import lombok.Getter;
    5. import lombok.ToString;
    6.  
    7. @Getter
    8. @ToString
    9. @AllArgsConstructor
    10. public enum JsonResponseStatus {
    11.  
    12.     SUCCESS(200,"OK"),
    13.     ERROR(500,"内部错误"),
    14.  
    15.     USER_LOGIN_ERROR(100101,"用户名或者密码错误"),
    16.     USER_MOBILE_ERROR(100102,"手机号码格式错误"),
    17.     USER_PASSWORD_ERROR(100103,"用户密码错误"),
    18.     USER_USERNAME_ERROR(100104,"账号不存在"),
    19.  
    20.     BIND_ERROR(200101,"参数校验异常"),
    21.     TOKEN_EEROR(200102,"token令牌失效或已过期")
    22.     ;
    23.  
    24.     private final Integer code;
    25.     private final String msg;
    26. }

     MD5Utils 

    1. package com.cdl.spbootpro.utils;
    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. public class MD5Utils {
    16.  
    17.     //加密盐，与前端一致
    18.     private static String salt="f1g2h3j4";
    19.  
    20.     /**
    21.      * md5加密
    22.      * @param src
    23.      * @return
    24.      */
    25.     public static String md5(String src){
    26.         return DigestUtils.md5Hex(src);
    27.     }
    28.  
    29.     /**
    30.      * 获取加密的盐
    31.      * @return
    32.      */
    33.     public static String createSalt(){
    34.         return UUID.randomUUID().toString().replace("-","");
    35.     }
    36.  
    37.     /**
    38.      * 将前端的明文密码通过MD5加密方式加密成后端服务所需密码
    39.      * 注意：该步骤实际是在前端完成！！！
    40.      * @param inputPass 明文密码
    41.      * @return
    42.      */
    43.     public static String inputPassToFormpass(String inputPass){
    44.         //混淆固定盐salt,安全性更可靠
    45.         String str=salt.charAt(1)+""+salt.charAt(5)+inputPass+salt.charAt(0)+""+salt.charAt(3);
    46.         return md5(str);
    47.     }
    48.  
    49.     /**
    50.      * 将后端密文密码+随机salt生成数据库的密码
    51.      * @param formPass
    52.      * @param salt
    53.      * @return
    54.      */
    55.     public static String formPassToDbPass(String formPass,String salt){
    56.         //混淆固定盐salt,安全性更可靠
    57.         String str=salt.charAt(7)+""+salt.charAt(4)+formPass+salt.charAt(1)+""+salt.charAt(5);
    58.         return md5(str);
    59.     }
    60.  
    61.     /**
    62.      * 将用户输入的密码转换成数据库的密码
    63.      * @param inputPass 明文密码
    64.      * @param salt      盐
    65.      * @return
    66.      */
    67.     public static String inputPassToDbPass(String inputPass,String salt){
    68.         String formPass = inputPassToFormpass(inputPass);
    69.         String dbPass = formPassToDbPass(formPass, salt);
    70.         return dbPass;
    71.     }
    72.  
    73.     public static void main(String[] args) {
    74.         //d7aaa28e3b8e6c88352bd5e7c23829f9
    75.         //5512a78a188b318c074a15f9b056a712
    76.         String formPass = inputPassToFormpass("123456");
    77.         System.out.println("前端加密密码："+formPass);
    78.         String salt = createSalt();
    79.         System.out.println("后端加密随机盐："+salt);
    80.         String dbPass = formPassToDbPass(formPass, salt);
    81.         System.out.println("后端加密密码："+dbPass);
    82.         System.out.println("-------------------------------------------");
    83.         String dbPass1 = inputPassToDbPass("123456", salt);
    84.         System.out.println("最终加密密码："+dbPass1);
    85.     }
    86. }

     MybatisPlusConfig 

    1. package com.cdl.spbootpro.utils;
    2.  
    3. import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
    4. import com.baomidou.mybatisplus.extension.plugins.pagination.optimize.JsqlParserCountOptimize;
    5. import org.mybatis.spring.annotation.MapperScan;
    6. import org.springframework.context.annotation.Bean;
    7. import org.springframework.context.annotation.Configuration;
    8. import org.springframework.transaction.annotation.EnableTransactionManagement;
    9.  
    10. //Spring boot方式
    11. @EnableTransactionManagement
    12. @Configuration
    13. @MapperScan("com.cdl.shoppingpro.service.*.mapper*")
    14. public class MybatisPlusConfig {
    15.  
    16.     @Bean
    17.     public PaginationInterceptor paginationInterceptor() {
    18.         PaginationInterceptor paginationInterceptor = new PaginationInterceptor();
    19.         // 设置请求的页面大于最大页后操作， true调回到首页，false 继续请求  默认false
    20.         // paginationInterceptor.setOverflow(false);
    21.         // 设置最大单页限制数量，默认 500 条，-1 不受限制
    22.         // paginationInterceptor.setLimit(500);
    23.         // 开启 count 的 join 优化,只针对部分 left join
    24.         paginationInterceptor.setCountSqlParser(new JsqlParserCountOptimize(true));
    25.         return paginationInterceptor;
    26.     }
    27. }

     PageBean 

    1. package com.cdl.spbootpro.utils;
    2.  
    3. import javax.servlet.http.HttpServletRequest;
    4. import java.io.Serializable;
    5. import java.util.Map;
    6.  
    7. public class PageBean implements Serializable {
    8.  
    9. 	//页码
    10. 	private int page=1;
    11. 	//每页显示条数
    12. 	private int rows=10;
    13. 	//总记录数
    14. 	private int total=0;
    15. 	//是否分页标记
    16. 	private boolean pagination=true;
    17. 	//上一次请求的路径
    18. 	private String url;
    19. 	//请求参数Map集合
    20. 	private Map map;
    21. 	
    22. 	public String getUrl() {
    23. 		return url;
    24. 	}
    25. 	public void setUrl(String url) {
    26. 		this.url = url;
    27. 	}
    28. 	public Map getMap() {
    29. 		return map;
    30. 	}
    31. 	public void setMap(Map map) {
    32. 		this.map = map;
    33. 	}
    34. 	public int getPage() {
    35. 		return page;
    36. 	}
    37. 	public void setPage(int page) {
    38. 		this.page = page;
    39. 	}
    40. 	public int getRows() {
    41. 		return rows;
    42. 	}
    43. 	public void setRows(int rows) {
    44. 		this.rows = rows;
    45. 	}
    46. 	public int getTotal() {
    47. 		return total;
    48. 	}
    49. 	public void setTotal(int total) {
    50. 		this.total = total;
    51. 	}
    52. 	public boolean isPagination() {
    53. 		return pagination;
    54. 	}
    55. 	public void setPagination(boolean pagination) {
    56. 		this.pagination = pagination;
    57. 	}
    58. 	
    59. 	//重载setPage/setRows/setPagination方法
    60. 	public void setPage(String page) {
    61. 		if(null!=page&&!"".equals(page))
    62. 			this.page=Integer.parseInt(page);
    63. 	}
    64. 	public void setRows(String rows) {
    65. 		if(null!=rows&&!"".equals(rows))
    66. 			this.rows=Integer.parseInt(rows);
    67. 	}
    68. 	public void setPagination(String pagination) {
    69. 		if(null!=pagination&&!"".equals(pagination))
    70. 			this.pagination=Boolean.parseBoolean(pagination);
    71. 	}
    72. 	
    73. 	public void setRequest(HttpServletRequest req) {
    74. 		//获取前端提交的page/rows/pagination参数
    75. 		String page=req.getParameter("page");
    76. 		String rows=req.getParameter("rows");
    77. 		String pagination=req.getParameter("pagination");
    78. 		
    79. 		//设置属性
    80. 		this.setPage(page);
    81. 		this.setPagination(pagination);
    82. 		this.setRows(rows);
    83. 		
    84. 		//设置上一次请求的路径
    85. 		//第一次请求：
    86. 		//http://localhost:8080/项目名/请求路径.action?page=1
    87. 		//第二次请求：下一页  page=2
    88. 		//项目名+请求路径.action
    89. 		//req.getContextPath()+req.getServletPath()==req.getRequestURI()
    90. 		this.url=req.getRequestURI();
    91. 		
    92. 		//获取请求参数集合
    93. 		// checkbox name='hobby'
    94. 		// Map hobby==key  value==new String[]{"篮球","足球",..}
    95. 		this.map=req.getParameterMap();
    96. 	}
    97. 	
    98. 	/**
    99. 	 * 获取分页的起始位置
    100. 	 * @return
    101. 	 */
    102. 	public int getStartIndex() {
    103. 		//第1页：(1-1)*10  ==0    limit 0,10
    104. 		//第2页：(2-1)*10  ==10   limit 10,10
    105. 		//..
    106. 		return (this.page-1)*this.rows;
    107. 	}
    108. 	
    109. 	//获取末页、上一页、下一页
    110. 	/**
    111. 	 * 获取末页
    112. 	 * @return
    113. 	 */
    114. 	public int getMaxPager() {
    115. 		int maxPager=this.total/this.rows;
    116. 		if(this.total%this.rows!=0)
    117. 			maxPager++;
    118. 		return maxPager;
    119. 	}
    120. 	
    121. 	/**
    122. 	 * 获取上一页
    123. 	 * @return
    124. 	 */
    125. 	public int getPreviousPager() {
    126. 		int previousPager=this.page-1;
    127. 		if(previousPager<=1)
    128. 			previousPager=1;
    129. 		return previousPager;
    130. 	}
    131. 	
    132. 	/**
    133. 	 * 获取下一页
    134. 	 * @return
    135. 	 */
    136. 	public int getNextPager() {
    137. 		int nextPager=this.page+1;
    138. 		if(nextPager>getMaxPager())
    139. 			nextPager=getMaxPager();
    140. 		return nextPager;
    141. 	}
    142. 	@Override
    143. 	public String toString() {
    144. 		return "PageBean [page=" + page + ", rows=" + rows + ", total=" + total + ", pagination=" + pagination
    145. 				+ ", url=" + url + ", map=" + map + "]";
    146. 	}
    147. 	
    148. }
    149.  
    150.  
    151.  
    152.  
    153.  
    154.  
    155.  
    156.  
    157.  
    158.  
    159.

     ValidatorUtils 

    1. package com.cdl.spbootpro.utils;
    2.  
    3. import org.apache.commons.lang3.StringUtils;
    4.  
    5. import java.util.regex.Matcher;
    6. import java.util.regex.Pattern;
    7.  
    8. /**
    9.  * 正则校验工具类
    10.  * @author 刘开宇
    11.  */
    12. public class ValidatorUtils {
    13.  
    14.     private static final Pattern mobile_pattern=Pattern.compile("[1]([0-9])[0-9]{9}$");
    15.  
    16.     public static boolean isMobile(String mobile){
    17.         if(StringUtils.isEmpty(mobile))
    18.             return false;
    19.     Matcher matcher = mobile_pattern.matcher(mobile);
    20.         return matcher.matches();
    21. }
    22. }

  • 相关阅读:
    【Linux】软件包管理器yum
    Netty入门指南之NIO Selector监管
    Zookeeper：分布式过程协同技术
    恶意软件通杀 Win、macOS、Linux 三大系统；唱片巨头起诉 Youtube-dl 的托管服务商；2022 年不是 Linux 桌面元年 | 开源日报
    (四)GIT系列——GitLab备份与恢复
    CCF CSP题解：数字排序（201503-2）
    cesium 自定义气泡 类
    ubuntu下yolov5 tensorrt模型部署
    六、SSL开源项目-Open虚拟私有网络
    2022年6月 电子学会青少年软件编程 中小学生Python编程 等级考试一级真题答案解析（判断题）
  • 原文地址：https://blog.csdn.net/weixin_62735525/article/details/127705240