1、项目概述

1.1、项目商业模式

2 商业模式.png

1.2、项目功能模块

3 项目功能模块.png

1.3、项目技术点介绍

4 项目技术点.png

2、项目搭建

2.1、前后端分离开发

2-前后端分离开发概念.png

2.2、数据库

1、创建数据库

  1. create database `guli`;

2、创建相应的表格并且初始化数据

2.3、创建项目

3 项目准备工作.png
1、创建guli_parent父工程
2、pom文件
2.1修改版本为2.2.1并设置为pom管理依赖版本

  1.  <version>2.2.1.RELEASE</version>
  2. <packaging>pom</packaging>

2.2、导入依赖版本号

  1.  <properties>
  2.         <java.version>1.8</java.version>
  3.         <guli.version>0.0.1-SNAPSHOT</guli.version>
  4.         <mybatis-plus.version>3.0.5</mybatis-plus.version>
  5.         <velocity.version>2.0</velocity.version>
  6.         <swagger.version>2.7.0</swagger.version>
  7.         <aliyun.oss.version>2.8.3</aliyun.oss.version>
  8.         <jodatime.version>2.10.1</jodatime.version>
  9.         <poi.version>3.17</poi.version>
  10.         <commons-fileupload.version>1.3.1</commons-fileupload.version>
  11.         <commons-io.version>2.6</commons-io.version>
  12.         <httpclient.version>4.5.1</httpclient.version>
  13.         <jwt.version>0.7.0</jwt.version>
  14.         <aliyun-java-sdk-core.version>4.3.3</aliyun-java-sdk-core.version>
  15.         <aliyun-sdk-oss.version>3.1.0</aliyun-sdk-oss.version>
  16.         <aliyun-java-sdk-vod.version>2.15.2</aliyun-java-sdk-vod.version>
  17.         <aliyun-java-vod-upload.version>1.4.11</aliyun-java-vod-upload.version>
  18.         <aliyun-sdk-vod-upload.version>1.4.11</aliyun-sdk-vod-upload.version>
  19.         <fastjson.version>1.2.28</fastjson.version>
  20.         <gson.version>2.8.2</gson.version>
  21.         <json.version>20170516</json.version>
  22.         <commons-dbutils.version>1.7</commons-dbutils.version>
  23.         <canal.client.version>1.1.0</canal.client.version>
  24.         <docker.image.prefix>zx</docker.image.prefix>
  25.         <cloud-alibaba.version>0.2.2.RELEASE</cloud-alibaba.version>
  26.     </properties>

