devbox
数据灵魂2
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

springboot项目：前后端搭建_springboot前后端完整项目

作者：数据灵魂2 | 2024-02-03 18:22:49

赞

踩

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依赖 -->
mybatis-plus-boot-starter 3.4.0
mybatis-plus-generator 3.4.0
<!-- hariki连接池 -->
HikariCP
<!-- MD5依赖 -->
commons-codec
commons-lang3 3.6
<!-- valid验证依赖 -->
spring-boot-starter-validation
<!-- redis -->
spring-boot-starter-data-redis

参考

pom.xml

  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.     <parent>
  6.         <groupId>org.springframework.boot</groupId>
  7.         <artifactId>spring-boot-starter-parent</artifactId>
  8.         <version>2.3.9.RELEASE</version>
  9.         <relativePath/> <!-- lookup parent from repository -->
  10.     </parent>
  11.     <groupId>com.cdl</groupId>
  12.     <artifactId>spbootpro</artifactId>
  13.     <version>0.0.1-SNAPSHOT</version>
  14.     <name>spbootpro</name>
  15.     <description>Demo project for Spring Boot</description>
  16.  
  17.     <properties>
  18.         <java.version>1.8</java.version>
  19.     </properties>
  20.     <dependencies>
  21.         <!--freemarker-->
  22.         <dependency>
  23.             <groupId>org.springframework.boot</groupId>
  24.             <artifactId>spring-boot-starter-freemarker</artifactId>
  25.         </dependency>
  26.  
  27.         <!--spring web-->
  28.         <dependency>
  29.             <groupId>org.springframework.boot</groupId>
  30.             <artifactId>spring-boot-starter-web</artifactId>
  31.         </dependency>
  32.  
  33.         <!--mysql-->
  34.         <dependency>
  35.             <groupId>mysql</groupId>
  36.             <artifactId>mysql-connector-java</artifactId>
  37.             <scope>runtime</scope>
  38.             <version>5.1.44</version>
  39.         </dependency>
  40.  
  41.         <!--lombok-->
  42.         <dependency>
  43.             <groupId>org.projectlombok</groupId>
  44.             <artifactId>lombok</artifactId>
  45.             <optional>true</optional>
  46.         </dependency>
  47.  
  48.         <!--junit-->
  49.         <dependency>
  50.             <groupId>org.springframework.boot</groupId>
  51.             <artifactId>spring-boot-starter-test</artifactId>
  52.             <scope>test</scope>
  53.             <exclusions>
  54.                 <exclusion>
  55.                     <groupId>org.junit.vintage</groupId>
  56.                     <artifactId>junit-vintage-engine</artifactId>
  57.                 </exclusion>
  58.             </exclusions>
  59.         </dependency>
  60.  
  61.         <dependency>
  62.             <groupId>junit</groupId>
  63.             <artifactId>junit</artifactId>
  64.             <scope>test</scope>
  65.         </dependency>
  66.  
  67.         <!-- mybatis plus依赖 -->
  68.         <dependency>
  69.             <groupId>com.baomidou</groupId>
  70.             <artifactId>mybatis-plus-boot-starter</artifactId>
  71.             <version>3.4.0</version>
  72.         </dependency>
  73.         <!-- mybatis-plus-generator依赖 -->
  74.         <dependency>
  75.             <groupId>com.baomidou</groupId>
  76.             <artifactId>mybatis-plus-generator</artifactId>
  77.             <version>3.4.0</version>
  78.         </dependency>
  79.  
  80.         <!--hariki-->
  81.         <dependency>
  82.             <groupId>com.zaxxer</groupId>
  83.             <artifactId>HikariCP</artifactId>
  84.         </dependency>
  85.  
  86.         <!-- MD5依赖 -->
  87.         <dependency>
  88.             <groupId>commons-codec</groupId>
  89.             <artifactId>commons-codec</artifactId>
  90.         </dependency>
  91.  
  92.         <dependency>
  93.             <groupId>org.apache.commons</groupId>
  94.             <artifactId>commons-lang3</artifactId>
  95.             <version>3.6</version>
  96.         </dependency>
  97.  
  98.         <!-- valid验证依赖 -->
  99.         <dependency>
  100.             <groupId>org.springframework.boot</groupId>
  101.             <artifactId>spring-boot-starter-validation</artifactId>
  102.         </dependency>
  103.  
  104.         <!--redis-->
  105.         <dependency>
  106.             <groupId>org.springframework.boot</groupId>
  107.             <artifactId>spring-boot-starter-data-redis</artifactId>
  108.         </dependency>
  109.  
  110.         <!--commons-pool2 对象池依赖 2.0版本的lettuce需要-->
  111.         <dependency>
  112.             <groupId>org.apache.commons</groupId>
  113.             <artifactId>commons-pool2</artifactId>
  114.         </dependency>
  115.  
  116.         <!--spring-session将session借助于第三方存储（redis/mongodb等等），默认redis-->
  117.         <!--<dependency>
  118.             <groupId>org.springframework.session</groupId>
  119.             <artifactId>spring-session-data-redis</artifactId>
  120.         </dependency>-->
  121.         <dependency>
  122.             <groupId>com.alipay.sdk</groupId>
  123.             <artifactId>alipay-easysdk</artifactId>
  124.             <version>2.0.1</version>
  125.         </dependency>
  126.     </dependencies>
  127.  
  128.     <build>
  129.         <plugins>
  130.             <plugin>
  131.                 <groupId>org.springframework.boot</groupId>
  132.                 <artifactId>spring-boot-maven-plugin</artifactId>
  133.             </plugin>
  134.         </plugins>
  135.     </build>
  136.  
  137. </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.      * <p>
  21.      * 读取控制台内容
  22.      * </p>
  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<FileOutConfig> 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;
  10. </#if>
  11. <#if superControllerClassPackage??>
  12. import ${superControllerClassPackage};
  13. </#if>
  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
  27. </#if>
  28. @RequestMapping("<#if package.ModuleName?? && package.ModuleName != "">/${package.ModuleName}</#if>/<#if controllerMappingHyphenStyle??>${controllerMappingHyphen}<#else>${table.entityPath}</#if>")
  29. <#if kotlin>
  30. class ${table.controllerName}<#if superControllerClass??> : ${superControllerClass}()</#if>
  31. <#else>
  32. <#if superControllerClass??>
  33. public class ${table.controllerName} extends ${superControllerClass} {
  34. <#else>
  35. public class ${table.controllerName} {
  36. </#if>
  37.  
  38. }
  39. </#if>

entity2.java.ftl

  1. package ${package.Entity};
  2.  
  3. <#list table.importPackages as pkg>
  4. import ${pkg};
  5. </#list>
  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.  * <p>
  20.  * ${table.comment!}
  21.  * </p>
  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};
  98. </#list>
  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.     </#list>
  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.     </#list>
  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.     </#list>
  153.         "}";
  154.     }
  155. </#if>
  156. }

