• 在线教育项目【老师服务】

    目录

    1.传智在线项目

    1.1功能简介

    1.2系统模块

    1.3系统架构

    2.数据库设计

    2.1 数据库

    2.2 数据表

    3.创建项目

    3.1 项目架构

    3.2 创建父项目：zx_parent_practise

    3.3:创建子项目：zx_common_practise

    3.4:创建子项目：zx_domain_practise

    3.5:创建子项目：zx_geteway

    3.6:创建子项目：zx_service_teacher

    4，老师模块的前置工作：

    4.1：JavaBean

    4.2：mapper

    4.3：service

    4.4：controller

    4.5：拷贝配置类

    4.6：访问swagger

    5，功能：老师的逻辑删除

    5.1：controller逻辑删除方法

    5.2：逻辑删除注解

    5.3：配置handler：进行异步消息处理

    5.4：配置application.yml文件

    5.5：在swagger中测试该方法

    6，功能：条件查询和分页

    6.1：Controller

    6.2：Service

    7，功能：添加老师，修改老师

    7.1：添加配置类：进行添加和修改时间的填充

    7.2：添加老师

    7.2.1：Controller

    7.2.2：Service

    7.3：修改老师

    7.3.1：Controller

    7.3.2：Service

    8，功能：删除老师，查询老师，批量删除老师

    8.1：删除老师

    8.1.1：Controller

    8.1.2：Service

    8.2：修改老师

    8.2.1：Controller

    8.2.2：Service

    8.3：修改老师

    8.3.1：Controller

    8.3.2：Service

    总结

    1.传智在线项目

    1.1功能简介

    • 做的什么模块？

      • 整个项目分为两大部分：前台部分、后台部分

      • 前台部分：为用户使用部分，可以进行视频的购买与学习。

      • 后台部分：为管理操作部分，进行视频上传与维护。

      • 本课程主要完成的是后台部分。

    • 用到什么技术？

      • 后端：SpringCloud alibaba核心组件Nacos+SSM+mybatis-plus+swagger-ui+POI+Redis + JavaMail +RabbitMQ+EasyExcel.....

      • 前端：Vue全家桶：Vue+Vue-Router+Vuex+SPA + element ui admin

    1.2系统模块

    1.3系统架构

    • 前后端分离开发：

      • 解耦

      • 后端和前端完全分离，并且后台接口可以供给多端使用！（APP，微信，PC，WAP）（Restful风格的接口可以给任何应用去使用）

    2.数据库设计

    2.1 数据库

    zx_edu_course：课程相关的库

    zx_edu_teacher：老师板块相关的库

    zx_edu_user:登录用户相关的库

    zx_edu_vod:视频相关的库


    2.2 数据表

     本章主要记录学习中：老师后端的增删改查（用到了该表）

    3.创建项目

    3.1 项目架构

    项目结构图：

    3.2 创建父项目：zx_parent_practise

     在pom.xml中导入依赖

    1. "1.0" encoding="UTF-8"?>
    2. <project xmlns="http://maven.apache.org/POM/4.0.0"
    3.          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    4.          xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    5.     <modelVersion>4.0.0modelVersion>
    6.  
    7.     <groupId>com.czxy.zxgroupId>
    8.     <artifactId>zx_parent_practiseartifactId>
    9.     <packaging>pompackaging>
    10.     <version>1.0-SNAPSHOTversion>
    11.     <modules>
    12.         <module>zx_common_practisemodule>
    13.         <module>zx_domain_practisemodule>
    14.         <module>zx_gatewaymodule>
    15.         <module>zx_service_teachermodule>
    16.     modules>
    17.  
    18.     <properties>
    19.         <maven.compiler.source>8maven.compiler.source>
    20.         <maven.compiler.target>8maven.compiler.target>
    21.         <project.build.sourceEncoding>UTF-8project.build.sourceEncoding>
    22.         <java.version>1.8java.version>
    23.         <spring-cloud-release.version>Hoxton.SR3spring-cloud-release.version>
    24.         <nacos.version>1.1.0nacos.version>
    25.         <alibaba.cloud.version>2.2.1.RELEASEalibaba.cloud.version>
    26.         <mysql.version>5.1.32mysql.version>
    27.         <mybatis.plus.version>3.4.0mybatis.plus.version>
    28.         <druid.starter.version>1.1.9druid.starter.version>
    29.         <jwt.jjwt.version>0.9.0jwt.jjwt.version>
    30.         <jwt.joda.version>2.9.7jwt.joda.version>
    31.         <swagger.version>2.7.0swagger.version>
    32.         <swagger.anno.version>1.5.13swagger.anno.version>
    33.         <beanutils.version>1.9.3beanutils.version>
    34.         <aliyun.sdk.core.version>3.3.1aliyun.sdk.core.version>
    35.         <aliyun.sdk.dysmsapi.version>1.0.0aliyun.sdk.dysmsapi.version>
    36.         <fastjson.version>1.2.9fastjson.version>
    37.         <zx.version>1.0-SNAPSHOTzx.version>
    38.     properties>
    39.     
    40.     <parent>
    41.         <groupId>org.springframework.bootgroupId>
    42.         <artifactId>spring-boot-starter-parentartifactId>
    43.         <version>2.2.5.RELEASEversion>
    44.     parent>
    45.     
    46.     <dependencyManagement>
    47.         <dependencies>
    48.             
    49.             <dependency>
    50.                 <groupId>org.springframework.cloudgroupId>
    51.                 <artifactId>spring-cloud-dependenciesartifactId>
    52.                 <version>${spring-cloud-release.version}version>
    53.                 <type>pomtype>
    54.                 <scope>importscope>
    55.             dependency>
    56.             
    57.             <dependency>
    58.                 <groupId>com.alibaba.nacosgroupId>
    59.                 <artifactId>nacos-clientartifactId>
    60.                 <version>${nacos.version}version>
    61.             dependency>
    62.  
    63.             
    64.             <dependency>
    65.                 <groupId>com.alibaba.cloudgroupId>
    66.                 <artifactId>spring-cloud-starter-alibaba-nacos-discoveryartifactId>
    67.                 <version>${alibaba.cloud.version}version>
    68.             dependency>
    69.  
    70.             
    71.             <dependency>
    72.                 <groupId>com.alibaba.cloudgroupId>
    73.                 <artifactId>spring-cloud-starter-alibaba-nacos-configartifactId>
    74.                 <version>${alibaba.cloud.version}version>
    75.             dependency>
    76.  
    77.             
    78.             <dependency>
    79.                 <groupId>com.alibaba.cloudgroupId>
    80.                 <artifactId>spring-cloud-starter-alibaba-sentinelartifactId>
    81.                 <version>${alibaba.cloud.version}version>
    82.             dependency>
    83.  
    84.             <dependency>
    85.                 <groupId>com.alibaba.cloudgroupId>
    86.                 <artifactId>spring-cloud-starter-alibaba-seataartifactId>
    87.                 <version>${alibaba.cloud.version}version>
    88.             dependency>
    89.  
    90.  
    91.             
    92.             <dependency>
    93.                 <groupId>com.baomidougroupId>
    94.                 <artifactId>mybatis-plus-boot-starterartifactId>
    95.                 <version>${mybatis.plus.version}version>
    96.             dependency>
    97.             <dependency>
    98.                 <groupId>com.baomidougroupId>
    99.                 <artifactId>mybatis-plus-annotationartifactId>
    100.                 <version>${mybatis.plus.version}version>
    101.             dependency>
    102.  
    103.             
    104.             <dependency>
    105.                 <groupId>mysqlgroupId>
    106.                 <artifactId>mysql-connector-javaartifactId>
    107.                 <version>${mysql.version}version>
    108.             dependency>
    109.  
    110.             
    111.             <dependency>
    112.                 <groupId>com.alibabagroupId>
    113.                 <artifactId>druid-spring-boot-starterartifactId>
    114.                 <version>${druid.starter.version}version>
    115.             dependency>
    116.  
    117.             
    118.             <dependency>
    119.                 <groupId>io.springfoxgroupId>
    120.                 <artifactId>springfox-swagger2artifactId>
    121.                 <version>${swagger.version}version>
    122.             dependency>
    123.             <dependency>
    124.                 <groupId>io.springfoxgroupId>
    125.                 <artifactId>springfox-swagger-uiartifactId>
    126.                 <version>${swagger.version}version>
    127.             dependency>
    128.             <dependency>
    129.                 <groupId>io.swaggergroupId>
    130.                 <artifactId>swagger-annotationsartifactId>
    131.                 <version>${swagger.anno.version}version>
    132.             dependency>
    133.  
    134.             
    135.             
    136.             <dependency>
    137.                 <groupId>commons-beanutilsgroupId>
    138.                 <artifactId>commons-beanutilsartifactId>
    139.                 <version>${beanutils.version}version>
    140.             dependency>
    141.  
    142.             
    143.             <dependency>
    144.                 <groupId>io.jsonwebtokengroupId>
    145.                 <artifactId>jjwtartifactId>
    146.                 <version>${jwt.jjwt.version}version>
    147.             dependency>
    148.  
    149.             
    150.             <dependency>
    151.                 <groupId>joda-timegroupId>
    152.                 <artifactId>joda-timeartifactId>
    153.                 <version>${jwt.joda.version}version>
    154.             dependency>
    155.  
    156.             
    157.             <dependency>
    158.                 <groupId>com.aliyuncsgroupId>
    159.                 <artifactId>aliyun-java-sdk-coreartifactId>
    160.                 <version>${aliyun.sdk.core.version}version>
    161.             dependency>
    162.             <dependency>
    163.                 <groupId>com.aliyuncs.dysmsapigroupId>
    164.                 <artifactId>aliyun-java-sdk-dysmsapiartifactId>
    165.                 <version>${aliyun.sdk.dysmsapi.version}version>
    166.             dependency>
    167.  
    168.             
    169.             <dependency>
    170.                 <groupId>com.alibabagroupId>
    171.                 <artifactId>fastjsonartifactId>
    172.                 <version>${fastjson.version}version>
    173.             dependency>
    174.             
    175.             <dependency>
    176.                 <groupId>com.czxy.zxgroupId>
    177.                 <artifactId>zx_common_practiseartifactId>
    178.                 <version>${zx.version}version>
    179.             dependency>
    180.             <dependency>
    181.                 <groupId>com.czxy.zxgroupId>
    182.                 <artifactId>zx_domain_practiseartifactId>
    183.                 <version>${zx.version}version>
    184.             dependency>
    185.  
    186.         dependencies>
    187.  
    188.     dependencyManagement>
    189. project>

    3.3:创建子项目：zx_common_practise

    在pom.xml文件中导入依赖

    1.  <dependencies>
    2.         <dependency>
    3.             <groupId>org.springframework.bootgroupId>
    4.             <artifactId>spring-boot-starter-webartifactId>
    5.         dependency>
    6.         
    7.         <dependency>
    8.             <groupId>org.projectlombokgroupId>
    9.             <artifactId>lombokartifactId>
    10.         dependency>
    11.         
    12.         <dependency>
    13.             <groupId>io.springfoxgroupId>
    14.             <artifactId>springfox-swagger2artifactId>
    15.         dependency>
    16.         <dependency>
    17.             <groupId>io.springfoxgroupId>
    18.             <artifactId>springfox-swagger-uiartifactId>
    19.         dependency>
    20.         
    21.         <dependency>
    22.             <groupId>io.jsonwebtokengroupId>
    23.             <artifactId>jjwtartifactId>
    24.         dependency>
    25.         
    26.         <dependency>
    27.             <groupId>joda-timegroupId>
    28.             <artifactId>joda-timeartifactId>
    29.         dependency>
    30.         
    31.         <dependency>
    32.             <groupId>commons-beanutilsgroupId>
    33.             <artifactId>commons-beanutilsartifactId>
    34.         dependency>
    35.         
    36.         <dependency>
    37.             <groupId>com.aliyungroupId>
    38.             <artifactId>aliyun-java-sdk-coreartifactId>
    39.             <version>4.5.1version>
    40.         dependency>
    41.         <dependency>
    42.             <groupId>com.aliyun.ossgroupId>
    43.             <artifactId>aliyun-sdk-ossartifactId>
    44.             <version>3.10.2version>
    45.         dependency>
    46.         <dependency>
    47.             <groupId>com.aliyungroupId>
    48.             <artifactId>aliyun-java-sdk-vodartifactId>
    49.             <version>2.15.11version>
    50.         dependency>
    51.         <dependency>
    52.             <groupId>com.alibabagroupId>
    53.             <artifactId>fastjsonartifactId>
    54.             <version>1.2.28version>
    55.         dependency>
    56.         <dependency>
    57.             <groupId>org.jsongroupId>
    58.             <artifactId>jsonartifactId>
    59.             <version>20170516version>
    60.         dependency>
    61.         <dependency>
    62.             <groupId>com.google.code.gsongroupId>
    63.             <artifactId>gsonartifactId>
    64.             <version>2.8.2version>
    65.         dependency>
    66.  
    67.         <dependency>
    68.             <groupId>com.aliyungroupId>
    69.             <artifactId>aliyun-sdk-vod-uploadartifactId>
    70.             <version>1.4.13version>
    71.         dependency>
    72.     dependencies>

     导入通用的配置文件：异常，验证码动图，结果封装，邮件，视频工具类等等

    3.4:创建子项目：zx_domain_practise

    依赖：

    1.  <dependencies>
    2.         
    3.         <dependency>
    4.             <groupId>io.swaggergroupId>
    5.             <artifactId>swagger-annotationsartifactId>
    6.             <version>1.5.13version>
    7.         dependency>
    8.         <dependency>
    9.             <groupId>org.projectlombokgroupId>
    10.             <artifactId>lombokartifactId>
    11.         dependency>
    12.         
    13.         <dependency>
    14.             <groupId>org.springframework.bootgroupId>
    15.             <artifactId>spring-boot-starter-jsonartifactId>
    16.         dependency>
    17.         
    18.         <dependency>
    19.             <groupId>com.baomidougroupId>
    20.             <artifactId>mybatis-plus-annotationartifactId>
    21.         dependency>
    22.     dependencies>

    3.5:创建子项目：zx_geteway

    依赖：

    1.  <dependencies>
    2.         
    3.         <dependency>
    4.             <groupId>org.springframework.cloudgroupId>
    5.             <artifactId>spring-cloud-starter-gatewayartifactId>
    6.         dependency>
    7.  
    8.         
    9.         <dependency>
    10.             <groupId>com.alibaba.cloudgroupId>
    11.             <artifactId>spring-cloud-starter-alibaba-nacos-discoveryartifactId>
    12.         dependency>
    13.  
    14.     dependencies>

     application.yml:在yml文件中配置一下网关,目的访问其他服务，统一经过网关进行访问

    端口：10010

    1. #端口号
    2. server:
    3.   port: 10010
    4. spring:
    5.   application:
    6.     name: zx-gateway
    7.   servlet:
    8.     multipart:
    9.       max-file-size: 2MB    #上传文件的大小
    10.   cloud:
    11.     nacos:
    12.       discovery:
    13.         server-addr: 127.0.0.1:8848   #nacos服务地址
    14.     gateway:
    15.       discovery:
    16.         locator:
    17.           enabled: true               #开启服务注册和发现的功能，自动创建router以服务名开头的请求路径转发到对应的服务
    18.           lowerCaseServiceId: true    #将请求路径上的服务名配置为小写
    19. sc:
    20.   jwt:
    21.     secret: sc@Login(Auth}*^31)&czxy% # 登录校验的密钥
    22.     pubKeyPath: D:/rsa/rsa.pub # 公钥地址
    23.     priKeyPath: D:/rsa/rsa.pri # 私钥地址
    24.     expire: 360 # 过期时间,单位分钟
    25.   filter:
    26.     allowPaths:
    27.       - swagger
    28.       - /api-docs
    29.       - /user/login
    30.       - /user/info
    31.       - /user/register
    32.       - /user/sendemail
    33.       - /user/active
    34.       - /verifycode

     导入跨域处理类：前端访问后端时会出现跨域的错误，该配置类进行处理

    1. @Configuration
    2. public class GlobalCorsConfig {
    3.  
    4.     @Bean
    5.     public WebFilter corsFilter2() {
    6.         return (ServerWebExchange ctx, WebFilterChain chain) -> {
    7.             ServerHttpRequest request = ctx.getRequest();
    8.             if (CorsUtils.isCorsRequest(request)) {
    9.                 HttpHeaders requestHeaders = request.getHeaders();
    10.                 ServerHttpResponse response = ctx.getResponse();
    11.                 HttpMethod requestMethod = requestHeaders.getAccessControlRequestMethod();
    12.                 HttpHeaders headers = response.getHeaders();
    13.                 headers.add(HttpHeaders.ACCESS_CONTROL_ALLOW_ORIGIN, requestHeaders.getOrigin());
    14.                 headers.addAll(HttpHeaders.ACCESS_CONTROL_ALLOW_HEADERS,
    15.                         requestHeaders.getAccessControlRequestHeaders());
    16.                 if (requestMethod != null) {
    17.                     headers.add(HttpHeaders.ACCESS_CONTROL_ALLOW_METHODS, requestMethod.name());
    18.                 }
    19.                 headers.add(HttpHeaders.ACCESS_CONTROL_ALLOW_CREDENTIALS, "true");
    20.                 headers.add(HttpHeaders.ACCESS_CONTROL_EXPOSE_HEADERS, "*");
    21.                 if (request.getMethod() == HttpMethod.OPTIONS) {
    22.                     response.setStatusCode(HttpStatus.OK);
    23.                     return Mono.empty();
    24.                 }
    25.             }
    26.             return chain.filter(ctx);
    27.         };
    28.     }
    29.

    配置网关：启动类

    1.  
    2. @SpringBootApplication
    3. //配置服务发现
    4. @EnableDiscoveryClient
    5. public class GatewayApplication {
    6.     public static void main(String[] args) {
    7.         SpringApplication.run(GatewayApplication.class,args);
    8.     }
    9. }

    3.6:创建子项目：zx_service_teacher

    老师服务：今天主要的老师服务后端的增删改查

     导入依赖

    1.  <dependencies>
    2.         
    3.         <dependency>
    4.             <groupId>org.springframework.bootgroupId>
    5.             <artifactId>spring-boot-starter-webartifactId>
    6.         dependency>
    7.         
    8.         <dependency>
    9.             <groupId>com.alibaba.nacosgroupId>
    10.             <artifactId>nacos-clientartifactId>
    11.         dependency>
    12.  
    13.         
    14.         <dependency>
    15.             <groupId>com.alibaba.cloudgroupId>
    16.             <artifactId>spring-cloud-starter-alibaba-nacos-discoveryartifactId>
    17.         dependency>
    18.  
    19.         
    20.         <dependency>
    21.             <groupId>io.springfoxgroupId>
    22.             <artifactId>springfox-swagger2artifactId>
    23.         dependency>
    24.         <dependency>
    25.             <groupId>io.springfoxgroupId>
    26.             <artifactId>springfox-swagger-uiartifactId>
    27.         dependency>
    28.  
    29.         
    30.         <dependency>
    31.             <groupId>org.springframework.cloudgroupId>
    32.             <artifactId>spring-cloud-starter-openfeignartifactId>
    33.         dependency>
    34.  
    35.         
    36.         <dependency>
    37.             <groupId>org.springframework.bootgroupId>
    38.             <artifactId>spring-boot-starter-testartifactId>
    39.         dependency>
    40.  
    41.         
    42.         <dependency>
    43.             <groupId>com.baomidougroupId>
    44.             <artifactId>mybatis-plus-boot-starterartifactId>
    45.             <version>${mybatis.plus.version}version>
    46.         dependency>
    47.         
    48.         <dependency>
    49.             <groupId>mysqlgroupId>
    50.             <artifactId>mysql-connector-javaartifactId>
    51.         dependency>
    52.         
    53.         <dependency>
    54.             <groupId>com.czxy.zxgroupId>
    55.             <artifactId>zx_common_practiseartifactId>
    56.         dependency>
    57.         <dependency>
    58.             <groupId>com.czxy.zxgroupId>
    59.             <artifactId>zx_domain_practiseartifactId>
    60.         dependency>
    61.  
    62.         
    63.         <dependency>
    64.             <groupId>org.springframework.bootgroupId>
    65.             <artifactId>spring-boot-starter-data-redisartifactId>
    66.         dependency>
    67.         
    68.         <dependency>
    69.             <groupId>org.springframework.bootgroupId>
    70.             <artifactId>spring-boot-starter-mailartifactId>
    71.         dependency>
    72.         
    73.         <dependency>
    74.             <groupId>org.springframework.bootgroupId>
    75.             <artifactId>spring-boot-starter-amqpartifactId>
    76.         dependency>
    77.  
    78.         
    79.         <dependency>
    80.             <groupId>com.alibabagroupId>
    81.             <artifactId>fastjsonartifactId>
    82.         dependency>
    83.  
    84.         
    85.         <dependency>
    86.             <groupId>org.springframework.bootgroupId>
    87.             <artifactId>spring-boot-devtoolsartifactId>
    88.             <optional>trueoptional>
    89.         dependency>
    90.  
    91.     dependencies>

    配置application.yml

    # 服务端口号
server:
  port: 9999
# 服务名
spring:
  application:
    name: teacher-service
  datasource:
    driverClassName: com.mysql.jdbc.Driver
    url: jdbc:mysql://127.0.0.1:3306/zx_edu_teacher?useUnicode=true&characterEncoding=utf8
    username: root
    password: root
    druid:    #druid 连接池配置
      initial-size: 1       #初始化连接池大小
      min-idle: 1           #最小连接数
      max-active: 20        #最大连接数
      test-on-borrow: true  #获取连接时候验证，会影响性能
  cloud:
    nacos:
      discovery:
        server-addr: 127.0.0.1:8848   #nacos服务地址
  redis:
    database: 0       #数据库索引，取值0-15，表示16个库可选择
    host: 127.0.0.1   #服务器地址
    port: 6379        #服务器连接端口号
  mail:
    host: smtp.126.com          #发送邮件服务器
    username: itcast_lt@126.com #账号
    password: 1qaz2wsx          #密码
    default-encoding: UTF-8     #默认编码时
  rabbitmq:
    host: 127.0.0.1
    port: 5672
    username: guest
    password: guest
    virtualHost: /
  devtools:
    restart:
      enabled: true  #设置开启热部署
      additional-paths: src/main/java #重启目录
      exclude: WEB-INF/**
  freemarker:
    cache: false    #页面不加载缓存，修改即时生效

#开启log4j打印SQL语句
logging:
  level:
    com:
      czxy:
        zx:
          teacher:
            mapper: debug

# mp日志打印
mybatis-plus:
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
  global-config:
    db-config:
      logic-delete-value: 1
      logic-not-delete-value: 0 

    配置老师启动类：

    1. @SpringBootApplication
    2. @EnableDiscoveryClient
    3. @EnableFeignClients
    4. public class TeacherApplication {
    5.     public static void main(String[] args) {
    6.         SpringApplication.run(TeacherApplication.class,args);
    7.     }
    8. }

     @SpringBootApplication：来标注一个主程序类，说明这是一个Spring Boot应用
    @EnableDiscoveryClient：配置服务发现
    @EnableFeignClients：配置远程调用Feign

    4，老师模块的前置工作：

    4.1：JavaBean

     老师：JavaBean

    1. @Data//lombok注解
    2. @ApiModel(value = "EduTeacher对象",description = "讲师")//swagger注解
    3. public class EduTeacher {
    4.  
    5.     @TableId(value = "id",type = IdType.AUTO)//mybatis-plus的注解
    6.     @ApiModelProperty(value = "讲师ID")//swagger注解
    7.     private String id;
    8.     @ApiModelProperty(value = "讲师姓名")
    9.     private String name;
    10.     @ApiModelProperty(value = "讲师资历,一句话说明讲师")
    11.     private String intro;
    12.     @ApiModelProperty(value = "讲师简介")
    13.     private String career;
    14.     @ApiModelProperty(value = "头衔 1高级讲师 2首席讲师")
    15.     private Integer level;
    16.     @ApiModelProperty(value = "讲师头像")
    17.     private String avatar;
    18.     @ApiModelProperty(value = "讲师排序")
    19.     private Integer sort;
    20.     @ApiModelProperty(value = "逻辑删除 1已删除， 0未删除")
    21.     @TableField(value = "is_deleted",fill = FieldFill.INSERT)
    22.     @TableLogic//逻辑删除
    23.     private Integer isDeleted;
    24.     @ApiModelProperty(value = "创建时间")
    25.     @TableField(value = "gmt_create",fill = FieldFill.INSERT)
    26.     @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss",timezone = "GMT+8")
    27.     private Date gmtCreate;
    28.     @ApiModelProperty(value = "更新时间")
    29.     @TableField(value = "gmt_modified",fill = FieldFill.INSERT_UPDATE)
    30.     @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss",timezone = "GMT+8")
    31.     private Date gmtModified;
    32.  
    33. }

    4.2：mapper

    1. @Mapper
    2. public interface TeacherMapper extends BaseMapper {
    3. }

    4.3：service

    接口：

    1. public interface EduTeacherService extends IService {
    2.     Page condition(TeacherVo teacherVo, Integer current, Integer size);
    3. }

    实现类：

    1. @Service
    2. //开启事务管理
    3. @Transactional
    4. public class EduTeacherServiceImpl extends ServiceImpl implements EduTeacherService {
    5.  
    6.     @Override
    7.     public Page condition(TeacherVo teacherVo, Integer current, Integer size) {
    8.         //创建条件
    9.         QueryWrapper eduTeacherQueryWrapper = new QueryWrapper<>();
    10.         if (StringUtils.isNotBlank(teacherVo.getName())){
    11.             eduTeacherQueryWrapper.like("name",teacherVo.getName());
    12.         }
    13.         if (StringUtils.isNotBlank(teacherVo.getLevel())){
    14.             eduTeacherQueryWrapper.eq("level",teacherVo.getLevel());
    15.         }
    16.         if (StringUtils.isNotBlank(teacherVo.getBeginDate())){
    17.             eduTeacherQueryWrapper.ge("gmt_create",teacherVo.getBeginDate()+"00:00:00");
    18.         }
    19.         if (StringUtils.isNotBlank(teacherVo.getEndDate())){
    20.             eduTeacherQueryWrapper.le("gmt_create",teacherVo.getEndDate()+"00:00:00");
    21.         }
    22.         //分页
    23.         Page eduTeacherPage = new Page<>(current, size);
    24.         //查询
    25.         baseMapper.selectPage(eduTeacherPage,eduTeacherQueryWrapper);
    26.         return eduTeacherPage;
    27.     }
    28. }

    4.4：controller

    4.5：拷贝配置类

    一个是进行swagger测试的配置类

    一个是进行Mybatispus分页插件的配置类 

    4.6：访问swagger

    配置网关就通过：网关访问服务的方式进行访问swagger.ui.html

    通过网关访问的地址：http://localhost:10010/teacher-service/swagger-ui.html#/

     咱们再看一下直接访问老师服务地址：http://localhost:9999/swagger-ui.html

    ​

     两种都可以进行访问

    5，功能：老师的逻辑删除

    5.1：controller逻辑删除方法

    1.     @DeleteMapping("/{teacherid}")
    2.     @ApiOperation(value = "通过id删除老师")
    3.     public BaseResult deleteByid(@PathVariable("teacherid")Integer teacherid){
    4.         boolean flag = eduTeacherService.removeById(teacherid);
    5.         if (flag){
    6.             return BaseResult.ok("删除成功");
    7.         }else {
    8.             return BaseResult.error("删除失败");
    9.         }
    10.     }

    5.2：逻辑删除注解

    该注解在老师JavaBean中进行配置：

    ​

    1.  @ApiModelProperty(value = "逻辑删除 1已删除， 0未删除")  
    2. //这个注解属于swagger：用来标识
    3.     @TableField(value = "is_deleted",fill = FieldFill.INSERT)
    4. //用来进行填充默认数据
    5.     @TableLogic//逻辑删除
    6.     private Integer isDeleted;

    5.3：配置handler：进行异步消息处理

    ​

    1.  
    2. @Component
    3. public class TeacherMetaObjectHandler implements MetaObjectHandler {
    4.     @Override
    5.     public void insertFill(MetaObject metaObject) {
    6.         // 添加-自动填充数据
    7.         setFieldValByName("isDeleted", 0, metaObject);
    8.         // 添加时间、修改时间
    9.         setFieldValByName("gmtCreate", new Date(), metaObject);
    10.         setFieldValByName("gmtModified", new Date(), metaObject);
    11.     }
    12.  
    13.     @Override
    14.     public void updateFill(MetaObject metaObject) {
    15.         // 修改时间
    16.         setFieldValByName("gmtModified", new Date(), metaObject);
    17.     }
    18. }

    5.4：配置application.yml文件

    # mp日志打印
mybatis-plus:
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
  global-config:
    db-config:
      logic-delete-value: 1
#删除数据库中对应列的值为1
      logic-not-delete-value: 0

    #不删除数据库中对应的列值为0

    5.5：在swagger中测试该方法

    删除id为10的土豆

     

     成功删除，查看一下数据库数据

    6，功能：条件查询和分页

    6.1：Controller

     这个条件查询和分页还是挺重要的

    1.     @ApiOperation("条件查询老师")
    2.     @PostMapping("/condition/{current}/{size}")
    3.     public BaseResult condition(@RequestBody TeacherVo teacherVo,Integer current,Integer size){
    4.         Page condition = eduTeacherService.condition(teacherVo, current, size);
    5.         if (condition!=null){
    6.             return BaseResult.ok("查询成功",condition.getRecords());
    7.         }else {
    8.             return BaseResult.error("查询失败");
    9.         }
    10.     }

    6.2：Service

    1. @Service
    2. //开启事务管理
    3. @Transactional
    4. public class EduTeacherServiceImpl extends ServiceImpl implements EduTeacherService {
    5.  
    6.     @Override
    7.     public Page condition(TeacherVo teacherVo, Integer current, Integer size) {
    8.         //创建条件
    9.         QueryWrapper eduTeacherQueryWrapper = new QueryWrapper<>();
    10.         if (StringUtils.isNotBlank(teacherVo.getName())){
    11.             eduTeacherQueryWrapper.like("name",teacherVo.getName());
    12.         }
    13.         if (StringUtils.isNotBlank(teacherVo.getLevel())){
    14.             eduTeacherQueryWrapper.eq("level",teacherVo.getLevel());
    15.         }
    16.         if (StringUtils.isNotBlank(teacherVo.getBeginDate())){
    17.             eduTeacherQueryWrapper.ge("gmt_create",teacherVo.getBeginDate()+"00:00:00");
    18.         }
    19.         if (StringUtils.isNotBlank(teacherVo.getEndDate())){
    20.             eduTeacherQueryWrapper.le("gmt_create",teacherVo.getEndDate()+"00:00:00");
    21.         }
    22.         //分页
    23.         Page eduTeacherPage = new Page<>(current, size);
    24.         //查询
    25.         baseMapper.selectPage(eduTeacherPage,eduTeacherQueryWrapper);
    26.         return eduTeacherPage;
    27.     }

    7，功能：添加老师，修改老师

    7.1：添加配置类：进行添加和修改时间的填充

     配置类上面已经给出

    7.2：添加老师

    7.2.1：Controller

    1.     @ApiOperation("添加老师")
    2.     @PostMapping
    3.     public BaseResult addteacher(@RequestBody EduTeacher eduTeacher){
    4.         boolean flag = eduTeacherService.save(eduTeacher);
    5.         if (flag){
    6.             return BaseResult.ok("添加成功");
    7.         }else {
    8.             return BaseResult.error("添加失败");
    9.         }
    10.     }

    7.3：修改老师

    7.3.1：Controller

    1.    @PutMapping
    2.     @ApiOperation(value = "修改老师")
    3.     public BaseResult updateteacher(@RequestBody EduTeacher eduTeacher){
    4.         boolean flag = eduTeacherService.updateById(eduTeacher);
    5.         if (flag){
    6.             return BaseResult.ok("修改成功");
    7.         }else {
    8.             return BaseResult.error("修改失败");
    9.         }
    10.     }

    8，功能：删除老师，查询老师，批量删除老师

    8.1：删除老师

    8.1.1：Controller

    1. @DeleteMapping("/{teacherid}")
    2.     @ApiOperation(value = "通过id删除老师")
    3.     public BaseResult deleteByid(@PathVariable("teacherid")Integer teacherid){
    4.         boolean flag = eduTeacherService.removeById(teacherid);
    5.         if (flag){
    6.             return BaseResult.ok("删除成功");
    7.         }else {
    8.             return BaseResult.error("删除失败");
    9.         }
    10.     }

    8.2：查询老师

    8.2.1：Controller

    1.  @GetMapping("/{teacherid}")
    2.     @ApiOperation("通过id查询老师详情")
    3.     public BaseResult selectByid(@PathVariable("teacherid") Integer teacherid){
    4.         EduTeacher eduTeacher = eduTeacherService.getById(teacherid);
    5.         if (eduTeacher!=null){
    6.             return BaseResult.ok("查询成功",eduTeacher);
    7.         }else {
    8.             return BaseResult.error("查询失败");
    9.         }
    10.     }

    8.3：批量删除老师

    8.3.1：Controller

    1.     @PostMapping("/batchdelete")
    2.     @ApiOperation("批量删除老师")
    3.     public BaseResult batchdelete(@RequestBody List ids){
    4.         boolean flag = eduTeacherService.removeByIds(ids);
    5.         if (flag){
    6.             return BaseResult.ok("批量删除成功");
    7.         }else {
    8.             return BaseResult.error("批量删除失败");
    9.         }
    10.     }

    总结

    主要功能：条件和分页查询，其余的功能都是通过MybatisPlus中的通用Service进行调用方法，以用来达到功能的实现

    BaseRsult工具类：用来封装数据进行返回

     GlobalCorsConfig配置类：用来处理跨域

     TeacherMetaObjectHandler：对信息进行处理，该老师服务中应用了。例如：每条数据的创建时间和修改时间。

  • 相关阅读:
    近似熵的计算
    【分享】集简云小程序识别身份证同步到表单流程搭建示例
    Java集合和数组的区别
    深度学习 Day 16——利用卷神经网络实现咖啡豆的识别
    JavaScript同步与异步
    神经网络权重是什么意思,神经网络权值和阈值
    IEEE802.2之LLC（逻辑链路控制）
    第2-4-7章 docker安装WorkBench-规则引擎Drools-业务规则管理系统-组件化-中台
    Java：在Java 8及更高版本中使用Java流
    Node.js | 数据加密 —— 内置模块 crypto 的应用
  • 原文地址：https://blog.csdn.net/m0_64550837/article/details/126677547