2.3、导入依赖管理

  1.     <dependencyManagement>
  2.         <dependencies>
  3.             <!--Spring Cloud-->
  4.             <dependency>
  5.                 <groupId>org.springframework.cloud</groupId>
  6.                 <artifactId>spring-cloud-dependencies</artifactId>
  7.                 <version>Hoxton.RELEASE</version>
  8.                 <type>pom</type>
  9.                 <scope>import</scope>
  10.             </dependency>
  12.             <dependency>
  13.                 <groupId>org.springframework.cloud</groupId>
  14.                 <artifactId>spring-cloud-alibaba-dependencies</artifactId>
  15.                 <version>${cloud-alibaba.version}</version>
  16.                 <type>pom</type>
  17.                 <scope>import</scope>
  18.             </dependency>
  19.             <!--mybatis-plus 持久层-->
  20.             <dependency>
  21.                 <groupId>com.baomidou</groupId>
  22.                 <artifactId>mybatis-plus-boot-starter</artifactId>
  23.                 <version>${mybatis-plus.version}</version>
  24.             </dependency>
  26.             <!-- velocity 模板引擎, Mybatis Plus 代码生成器需要 -->
  27.             <dependency>
  28.                 <groupId>org.apache.velocity</groupId>
  29.                 <artifactId>velocity-engine-core</artifactId>
  30.                 <version>${velocity.version}</version>
  31.             </dependency>
  33.             <!--swagger-->
  34.             <dependency>
  35.                 <groupId>io.springfox</groupId>
  36.                 <artifactId>springfox-swagger2</artifactId>
  37.                 <version>${swagger.version}</version>
  38.             </dependency>
  39.             <!--swagger ui-->
  40.             <dependency>
  41.                 <groupId>io.springfox</groupId>
  42.                 <artifactId>springfox-swagger-ui</artifactId>
  43.                 <version>${swagger.version}</version>
  44.             </dependency>
  46.             <!--aliyunOSS-->
  47.             <dependency>
  48.                 <groupId>com.aliyun.oss</groupId>
  49.                 <artifactId>aliyun-sdk-oss</artifactId>
  50.                 <version>${aliyun.oss.version}</version>
  51.             </dependency>
  53.             <!--日期时间工具-->
  54.             <dependency>
  55.                 <groupId>joda-time</groupId>
  56.                 <artifactId>joda-time</artifactId>
  57.                 <version>${jodatime.version}</version>
  58.             </dependency>
  60.             <!--xls-->
  61.             <dependency>
  62.                 <groupId>org.apache.poi</groupId>
  63.                 <artifactId>poi</artifactId>
  64.                 <version>${poi.version}</version>
  65.             </dependency>
  66.             <!--xlsx-->
  67.             <dependency>
  68.                 <groupId>org.apache.poi</groupId>
  69.                 <artifactId>poi-ooxml</artifactId>
  70.                 <version>${poi.version}</version>
  71.             </dependency>
  73.             <!--文件上传-->
  74.             <dependency>
  75.                 <groupId>commons-fileupload</groupId>
  76.                 <artifactId>commons-fileupload</artifactId>
  77.                 <version>${commons-fileupload.version}</version>
  78.             </dependency>
  80.             <!--commons-io-->
  81.             <dependency>
  82.                 <groupId>commons-io</groupId>
  83.                 <artifactId>commons-io</artifactId>
  84.                 <version>${commons-io.version}</version>
  85.             </dependency>
  87.             <!--httpclient-->
  88.             <dependency>
  89.                 <groupId>org.apache.httpcomponents</groupId>
  90.                 <artifactId>httpclient</artifactId>
  91.                 <version>${httpclient.version}</version>
  92.             </dependency>
  94.             <dependency>
  95.                 <groupId>com.google.code.gson</groupId>
  96.                 <artifactId>gson</artifactId>
  97.                 <version>${gson.version}</version>
  98.             </dependency>
  100.             <!-- JWT -->
  101.             <dependency>
  102.                 <groupId>io.jsonwebtoken</groupId>
  103.                 <artifactId>jjwt</artifactId>
  104.                 <version>${jwt.version}</version>
  105.             </dependency>
  107.             <!--aliyun-->
  108.             <dependency>
  109.                 <groupId>com.aliyun</groupId>
  110.                 <artifactId>aliyun-java-sdk-core</artifactId>
  111.                 <version>${aliyun-java-sdk-core.version}</version>
  112.             </dependency>
  113.             <dependency>
  114.                 <groupId>com.aliyun.oss</groupId>
  115.                 <artifactId>aliyun-sdk-oss</artifactId>
  116.                 <version>${aliyun-sdk-oss.version}</version>
  117.             </dependency>
  118.             <dependency>
  119.                 <groupId>com.aliyun</groupId>
  120.                 <artifactId>aliyun-java-sdk-vod</artifactId>
  121.                 <version>${aliyun-java-sdk-vod.version}</version>
  122.             </dependency>
  123.             <dependency>
  124.                 <groupId>com.aliyun</groupId>
  125.                 <artifactId>aliyun-java-vod-upload</artifactId>
  126.                 <version>${aliyun-java-vod-upload.version}</version>
  127.             </dependency>
  128.             <dependency>
  129.                 <groupId>com.aliyun</groupId>
  130.                 <artifactId>aliyun-sdk-vod-upload</artifactId>
  131.                 <version>${aliyun-sdk-vod-upload.version}</version>
  132.             </dependency>
  133.             <dependency>
  134.                 <groupId>com.alibaba</groupId>
  135.                 <artifactId>fastjson</artifactId>
  136.                 <version>${fastjson.version}</version>
  137.             </dependency>
  138.             <dependency>
  139.                 <groupId>org.json</groupId>
  140.                 <artifactId>json</artifactId>
  141.                 <version>${json.version}</version>
  142.             </dependency>
  144.             <dependency>
  145.                 <groupId>commons-dbutils</groupId>
  146.                 <artifactId>commons-dbutils</artifactId>
  147.                 <version>${commons-dbutils.version}</version>
  148.             </dependency>
  150.             <dependency>
  151.                 <groupId>com.alibaba.otter</groupId>
  152.                 <artifactId>canal.client</artifactId>
  153.                 <version>${canal.client.version}</version>
  154.             </dependency>
  155.         </dependencies>
  156.     </dependencyManagement>