mapper2.java.ftl

  1. package ${package.Mapper};
  2.  
  3. import ${package.Entity}.${entity};
  4. import ${superMapperClassPackage};
  5.  
  6. /**
  7.  * <p>
  8.  * ${table.comment!} Mapper 接口
  9.  * </p>
  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. <?xml version="1.0" encoding="UTF-8"?>
  2. <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  3. <mapper namespace="${package.Mapper}.${table.mapperName}">
  4.  
  5. <#if enableCache>
  6.     <!-- 开启二级缓存 -->
  7.     <cache type="org.mybatis.caches.ehcache.LoggingEhcache"/>
  8.  
  9. </#if>
  10. <#if baseResultMap>
  11.     <!-- 通用查询映射结果 -->
  12.     <resultMap id="BaseResultMap" type="${package.Entity}.${entity}">
  13. <#list table.fields as field>
  14. <#if field.keyFlag><#--生成主键排在第一位-->
  15.         <id column="${field.name}" property="${field.propertyName}" />
  16. </#if>
  17. </#list>
  18. <#list table.commonFields as field><#--生成公共字段 -->
  19.         <result column="${field.name}" property="${field.propertyName}" />
  20. </#list>
  21. <#list table.fields as field>
  22. <#if !field.keyFlag><#--生成普通字段 -->
  23.         <result column="${field.name}" property="${field.propertyName}" />
  24. </#if>
  25. </#list>
  26.     </resultMap>
  27.  
  28. </#if>
  29. <#if baseColumnList>
  30.     <!-- 通用查询结果列 -->
  31.     <sql id="Base_Column_List">
  32. <#list table.commonFields as field>
  33.         ${field.columnName},
  34. </#list>
  35.         ${table.fieldNames}
  36.     </sql>
  37.  
  38. </#if>
  39. </mapper>

service2.java.ftl

  1. package ${package.Service};
  2.  
  3. import ${package.Entity}.${entity};
  4. import ${superServiceClassPackage};
  5.  
  6. /**
  7.  * <p>
  8.  * ${table.comment!} 服务类
  9.  * </p>
  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.  * <p>
  11.  * ${table.comment!} 服务实现类
  12.  * </p>
  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<Goods> goods01 = goodsService.list(new QueryWrapper<Goods>().eq("goods_type", "01").last("limit 6"));
  33.         List<Goods> goods07 = goodsService.list(new QueryWrapper<Goods>().eq("goods_type", "07").last("limit 12"));
  34. //        将数据转换成容易在页面上进行展现的数据格式
  35.         DataUtils<Goods> dataUtils = new DataUtils<>();
  36.         Map<String, List<Goods>> gt01 = dataUtils.transfor(3, goods01);
  37.         Map<String, List<Goods>> 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. <!DOCTYPE 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. 		<!------------------------------head------------------------------>
  10. 		<#include "common/top.html">
  11.  
  12. 		<!-------------------------banner--------------------------->
  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. 		<!------------------------------thImg------------------------------>
  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. 		<!------------------------------news------------------------------>
  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. 					<!--遍历中的所有的key，是为了拿该key中的对象-->
  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. 				</#list>
  71. 			</div>
  72. 		</#list>
  73. 	</#if>
  74.  
  75. 				<!--<div class="flower clearfix tran">
  76. 					<a href="proDetail.html" class="clearfix">
  77. 						<dl>
  78. 							<dt>
  79. 								<span class="abl"></span>
  80. 								<img src="img/flo1.jpg"/>
  81. 								<span class="abr"></span>
  82. 							</dt>
  83. 							<dd>【花艺】七头美丽玫瑰仿真花束</dd>
  84. 							<dd><span>¥ 79.00</span></dd>
  85. 						</dl>
  86. 					</a>
  87. 					<a href="proDetail.html">
  88. 						<dl>
  89. 							<dt>
  90. 								<span class="abl"></span>
  91. 								<img src="img/flo2.jpg"/>
  92. 								<span class="abr"></span>
  93. 							</dt>
  94. 							<dd>【花艺】七头美丽玫瑰仿真花束</dd>
  95. 							<dd><span>¥ 79.00</span></dd>
  96. 						</dl>
  97. 					</a>
  98. 					<a href="proDetail.html">
  99. 						<dl>
  100. 							<dt>
  101. 								<span class="abl"></span>
  102. 								<img src="img/flo3.jpg"/>
  103. 								<span class="abr"></span>
  104. 							</dt>
  105. 							<dd>【花艺】七头美丽玫瑰仿真花束</dd>
  106. 							<dd><span>¥ 79.00</span></dd>
  107. 						</dl>
  108. 					</a>
  109. 				</div>-->
  110. 			</div>
  111. 		</div>
  112. 		
  113. 		<!------------------------------ad------------------------------>
  114. 		<a href="#" class="ad"><img src="img/ib1.jpg"/></a>
  115. 		
  116. 		<!------------------------------people------------------------------>
  117. 		<div class="people">
  118. 			<div class="wrapper">
  119. 				<h2><img src="img/ih3.jpg"/></h2>
  120. 				<div class="pList clearfix tran">
  121. 					<a href="proDetail.html">
  122. 						<dl>
  123. 							<dt>
  124. 								<span class="abl"></span>
  125. 								<img src="img/s7.jpg"/>
  126. 								<span class="abr"></span>
  127. 							</dt>
  128. 							<dd>【最家】不锈钢壁饰墙饰软装</dd>
  129. 							<dd><span>￥688.00</span></dd>
  130. 						</dl>
  131. 					</a>
  132. 					<a href="proDetail.html">
  133. 						<dl>
  134. 							<dt>
  135. 								<span class="abl"></span>
  136. 								<img src="img/s10.jpg"/>
  137. 								<span class="abr"></span>
  138. 							</dt>
  139. 							<dd>【最家】小城动物木板画壁挂北欧</dd>
  140. 							<dd><span>￥188.00</span></dd>
  141. 						</dl>
  142. 					</a>
  143. 					<a href="proDetail.html">
  144. 						<dl>
  145. 							<dt>
  146. 								<span class="abl"></span>
  147. 								<img src="img/s4.jpg"/>
  148. 								<span class="abr"></span>
  149. 							</dt>
  150. 							<dd>【最家】玄关假山水壁饰背景墙饰挂件创意</dd>
  151. 							<dd><span>￥599.00</span></dd>
  152. 						</dl>
  153. 					</a>
  154. 					<a href="proDetail.html">
  155. 						<dl>
  156. 							<dt>
  157. 								<span class="abl"></span>
  158. 								<img src="img/s9.jpg"/>
  159. 								<span class="abr"></span>
  160. 							</dt>
  161. 							<dd>【最家】金属树枝壁饰铜鸟装饰品</dd>
  162. 							<dd><span>￥928.00</span></dd>
  163. 						</dl>
  164. 					</a>
  165. 				</div>
  166. 				<div class="pList clearfix tran">
  167. 					<a href="proDetail.html">
  168. 						<dl>
  169. 							<dt>
  170. 								<span class="abl"></span>
  171. 								<img src="img/s6.jpg"/>
  172. 								<span class="abr"></span>
  173. 							</dt>
  174. 							<dd>【最家】金属壁饰创意背景墙面挂件创意</dd>
  175. 							<dd><span>￥228.00</span></dd>
  176. 						</dl>
  177. 					</a>
  178. 					<a href="proDetail.html">
  179. 						<dl>
  180. 							<dt>
  181. 								<span class="abl"></span>
  182. 								<img src="img/s8.jpg"/>
  183. 								<span class="abr"></span>
  184. 							</dt>
  185. 							<dd>【最家】小城动物木板画壁挂北欧</dd>
  186. 							<dd><span>￥199.00</span></dd>
  187. 						</dl>
  188. 					</a>
  189. 					<a href="proDetail.html">
  190. 						<dl>
  191. 							<dt>
  192. 								<span class="abl"></span>
  193. 								<img src="img/s12.jpg"/>
  194. 								<span class="abr"></span>
  195. 							</dt>
  196. 							<dd>【最家】欧式复古挂钟创意餐厅钟表家居挂件</dd>
  197. 							<dd><span>￥666.00</span></dd>
  198. 						</dl>
  199. 					</a>
  200. 					<a href="proDetail.html">
  201. 						<dl>
  202. 							<dt>
  203. 								<span class="abl"></span>
  204. 								<img src="img/s1.jpg"/>
  205. 								<span class="abr"></span>
  206. 							</dt>
  207. 							<dd>【最家】客厅地中海欧式现代相片墙创意</dd>
  208. 							<dd><span>￥59.80</span></dd>
  209. 						</dl>
  210. 					</a>
  211. 				</div>
  212. 				<div class="pList clearfix tran">
  213. 					<a href="proDetail.html">
  214. 						<dl>
  215. 							<dt>
  216. 								<span class="abl"></span>
  217. 								<img src="img/s5.jpg"/>
  218. 								<span class="abr"></span>
  219. 							</dt>
  220. 							<dd>【最家】铁艺荷叶壁挂软装背景墙上装饰品</dd>
  221. 							<dd><span>￥800.00</span></dd>
  222. 						</dl>
  223. 					</a>
  224. 					<a href="proDetail.html">
  225. 						<dl>
  226. 							<dt>
  227. 								<span class="abl"></span>
  228. 								<img src="img/s3.jpg"/>
  229. 								<span class="abr"></span>
  230. 							</dt>
  231. 							<dd>【最家】欧式照片墙 创意组合结婚礼物</dd>
  232. 							<dd><span>￥189.00</span></dd>
  233. 						</dl>
  234. 					</a>
  235. 					<a href="proDetail.html">
  236. 						<dl>
  237. 							<dt>
  238. 								<span class="abl"></span>
  239. 								<img src="img/s2.jpg"/>
  240. 								<span class="abr"></span>
  241. 							</dt>
  242. 							<dd>【最家】欧式钟表相框墙挂墙创意组合</dd>
  243. 							<dd><span>￥148.00</span></dd>
  244. 						</dl>
  245. 					</a>
  246. 					<a href="proDetail.html">
  247. 						<dl>
  248. 							<dt>
  249. 								<span class="abl"></span>
  250. 								<img src="img/s11.jpg"/>
  251. 								<span class="abr"></span>
  252. 							</dt>
  253. 							<dd>【最家】小城动物木板画壁挂北欧</dd>
  254. 							<dd><span>￥188.00</span></dd>
  255. 						</dl>
  256. 					</a>
  257. 				</div>
  258. 			</div>
  259. 		</div>
  260.  
  261. 		<#include "common/footer.html"/>
  262.  
  263. 		<script src="js/public.js" type="text/javascript" charset="utf-8"></script>
  264. 		<script src="js/nav.js" type="text/javascript" charset="utf-8"></script>
  265. 		<script src="js/jquery.flexslider-min.js" type="text/javascript" charset="utf-8"></script>
  266. 		<script type="text/javascript">
  267. 			$(function() {
  268. 				$('#home_slider').flexslider({
  269. 					animation: 'slide',
  270. 					controlNav: true,
  271. 					directionNav: true,
  272. 					animationLoop: true,
  273. 					slideshow: true,
  274. 					slideshowSpeed:2000,
  275. 					useCSS: false
  276. 				});
  277.  
  278. 			});
  279. 		</script>
  280. 	</body>
  281. </html>

运行结果：

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

将页面的展示格式改变

index.html

  1. <!DOCTYPE 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. 		<!------------------------------head------------------------------>
  10. 		<#include "common/top.html">
  11.  
  12. 		<!-------------------------banner--------------------------->
  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. 		<!------------------------------thImg------------------------------>
  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. 		<!------------------------------news------------------------------>
  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. 					<!--遍历中的所有的key，是为了拿该key中的对象-->
  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. 				</#list>
  71. 			</div>
  72. 		</#list>
  73. 	</#if>
  74.  
  75. 				<!--<div class="flower clearfix tran">
  76. 					<a href="proDetail.html" class="clearfix">
  77. 						<dl>
  78. 							<dt>
  79. 								<span class="abl"></span>
  80. 								<img src="img/flo1.jpg"/>
  81. 								<span class="abr"></span>
  82. 							</dt>
  83. 							<dd>【花艺】七头美丽玫瑰仿真花束</dd>
  84. 							<dd><span>¥ 79.00</span></dd>
  85. 						</dl>
  86. 					</a>
  87. 					<a href="proDetail.html">
  88. 						<dl>
  89. 							<dt>
  90. 								<span class="abl"></span>
  91. 								<img src="img/flo2.jpg"/>
  92. 								<span class="abr"></span>
  93. 							</dt>
  94. 							<dd>【花艺】七头美丽玫瑰仿真花束</dd>
  95. 							<dd><span>¥ 79.00</span></dd>
  96. 						</dl>
  97. 					</a>
  98. 					<a href="proDetail.html">
  99. 						<dl>
  100. 							<dt>
  101. 								<span class="abl"></span>
  102. 								<img src="img/flo3.jpg"/>
  103. 								<span class="abr"></span>
  104. 							</dt>
  105. 							<dd>【花艺】七头美丽玫瑰仿真花束</dd>
  106. 							<dd><span>¥ 79.00</span></dd>
  107. 						</dl>
  108. 					</a>
  109. 				</div>-->
  110. 			</div>
  111. 		</div>
  112. 		
  113. 		<!------------------------------ad------------------------------>
  114. 		<a href="#" class="ad"><img src="img/ib1.jpg"/></a>
  115. 		
  116. 		<!------------------------------people------------------------------>
  117. 		<div class="people">
  118. 			< class="wrapper">
  119. 				<h2><img src="img/ih3.jpg"/></h2>
  120. 				<#if gt07?? && gt07?size gt 0>
  121. 				<#list gt07?keys as key>
  122. 			<div class="pList clearfix tran">
  123. 				<#list gt07[key] as g>
  124. 				<a href="proDetail.html">
  125. 					<dl>
  126. 						<dt>
  127. 							<span class="abl"></span>
  128. 							<img src="${g.goodsImg}"/>
  129. 							<span class="abr"></span>
  130. 						</dt>
  131. 						<dd>${g.goodsName}</dd>
  132. 						<dd><span>￥ ${g.goodsPrice}</span></dd>
  133. 					</dl>
  134. 				</a>
  135. 		</#list>
  136. 		</div>
  137. </#list>
  138. </#if>
  139.  
  140. 			</div>
  141. 		</div>
  142.  
  143. 		<#include "common/footer.html"/>
  144.  
  145. 		<script src="js/public.js" type="text/javascript" charset="utf-8"></script>
  146. 		<script src="js/nav.js" type="text/javascript" charset="utf-8"></script>
  147. 		<script src="js/jquery.flexslider-min.js" type="text/javascript" charset="utf-8"></script>
  148. 		<script type="text/javascript">
  149. 			$(function() {
  150. 				$('#home_slider').flexslider({
  151. 					animation: 'slide',
  152. 					controlNav: true,
  153. 					directionNav: true,
  154. 					animationLoop: true,
  155. 					slideshow: true,
  156. 					slideshowSpeed:2000,
  157. 					useCSS: false
  158. 				});
  159.  
  160. 			});
  161. 		</script>
  162. 	</body>
  163. </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.  * <p>
  18.  * 用户信息表 前端控制器
  19.  * </p>
  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.  * <p>
  13.  * 用户信息表 服务类
  14.  * </p>
  15.  *
  16.  * @author cdl
  17.  * @since 2022-11-05
  18.  */
  19. public interface IUserService extends IService<User> {
  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.  * <p>
  20.  * 用户信息表 服务实现类
  21.  * </p>
  22.  *
  23.  * @author cdl
  24.  * @since 2022-11-05
  25.  */
  26. @Service
  27. public class UserServiceImpl extends ServiceImpl<UserMapper, User> 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<User>()
  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.  * <p>
  21.  * 用户信息表 服务实现类
  22.  * </p>
  23.  *
  24.  * @author cdl
  25.  * @since 2022-11-05
  26.  */
  27. @Service
  28. public class UserServiceImpl extends ServiceImpl<UserMapper, User> 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<User>()
  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. <!DOCTYPE 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. 		<!-------------------login-------------------------->
  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.  * <p>
  24.  * 用户信息表 服务实现类
  25.  * </p>
  26.  *
  27.  * @author cdl
  28.  * @since 2022-11-05
  29.  */
  30. @Service
  31. public class UserServiceImpl extends ServiceImpl<UserMapper, User> 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<User>()
  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<String,Object> 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<T> 

  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<T> {
  9.     /**
  10.      * 转换方法，基于商品的排版情况（一行三列、一行四列等等）进行数据分行处理
  11.      * @param cols  一行显示几列
  12.      * @param goods 需要筛选的数据集
  13.      * @return
  14.      */
  15.     public Map<String, List<T>> transfor(int cols, List<T> goods){
  16.         Map<String,List<T>> data=new HashMap<>();
  17.         List<T> 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<T>

  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<T> 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<String,String[]> map;
  21. 	
  22. 	public String getUrl() {
  23. 		return url;
  24. 	}
  25. 	public void setUrl(String url) {
  26. 		this.url = url;
  27. 	}
  28. 	public Map<String, String[]> getMap() {
  29. 		return map;
  30. 	}
  31. 	public void setMap(Map<String, String[]> 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<String,String[]> 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. }

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

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

  

闽ICP备14008679号