2.4、maven创建子模块service

1、pom文件
1.1、改为pom管理依赖版本

  1. <packaging>pom</packaging>

1.2、导入依赖

  1. <dependencies>
  3.         <!--<dependency>
  4.             <groupId>org.springframework.cloud</groupId>
  5.             <artifactId>spring-cloud-starter-netflix-ribbon</artifactId>
  6.         </dependency>-->
  8.         <!--hystrix依赖，主要是用  @HystrixCommand -->
  9.         <!--<dependency>
  10.             <groupId>org.springframework.cloud</groupId>
  11.             <artifactId>spring-cloud-starter-netflix-hystrix</artifactId>
  12.         </dependency>-->
  14.         <!--服务注册-->
  15.        <!-- <dependency>
  16.             <groupId>org.springframework.cloud</groupId>
  17.             <artifactId>spring-cloud-starter-alibaba-nacos-discovery</artifactId>
  18.         </dependency>-->
  19.         <!--服务调用-->
  20.        <!-- <dependency>
  21.             <groupId>org.springframework.cloud</groupId>
  22.             <artifactId>spring-cloud-starter-openfeign</artifactId>
  23.         </dependency>-->
  25.         <dependency>
  26.             <groupId>org.springframework.boot</groupId>
  27.             <artifactId>spring-boot-starter-web</artifactId>
  28.         </dependency>
  30.         <!--mybatis-plus-->
  31.         <dependency>
  32.             <groupId>com.baomidou</groupId>
  33.             <artifactId>mybatis-plus-boot-starter</artifactId>
  34.         </dependency>
  36.         <!--mysql-->
  37.         <dependency>
  38.             <groupId>mysql</groupId>
  39.             <artifactId>mysql-connector-java</artifactId>
  40.         </dependency>
  42.         <!-- velocity 模板引擎, Mybatis Plus 代码生成器需要 -->
  43.         <dependency>
  44.             <groupId>org.apache.velocity</groupId>
  45.             <artifactId>velocity-engine-core</artifactId>
  46.         </dependency>
  48.         <!--swagger-->
  49.         <dependency>
  50.             <groupId>io.springfox</groupId>
  51.             <artifactId>springfox-swagger2</artifactId>
  52.         </dependency>
  53.         <dependency>
  54.             <groupId>io.springfox</groupId>
  55.             <artifactId>springfox-swagger-ui</artifactId>
  56.         </dependency>
  58.         <!--lombok用来简化实体类：需要安装lombok插件-->
  59.         <dependency>
  60.             <groupId>org.projectlombok</groupId>
  61.             <artifactId>lombok</artifactId>
  62.         </dependency>
  64.         <!--xls-->
  65.         <dependency>
  66.             <groupId>org.apache.poi</groupId>
  67.             <artifactId>poi</artifactId>
  68.         </dependency>
  70.         <dependency>
  71.             <groupId>org.apache.poi</groupId>
  72.             <artifactId>poi-ooxml</artifactId>
  73.         </dependency>
  75.         <dependency>
  76.             <groupId>commons-fileupload</groupId>
  77.             <artifactId>commons-fileupload</artifactId>
  78.         </dependency>
  80.         <!--httpclient-->
  81.         <dependency>
  82.             <groupId>org.apache.httpcomponents</groupId>
  83.             <artifactId>httpclient</artifactId>
  84.         </dependency>
  85.         <!--commons-io-->
  86.         <dependency>
  87.             <groupId>commons-io</groupId>
  88.             <artifactId>commons-io</artifactId>
  89.         </dependency>
  90.         <!--gson-->
  91.         <dependency>
  92.             <groupId>com.google.code.gson</groupId>
  93.             <artifactId>gson</artifactId>
  94.         </dependency>
  96.         <dependency>
  97.             <groupId>junit</groupId>
  98.             <artifactId>junit</artifactId>
  99.             <version>4.12</version>
  100.         </dependency>
  101.     </dependencies>

3、讲师管理模块-后端

3.1、service下创建maven工程service_edu

3.2、application.properties

  1. # 服务端口
  2. server.port=8001
  3. # 服务名
  4. spring.application.name=service-edu
  6. # 环境设置：dev、test、prod
  7. spring.profiles.active=dev
  9. # mysql数据库连接
  10. spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
  11. spring.datasource.url=jdbc:mysql://localhost:3306/guli?serverTimezone=GMT%2B8
  12. spring.datasource.username=root
  13. spring.datasource.password=123456
  15. #mybatis日志
  16. mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl

4、代码生成器

4.1、导入依赖

  1. <!-- velocity 模板引擎, Mybatis Plus 代码生成器需要 -->
  2.         <dependency>
  3.             <groupId>org.apache.velocity</groupId>
  4.             <artifactId>velocity-engine-core</artifactId>
  5.         </dependency>

4.2、代码生成器代码引入test包下

  1. public class CodeGenerator {
  3.     @Test
  4.     public void run() {
  6.         // 1、创建代码生成器
  7.         AutoGenerator mpg = new AutoGenerator();
  9.         // 2、全局配置
  10.         GlobalConfig gc = new GlobalConfig();
  11.         String projectPath = System.getProperty("user.dir");
  12.         //修改成绝对路径
  13.         gc.setOutputDir("D:\\AAjava_project\\guli_parent\\service\\service_edu" + "/src/main/java");
  14.         gc.setAuthor("testjava");//作者名
  15.         gc.setOpen(false); //生成后是否打开资源管理器
  16.         gc.setFileOverride(false); //重新生成时文件是否覆盖
  17.         gc.setServiceName("%sService");    //去掉Service接口的首字母I
  18.         //修改Long类型ID_WORKER,string类型ID_WORKER_STR
  19.         gc.setIdType(IdType.ID_WORKER_STR); //主键策略
  20.         gc.setDateType(DateType.ONLY_DATE);//定义生成的实体类中日期类型datetime转化Date
  21.         gc.setSwagger2(true);//开启Swagger2模式
  23.         mpg.setGlobalConfig(gc);
  25.         // 3、数据源配置
  26.         DataSourceConfig dsc = new DataSourceConfig();
  27.         dsc.setUrl("jdbc:mysql://localhost:3306/guli?serverTimezone=GMT%2B8");
  28.         dsc.setDriverName("com.mysql.cj.jdbc.Driver");
  29.         dsc.setUsername("root");
  30.         //修改相应的密码
  31.         dsc.setPassword("123456");
  32.         dsc.setDbType(DbType.MYSQL);
  33.         mpg.setDataSource(dsc);
  35.         // 4、包配置
  36.         PackageConfig pc = new PackageConfig();
  37.         //修改相应的模块
  38.         pc.setModuleName("eduservice"); //模块名
  39.         //修改相应的包名
  40.         pc.setParent("com.guang");
  41.         pc.setController("controller");
  42.         pc.setEntity("entity");
  43.         pc.setService("service");
  44.         pc.setMapper("mapper");
  45.         mpg.setPackageInfo(pc);
  47.         // 5、策略配置
  48.         StrategyConfig strategy = new StrategyConfig();
  49.         //修改成相应的表名
  50.         strategy.setInclude("edu_teacher");
  51.         strategy.setNaming(NamingStrategy.underline_to_camel);//数据库表映射到实体的命名策略
  52.         strategy.setTablePrefix(pc.getModuleName() + "_"); //生成实体时去掉表前缀
  54.         strategy.setColumnNaming(NamingStrategy.underline_to_camel);//数据库表字段映射到实体的命名策略
  55.         strategy.setEntityLombokModel(true); // lombok 模型 @Accessors(chain = true) setter链式操作
  57.         strategy.setRestControllerStyle(true); //restful api风格控制器
  58.         strategy.setControllerMappingHyphenStyle(true); //url中驼峰转连字符
  60.         mpg.setStrategy(strategy);
  63.         // 6、执行
  64.         mpg.execute();
  65.     }
  66. }

4.3、编写配置类

  1. @Configuration
  2. @MapperScan("com.guang.eduservice.mapper")
  3. public class TeacherConfig {
  6.     /**
  7.      * SQL 执行性能分析插件
  8.      * 开发环境使用，线上不推荐。 maxTime 指的是 sql 最大执行时长
  9.      */
  11.     @Bean
  12.     @Profile({"dev","test"})// 设置 dev test 环境开启
  13.     public PerformanceInterceptor performanceInterceptor() {
  14.         PerformanceInterceptor performanceInterceptor = new PerformanceInterceptor();
  15.         performanceInterceptor.setMaxTime(500);//500ms，超过此处设置的ms则sql不执行
  16.         performanceInterceptor.setFormat(true);
  17.         return performanceInterceptor;
  18.     }
  19. }

4.4、编写controller（略）

4.5、返回结果时间的格式设置

  1. #返回json的全局时间格式
  2. spring.jackson.date-format=yyyy-MM-dd HH:mm:ss
  3. spring.jackson.time-zone=GMT+8

4.6、整合swragger进行测试

1、service的pom中导入service

  1.             <dependency>
  2.             <groupId>com.guang</groupId>
  3.             <artifactId>service_base</artifactId>
  4.             <version>0.0.1-SNAPSHOT</version>
  5.         </dependency>

2、解决service_edu启动时扫描不到swragger配置类

  1. //在主启动类上加上包扫描
  2. @ComponentScan(basePackages = {"com.guang"})

3、测试
localhost:8001/swagger-ui.html

4.7、统一结果返回

1、common_base引入common_utils依赖,由于service中引入了common_base,间接引入了common_utils

  1. <dependencies>
  2.         <dependency>
  3.             <groupId>com.guang</groupId>
  4.             <artifactId>common_utils</artifactId>
  5.             <version>0.0.1-SNAPSHOT</version>
  6.         </dependency>
  7.     </dependencies>

5、整合swragger

5.1、guli_parent下创建公共模块common

5.2、修改为pom

  1.  <packaging>pom</packaging>

5.3、导入依赖

  1. <dependencies>
  2.         <dependency>
  3.             <groupId>org.springframework.boot</groupId>
  4.             <artifactId>spring-boot-starter-web</artifactId>
  5.             <scope>provided </scope>
  6.         </dependency>
  7.         <!--mybatis-plus-->
  8.         <dependency>
  9.             <groupId>com.baomidou</groupId>
  10.             <artifactId>mybatis-plus-boot-starter</artifactId>
  11.             <scope>provided </scope>
  12.         </dependency>
  14.         <!--lombok用来简化实体类：需要安装lombok插件-->
  15.         <dependency>
  16.             <groupId>org.projectlombok</groupId>
  17.             <artifactId>lombok</artifactId>
  18.             <scope>provided </scope>
  19.         </dependency>
  20.         <!--swagger-->
  21.         <dependency>
  22.             <groupId>io.springfox</groupId>
  23.             <artifactId>springfox-swagger2</artifactId>
  24.             <scope>provided </scope>
  25.         </dependency>
  26.         <dependency>
  27.             <groupId>io.springfox</groupId>
  28.             <artifactId>springfox-swagger-ui</artifactId>
  29.             <scope>provided </scope>
  30.         </dependency>
  31.         <!-- redis -->
  32.         <dependency>
  33.             <groupId>org.springframework.boot</groupId>
  34.             <artifactId>spring-boot-starter-data-redis</artifactId>
  35.         </dependency>
  36.         <!-- spring2.X集成redis所需common-pool2
  37.         <dependency>
  38.             <groupId>org.apache.commons</groupId>
  39.             <artifactId>commons-pool2</artifactId>
  40.             <version>2.6.0</version>
  41.         </dependency>-->
  42.     </dependencies>

5.4、common下创建service_base

1、创建配置类SwaggerConfig

  1. @Configuration
  2. @EnableSwagger2
  3. public class SwaggerConfig {
  5.     @Bean
  6.     public Docket webApiConfig(){
  7.         return new Docket(DocumentationType.SWAGGER_2)
  8.                 .groupName("webApi")
  9.                 .apiInfo(webApiInfo())
  10.                 .select()
  11.                 .paths(Predicates.not(PathSelectors.regex("/admin/.*")))
  12.                 .paths(Predicates.not(PathSelectors.regex("/error.*")))
  13.                 .build();
  14.     }
  16.     private ApiInfo webApiInfo(){
  17.         return new ApiInfoBuilder()
  18.                 .title("网站-课程中心API文档")
  19.                 .description("本文档描述了课程中心微服务接口定义")
  20.                 .version("1.0")
  21.                 .contact(new Contact("Helen", "http://atguigu.com", "55317332@qq.com"))
  22.                 .build();
  23.     }
  25. }

6、统一结果返回

6.1、common下创建common_utils

6.2、R类

  1. @Data
  2. public class R implements ResultCode {
  4.     @ApiModelProperty(value = "是否成功")
  5.     private boolean success;
  6.     @ApiModelProperty(value = "返回状态码")
  7.     private Integer code;
  8.     @ApiModelProperty(value = "返回消息")
  9.     private String message;
  10.     @ApiModelProperty(value = "返回数据")
  11.     private Map<String, Object> data = new HashMap<>();
  13.     //无参构造私有化，只能通过类名访问
  14.     private R() {
  15.     }
  17.     //成功调用的静态方法
  18.     public static R OK() {
  19.         R r = new R();
  20.         r.code = SUCCESS;
  21.         r.message = "成功";
  22.         r.success = true;
  23.         return r;
  24.     }
  26.     //失败调用的静态方法
  27.     public static R ERROE() {
  28.         R r = new R();
  29.         r.code = ERROR;
  30.         r.message = "失败";
  31.         r.success = false;
  32.         return r;
  33.     }
  35.     //参数错误调用的静态方法
  36.     public static R ERROEPARAM() {
  37.         R r = new R();
  38.         r.code = 300;
  39.         r.message = "参数不存在或参数错误";
  40.         r.success = false;
  41.         return r;
  42.     }
  45.     public R setSuccess(boolean success) {
  46.         this.success = success;
  47.         return this;
  48.     }
  50.     public R setCode(Integer code) {
  51.         this.code = code;
  52.         return this;
  53.     }
  55.     public R setMessage(String message) {
  56.         this.message = message;
  57.         return this;
  58.     }
  60.     public R setData(Map<String, Object> data) {
  61.         this.data = data;
  62.         return this;
  63.     }
  64. }

6.3、ResultCode接口

  1. public interface ResultCode {
  3.     public static Integer SUCCESS=200;
  4.     public static Integer ERROR=400;
  6. }