第一章：简介

• 这是一个真实的企业项目
• 技术架构：
  • springCloudAlibaba
  • VUE实现了前后端分离开发(解决跨域的问题)
  • 数据库：mysql
  • ORM:mybatisPlus
• 把我们开发的模块都分为不同的微服务部分
• 把需要上传的图片及视频都存储在阿里云中

1、技术选型

查看SpringCloud 和SpringBoot版本兼容性

查看SpringCloud 对其余各个技术版本的兼容性 需要转换成JSON进行查看

2、学习版本定稿

学习时必须和定稿版本一致

第二章：搭建项目环境

2.1 创建一个maven项目，作为父工程

2.2 pom.xml依赖

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <!-- 模型版本。maven2.0必须是这样写，现在是maven2唯一支持的版本 -->
    <modelVersion>4.0.0</modelVersion>
    <!-- 公司或者组织的唯一标志，并且配置时生成的路径也是由此生成， 如 com.example，maven 会将该项目打成的 jar 包放本地路径：/com/example -->
    <groupId>com.example</groupId>
    <!-- 本项目的唯一ID，一个groupId下面可能多个项目，就是靠artifactId来区分的 -->
    <artifactId>movies</artifactId>
    <!-- 本项目目前所处的版本号 -->
    <version>1.0-SNAPSHOT</version>
    <!-- 打包的机制，如 pom、jar、maven-plugin、ejb、war、ear、rar和par，默认为jar -->
    <packaging>pom</packaging>
    <!-- Spring Boot 的父级依赖-->
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.1.3.RELEASE</version>
    </parent>
    <!-- 帮助定义构件输出的一些附属构件,附属构件与主构件对应，有时候需要加上classifier才能唯一的确定该构件 不能直接定义项目的classifer,因为附属构件不是项目直接默认生成的，而是由附加的插件帮助生成的 -->
    <!--<classifier></classifier>-->
    <!-- 统一管理jar包版本 -->
    <properties>
        <java.version>1.8</java.version>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
        <spring-cloud.version>Greenwich.RELEASE</spring-cloud.version>
        <spring-cloud-alibaba.version>2.1.0.RELEASE</spring-cloud-alibaba.version>
        <mybatis-plus.version>3.0.5</mybatis-plus.version>
        <velocity.version>2.0</velocity.version>
        <swagger.version>2.7.0</swagger.version>
        <aliyun.oss.version>2.8.3</aliyun.oss.version>
        <jodatime.version>2.10.1</jodatime.version>
        <poi.version>3.17</poi.version>
        <commons-fileupload.version>1.3.1</commons-fileupload.version>
        <commons-io.version>2.6</commons-io.version>
        <httpclient.version>4.5.1</httpclient.version>
        <jwt.version>0.7.0</jwt.version>
        <aliyun-java-sdk-core.version>4.3.3</aliyun-java-sdk-core.version>
        <aliyun-sdk-oss.version>3.1.0</aliyun-sdk-oss.version>
        <aliyun-java-sdk-vod.version>2.15.2</aliyun-java-sdk-vod.version>
        <aliyun-java-vod-upload.version>1.4.11</aliyun-java-vod-upload.version>
        <aliyun-sdk-vod-upload.version>1.4.11</aliyun-sdk-vod-upload.version>
        <fastjson.version>1.2.28</fastjson.version>
        <gson.version>2.8.2</gson.version>
        <json.version>20170516</json.version>
        <commons-dbutils.version>1.7</commons-dbutils.version>
        <canal.client.version>1.1.0</canal.client.version>
        <docker.image.prefix>zx</docker.image.prefix>
        <cloud-alibaba.version>0.2.2.RELEASE</cloud-alibaba.version>
    </properties>
    <!--子模块继承之后，提供作用：锁定版本+子module不用写groupId和version  -->
    <dependencyManagement>
        <!-- 定义本项目的依赖关系 -->
        <dependencies>
            <!--spring cloud-->
            <dependency>
                <groupId>org.springframework.cloud</groupId>
                <artifactId>spring-cloud-dependencies</artifactId>
                <version>${spring-cloud.version}</version>
                <type>pom</type>
                <scope>import</scope>
            </dependency>
            <!--spring cloud alibaba-->
            <dependency>
                <groupId>com.alibaba.cloud</groupId>
                <artifactId>spring-cloud-alibaba-dependencies</artifactId>
                <version>${spring-cloud-alibaba.version}</version>
                <type>pom</type>
                <scope>import</scope>
            </dependency>
            <!--mybatis-plus 持久层-->
            <dependency>
                <groupId>com.baomidou</groupId>
                <artifactId>mybatis-plus-boot-starter</artifactId>
                <version>${mybatis-plus.version}</version>
            </dependency>
            <!-- velocity 模板引擎, Mybatis Plus 代码生成器需要 -->
            <dependency>
                <groupId>org.apache.velocity</groupId>
                <artifactId>velocity-engine-core</artifactId>
                <version>${velocity.version}</version>
            </dependency>
            <!--Swagger 用于生成、描述、调用和可视化RESTful 风格的Web服务-->
            <dependency>
                <groupId>io.springfox</groupId>
                <artifactId>springfox-swagger2</artifactId>
                <version>${swagger.version}</version>
            </dependency>
            <!--springfox-swagger-ui 是一个webjar, 方便进行maven集成-->
            <dependency>
                <groupId>io.springfox</groupId>
                <artifactId>springfox-swagger-ui</artifactId>
                <version>${swagger.version}</version>
            </dependency>
            <!--aliyunOSS 是一种海量、安全、低成本、高可靠的云存储服务-->
            <dependency>
                <groupId>com.aliyun.oss</groupId>
                <artifactId>aliyun-sdk-oss</artifactId>
                <version>${aliyun.oss.version}</version>
            </dependency>
            <!--日期时间工具-->
            <dependency>
                <groupId>joda-time</groupId>
                <artifactId>joda-time</artifactId>
                <version>${jodatime.version}</version>
            </dependency>
            <!--提供API给Java程序对Microsoft Office格式档案读和写的功能-->
            <!--xls-->
            <dependency>
                <groupId>org.apache.poi</groupId>
                <artifactId>poi</artifactId>
                <version>${poi.version}</version>
            </dependency>
            <!--xlsx-->
            <dependency>
                <groupId>org.apache.poi</groupId>
                <artifactId>poi-ooxml</artifactId>
                <version>${poi.version}</version>
            </dependency>
            <!--文件上传-->
            <dependency>
                <groupId>commons-fileupload</groupId>
                <artifactId>commons-fileupload</artifactId>
                <version>${commons-fileupload.version}</version>
            </dependency>
            <!--commons-io 可以挺提高 IO 功能开发的效率-->
            <dependency>
                <groupId>commons-io</groupId>
                <artifactId>commons-io</artifactId>
                <version>${commons-io.version}</version>
            </dependency>
            <!--httpclient 可以用来提供高效的、最新的、功能丰富的支持 HTTP 协议的客户端编程工具包-->
            <dependency>
                <groupId>org.apache.httpcomponents</groupId>
                <artifactId>httpclient</artifactId>
                <version>${httpclient.version}</version>
            </dependency>
            <!--将Java对象序列化为JSON，反之亦然-->
            <dependency>
                <groupId>com.google.code.gson</groupId>
                <artifactId>gson</artifactId>
                <version>${gson.version}</version>
            </dependency>
            <!-- JWT 用于在JVM和Android上创建和验证JSON Web令牌 -->
            <dependency>
                <groupId>io.jsonwebtoken</groupId>
                <artifactId>jjwt</artifactId>
                <version>${jwt.version}</version>
            </dependency>
            <!--aliyun-->
            <!--阿里云的核心SDK-->
            <dependency>
                <groupId>com.aliyun</groupId>
                <artifactId>aliyun-java-sdk-core</artifactId>
                <version>${aliyun-java-sdk-core.version}</version>
            </dependency>
            <!--提供基于网络的数据存取服务-->
            <dependency>
                <groupId>com.aliyun.oss</groupId>
                <artifactId>aliyun-sdk-oss</artifactId>
                <version>${aliyun-sdk-oss.version}</version>
            </dependency>
            <!-- 阿里云SDK点播服务包重构，支持composer方式使用-->
            <dependency>
                <groupId>com.aliyun</groupId>
                <artifactId>aliyun-java-sdk-vod</artifactId>
                <version>${aliyun-java-sdk-vod.version}</version>
            </dependency>
            <!--阿里云视频点播上传客户端-->
            <dependency>
                <groupId>com.aliyun</groupId>
                <artifactId>aliyun-java-vod-upload</artifactId>
                <version>${aliyun-java-vod-upload.version}</version>
            </dependency>
            <!--文件上传的方式和基本流程-->
            <dependency>
                <groupId>com.aliyun</groupId>
                <artifactId>aliyun-sdk-vod-upload</artifactId>
                <version>${aliyun-sdk-vod-upload.version}</version>
            </dependency>
            <!--fastjson 提供服务器端、安卓客户端两种解析工具-->
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>fastjson</artifactId>
                <version>${fastjson.version}</version>
            </dependency>
            <!--json 轻量级的数据交换格式-->
            <dependency>
                <groupId>org.json</groupId>
                <artifactId>json</artifactId>
                <version>${json.version}</version>
            </dependency>
            <!--用于操作数据库的工具包-->
            <dependency>
                <groupId>commons-dbutils</groupId>
                <artifactId>commons-dbutils</artifactId>
                <version>${commons-dbutils.version}</version>
            </dependency>
            <!--实现数据同步-->
            <dependency>
                <groupId>com.alibaba.otter</groupId>
                <artifactId>canal.client</artifactId>
                <version>${canal.client.version}</version>
            </dependency>
        </dependencies>
    </dependencyManagement>
    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
                <configuration>
                    <fork>true</fork>
                    <addResources>true</addResources>
                </configuration>
            </plugin>
        </plugins>
    </build>
</project>

2.3 创建子工程

2.3.1 subproject_service服务的子工程

• pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <parent>
        <artifactId>movies</artifactId>
        <groupId>com.example</groupId>
        <version>1.0-SNAPSHOT</version>
    </parent>
    <modelVersion>4.0.0</modelVersion>
    <artifactId>subproject_service</artifactId>
    <packaging>pom</packaging>
    <dependencies>
        <!--nacos客户端-->
        <dependency>
            <groupId>com.alibaba.cloud</groupId>
            <artifactId>spring-cloud-starter-alibaba-nacos-discovery</artifactId>
        </dependency>
        <!--web-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <!--mybatis-plus-->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
        </dependency>
        <!--mysql驱动-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <!--mybatisplus-代码生成器的模板-->
        <dependency>
            <groupId>org.apache.velocity</groupId>
            <artifactId>velocity-engine-core</artifactId>
        </dependency>
        <!--swagger-->
        <dependency>
            <groupId>io.springfox</groupId>
            <artifactId>springfox-swagger2</artifactId>
        </dependency>
        <dependency>
            <groupId>io.springfox</groupId>
            <artifactId>springfox-swagger-ui</artifactId>
        </dependency>
        <!--lombok-->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
        </dependency>
        <!--xls-->
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi</artifactId>
        </dependency>
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi-ooxml</artifactId>
        </dependency>
        <dependency>
            <groupId>commons-fileupload</groupId>
            <artifactId>commons-fileupload</artifactId>
        </dependency>
        <!--httpCilents-->
        <dependency>
            <groupId>org.apache.httpcomponents</groupId>
            <artifactId>httpclient</artifactId>
        </dependency>
        <dependency>
            <groupId>commons-io</groupId>
            <artifactId>commons-io</artifactId>
        </dependency>
        <!--gson-->
        <dependency>
            <groupId>com.google.code.gson</groupId>
            <artifactId>gson</artifactId>
        </dependency>
    </dependencies>
</project>

2.3.2 public_common公共工程

• pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <!--公共工程-->
    <parent>
        <artifactId>movies</artifactId>
        <groupId>com.example</groupId>
        <version>1.0-SNAPSHOT</version>
    </parent>
    <modelVersion>4.0.0</modelVersion>
    <artifactId>public_common</artifactId>
    <packaging>pom</packaging>
    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
            <scope>provided</scope>
        </dependency>
        <!--mybatis-plus-->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <scope>provided</scope>
        </dependency>
        <!--为了简化实体类，配置lombok-->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
        </dependency>
        <!--为了测试前后端分离项目 swagger-->
        <dependency>
            <groupId>io.springfox</groupId>
            <artifactId>springfox-swagger2</artifactId>
        </dependency>
        <dependency>
            <groupId>io.springfox</groupId>
            <artifactId>springfox-swagger-ui</artifactId>
        </dependency>
        <!--二级缓存配置-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-redis</artifactId>
        </dependency>
    </dependencies>
</project>

2.3.3 在public_common下创建子模块common_util和service_base

在创建模块时，注意路径是否在public_common模块下

2.3.3.1 创建service_base模块

• pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <parent>
        <artifactId>public_common</artifactId>
        <groupId>com.example</groupId>
        <version>1.0-SNAPSHOT</version>
    </parent>
    <modelVersion>4.0.0</modelVersion>
    <artifactId>service_base</artifactId>
    <dependencies>
        <!--添加工具模块-->
        <dependency>
            <groupId>com.example</groupId>
            <artifactId>common_util</artifactId>
            <version>1.0-SNAPSHOT</version>
        </dependency>
    </dependencies>
</project>

2.3.3.2 创建common_util模块

2.3.4 在service_base中编写配置swagger类

package com.example.movies.config;
import com.google.common.base.Predicates;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import springfox.documentation.builders.ApiInfoBuilder;
import springfox.documentation.builders.PathSelectors;
import springfox.documentation.service.ApiInfo;
import springfox.documentation.service.Contact;
import springfox.documentation.spi.DocumentationType;
import springfox.documentation.spring.web.plugins.Docket;
import springfox.documentation.swagger2.annotations.EnableSwagger2;
/**
 * 配置类.
 */
@Configuration
@EnableSwagger2
public class SwaggerConfig {
    /**
     * 构建api文档的详细信息函数
     * @return
     */
    private ApiInfo webApiInfo() {
        return new ApiInfoBuilder()
                // 页面标题
                .title("Api文档")
                // 描述
                .description("描述微服务接口定义")
                // 版本号
                .version("1.0")
                // 创建人
                .contact(new Contact("java", "http://zmxdata.com", "hksupports@163.com"))
                .build();
    }
    /**
     * 构建接口文档
     * @return
     */
    @Bean
    public Docket webApiConfig() {
        return new Docket(DocumentationType.SWAGGER_2)
                // 分组名
                .groupName("webApi")
                // 设置描述文件
                .apiInfo(webApiInfo())
                // 用来等待文件描述词状态的改变
                .select()
                // 只显示api路径下的页面
                .paths(Predicates.not(PathSelectors.regex("/error.*")))
                .build();
    }
}

2.4 在subproject_service模块中创建子模块service_actor

• 演员模块

• pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <parent>
        <artifactId>xiudun_service</artifactId>
        <groupId>com.xiudun</groupId>
        <version>1.0-SNAPSHOT</version>
    </parent>
    <modelVersion>4.0.0</modelVersion>
    <artifactId>service_actor</artifactId>
    <dependencies>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>easyexcel</artifactId>
            <version>2.1.1</version>
        </dependency>
    </dependencies>
</project>

2.4.1 配置公共部分

• 主配置类

package com.example.movies;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.cloud.client.discovery.EnableDiscoveryClient;
import springfox.documentation.swagger2.annotations.EnableSwagger2;
/**
 * 主配置类.
 */
@SpringBootApplication
@EnableSwagger2
@EnableDiscoveryClient
@MapperScan("com.example.movies.mapper")
public class ActorApplication {
    public static void main(String[] args) {
        SpringApplication.run(ActorApplication.class, args);
    }
}

• 配置文件：application.yml,注意：冒号后必须有空格，这是编写格式

server:
  # 端口
  port: 8081
spring:
  application:
    # 服务名
    name: service-actor
  profiles:
    # 开发环境
    active: dev
  # mysql 配置
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/movies?useUnicode=true&characterEncoding=utf8$serverTimezone=GMT%2B8ame
    username: root
    password: 123456
  # json 的时间格式
  jackson:
    date-format: yyyy-MM-dd HH:mm:ss
    time-zone: GMT+8
  # 注册中心
  cloud:
    nacos:
      discovery:
        server-addr: localhost:8848

• 先创建数据库
• 再启动nacos
  • http://localhost:8848/nacos

• swagger的测试页面
  • http://localhost:8081/swagger-ui.html

第三章：编写演员模块

3.1 生成数据库

#
# 影视图片表
#
CREATE TABLE `crm_banner` (
  `id` char(19) NOT NULL DEFAULT '' COMMENT 'ID',
  `title` varchar(20) DEFAULT '' COMMENT '标题',
  `image_url` varchar(500) NOT NULL DEFAULT '' COMMENT '图片地址',
  `link_url` varchar(500) DEFAULT '' COMMENT '链接地址',
  `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `is_deleted` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '逻辑删除 1（true）已删除， 0（false）未删除',
  `gmt_create` datetime NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_name` (`title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='首页banner表';
#
# Data for table "crm_banner"
#
INSERT INTO `crm_banner` VALUES ('1194556896025845762','test1',
'https://xxx.jpg',
'/course',1,0,'2019-11-13 18:05:32','2019-11-18 10:28:22'),('1194607458461216769','test2',
'https://xxxx.jpg',
'/teacher',2,0,'2019-11-13 21:26:27','2019-11-14 09:12:15');
#
# 影视片段表
#
CREATE TABLE `edu_chapter` (
  `id` char(19) NOT NULL COMMENT '片段ID',
  `movies_id` char(19) NOT NULL COMMENT '影视ID',
  `title` varchar(50) NOT NULL COMMENT '片段名称',
  `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '显示排序',
  `gmt_create` datetime NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_movies_id` (`movies_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='影视';
#
# Data for table "edu_chapter"
#
INSERT INTO `edu_chapter` VALUES ('1','14','第一片段：剧情介绍',0,'2019-01-01 12:27:40','2019-01-01 12:55:30'),
('1181729226915577857','18','故事发生的时间',70,'2019-10-09 08:32:58','2019-10-09 08:33:20'),
('1192252428399751169','1192252213659774977','第一段',0,'2019-11-07 09:28:25','2019-11-07 09:28:25'),
('15','18','第一片段：演员入戏',0,'2019-01-01 12:27:40','2019-10-09 09:13:19'),
('3','14','第二片段：演员公司入职',0,'2019-01-01 12:55:35','2019-01-01 12:27:40'),
('44','18','第三片段：演员学习',0,'2019-01-01 12:27:40','2019-01-01 12:27:40');
#
# 影片表
#
CREATE TABLE `edu_movies` (
  `id` char(19) NOT NULL COMMENT '影视ID',
  `actor_id` char(19) NOT NULL COMMENT '影视演员ID',
  `subject_id` char(19) NOT NULL COMMENT '影视专业ID',
  `subject_parent_id` char(19) NOT NULL COMMENT '影视专业父级ID',
  `title` varchar(50) NOT NULL COMMENT '影视标题',
  `price` decimal(10,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '影视销售价格，设置为0则可免费观看',
  `video_num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '总段数',
  `cover` varchar(255) CHARACTER SET utf8 NOT NULL COMMENT '影视封面图片路径',
  `buy_count` bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '销售数量',
  `view_count` bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '浏览数量',
  `version` bigint(20) unsigned NOT NULL DEFAULT '1' COMMENT '乐观锁',
  `status` varchar(10) NOT NULL DEFAULT 'Draft' COMMENT '影视状态 Draft未发布  Normal已发布',
  `is_deleted` tinyint(3) DEFAULT NULL COMMENT '逻辑删除 1（true）已删除， 0（false）未删除',
  `gmt_create` datetime NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_title` (`title`),
  KEY `idx_subject_id` (`subject_id`),
  KEY `idx_actor_id` (`actor_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='影视';
#
# Data for table "edu_movies"
#
INSERT INTO `edu_movies` VALUES ('1192252213659774977','1189389726308478977','1178214681139539969',
'1178214681118568449','基础影视：test',0.01,2,
'https://xxx.gif',4,387,1,'Normal',0,'2019-11-07 09:27:33','2019-11-18 13:35:03'),
('14','1189389726308478977','1101348944971091969','1101348944920760321','我的祖国',0.00,3,
'http://xxxx.jpg',3,44,15,'Normal',0,'2018-04-02 18:33:34','2019-11-16 21:21:45'),
('15','1189389726308478977','1101348944971091969','1101348944920760321','冠军',0.00,23,
'http://xxx.jpg',0,51,17,'Normal',0,'2018-04-02 18:34:32','2019-11-12 10:19:20'),
('18','1189389726308478977','1178214681139539969','1178214681118568449','战狼2',0.01,20,
'http://xxx.jpg',151,737,6,'Normal',0,'2018-04-02 21:28:46','2019-11-18 11:14:52');
#
# 影视收藏表
#
CREATE TABLE `edu_movies_collect` (
  `id` char(19) NOT NULL COMMENT '收藏ID',
  `movies_id` char(19) NOT NULL COMMENT '影视演员ID',
  `member_id` char(19) NOT NULL DEFAULT '' COMMENT '影视专业ID',
  `is_deleted` tinyint(3) NOT NULL DEFAULT '0' COMMENT '逻辑删除 1（true）已删除， 0（false）未删除',
  `gmt_create` datetime NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='影视收藏';
#
# Data for table "edu_movies_collect"
#
INSERT INTO `edu_movies_collect` VALUES ('1196269345666019330','1192252213659774977','1',1,'2019-11-18 11:30:12','2019-11-18 11:30:12');
#
# 影视简介表
#
CREATE TABLE `edu_movies_description` (
  `id` char(19) NOT NULL COMMENT '影视ID',
  `description` text COMMENT '影视简介',
  `gmt_create` datetime NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='影视简介';
#
# Data for table "edu_movies_description"
#
INSERT INTO `edu_movies_description` VALUES ('1104870479077879809','<p>11</p>','2019-03-11 06:23:44',
'2019-03-11 06:23:44'),('1192252213659774977','<p>影片</p>','2019-11-07 09:27:33','2019-11-13 16:21:28'),
('14','','2019-03-13 06:04:43','2019-03-13 06:05:33'),('15','','2019-03-13 06:03:33','2019-03-13 06:04:22'),
('18','<p>本影片介绍了中国的历史</p>','2019-03-06 18:06:36','2019-10-30 19:58:36');
#
# 影视类别表
#
CREATE TABLE `edu_subject` (
  `id` char(19) NOT NULL COMMENT '影视类别ID',
  `title` varchar(10) NOT NULL COMMENT '类别名称',
  `parent_id` char(19) NOT NULL DEFAULT '0' COMMENT '父ID',
  `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序字段',
  `gmt_create` datetime NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_parent_id` (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='影视科目';
#
# Data for table "edu_subject"
#
INSERT INTO `edu_subject` VALUES ('1178214681118568449','战争','0',1,'2019-09-29 15:47:25','2019-09-29 15:47:25'),
('1178214681139539969','爱情','1178214681118568449',1,'2019-09-29 15:47:25','2019-09-29 15:47:25'),
('1178214681181483010','城市剧','0',3,'2019-09-29 15:47:25','2019-09-29 15:47:25'),
('1178214681210843137','伦理剧','1178214681181483010',4,'2019-09-29 15:47:25','2019-09-29 15:47:25'),
('1178214681231814658','喜剧','0',5,'2019-09-29 15:47:25','2019-09-29 15:47:25'),
('1178214681252786178','武打片','1178214681231814658',5,'2019-09-29 15:47:25','2019-09-29 15:47:25'),
('1178214681294729217','纪录片','1178214681231814658',6,'2019-09-29 15:47:25','2019-09-29 15:47:25'),
('1178214681324089345','连续剧','0',7,'2019-09-29 15:47:25','2019-09-29 15:47:25'),
('1178214681353449473','战争1','1178214681324089345',7,'2019-09-29 15:47:25','2019-09-29 15:47:25'),
('1178214681382809602','言情剧','1178214681324089345',8,'2019-09-29 15:47:25','2019-09-29 15:47:25');
#
# 演员(主演)表
#
CREATE TABLE `edu_actor` (
  `id` char(19) NOT NULL COMMENT '演员ID',
  `name` varchar(20) NOT NULL COMMENT '演员姓名',
  `intro` varchar(500) NOT NULL DEFAULT '' COMMENT '演员简介',
  `career` varchar(500) DEFAULT NULL COMMENT '演员资历,一句话说明演员',
  `level` int(10) unsigned NOT NULL COMMENT '头衔 1高级演员 2首席演员',
  `avatar` varchar(255) DEFAULT NULL COMMENT '演员头像',
  `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `is_deleted` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '逻辑删除 1（true）已删除， 0（false）未删除',
  `gmt_create` datetime NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='演员';
#
# Data for table "edu_actor"
#
INSERT INTO `edu_actor` VALUES ('1','张三','一级演员','一线',1,'https://xx/avatar/default.jpg',0,0,
'2019-10-30 14:18:46','2019-11-12 13:36:36'),
('1189389726308478977','李四','一级演员','一线',2,'https://xxx/actor/11.png',1,0,'2019-10-30 11:53:03',
'2019-10-30 11:53:03'),('1189390295668469762','李刚','高级演员简介','高级演员',2,
'https://xxx.png',2,0,'2019-10-30 11:55:19','2019-11-12 13:37:52'),
('1189426437876985857','王二','高级演员简介','高级演员',1,'https://2ec96ef88.png',0,0,'2019-10-30 14:18:56',
'2019-11-12 13:37:35'),('1189426464967995393','王五','高级演员简介','高级演员',1,
'https://xxxx.png',0,0,'2019-10-30 14:19:02','2019-11-12 13:37:18'),
('1192249914833055746','李四1','高级演员简介','高级演员',1,'https://d825d.png',0,0,
'2019-11-07 09:18:25','2019-11-12 13:37:01'),
('1192327476087115778','1222-12-12','1111','11',1,'https://fd8a4.png',0,1,
'2019-11-07 14:26:37','2019-11-11 16:26:26'),
('1195337453429129218','test','sdfsdf','sdfdf',1,'https://default.jpg',0,1,
'2019-11-15 21:47:12','2019-11-15 21:47:27');
#
# 电影视频表
#
CREATE TABLE `edu_video` (
  `id` char(19) NOT NULL COMMENT '视频ID',
  `movies_id` char(19) NOT NULL COMMENT '影视ID',
  `chapter_id` char(19) NOT NULL COMMENT '章节ID',
  `title` varchar(50) NOT NULL COMMENT '节点名称',
  `video_source_id` varchar(100) DEFAULT NULL COMMENT '云端视频资源',
  `video_original_name` varchar(100) DEFAULT NULL COMMENT '原始文件名称',
  `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序字段',
  `play_count` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '播放次数',
  `is_free` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否可以试听：0收费 1免费',
  `duration` float NOT NULL DEFAULT '0' COMMENT '视频时长（秒）',
  `status` varchar(20) NOT NULL DEFAULT 'Empty' COMMENT 'Empty未上传 Transcoding转码中  Normal正常',
  `size` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '视频源文件大小（字节）',
  `version` bigint(20) unsigned NOT NULL DEFAULT '1' COMMENT '乐观锁',
  `gmt_create` datetime NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_movies_id` (`movies_id`),
  KEY `idx_chapter_id` (`chapter_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='影视视频';
#
# Data for table "edu_video"
#
INSERT INTO `edu_video` VALUES ('1182499307429339137','18','32','第一节','','',0,0,0,0,'',0,1,
'2019-10-11 11:32:59','2019-10-11 11:57:38'),('1185312444399071234','14','1','12','','',0,0,0,0,
'Empty',0,1,'2019-10-19 05:51:23','2019-10-19 05:51:33'),('1189434737808990210','18','44','测试','','',
1,0,0,0,'Empty',0,1,'2019-10-30 14:51:55','2019-10-30 14:51:55'),
('1189471423678939138','18','1181729226915577857','test','2b887dc9584d4dc68908780ec57cd3b9',
'视频',1,0,0,0,'Empty',0,1,'2019-10-30 17:17:41','2019-10-30 17:17:41'),
('1189476403626409986','18','1181729226915577857','22','5155c73dc112475cbbddccf4723f7cef',
'视频.mp4',0,0,0,0,'Empty',0,1,'2019-10-30 17:37:29','2019-10-30 17:37:29'),
('1192252824606289921','1192252213659774977','1192252428399751169','第一段落',
'756cf06db9cb4f30be85a9758b19c645','eae2b847ef8503b81f5d5593d769dde2.mp4',0,0,0,0,
'Empty',0,1,'2019-11-07 09:29:59','2019-11-07 09:29:59'),
('1192628092797730818','1192252213659774977','1192252428399751169','第二段落',
'2a02d726622f4c7089d44cb993c531e1','eae2b847ef8503b81f5d5593d769dde2.mp4',0,0,1,0,
'Empty',0,1,'2019-11-08 10:21:10','2019-11-08 10:21:22'),
('1192632495013380097','1192252213659774977','1192252428399751169','第三段落',
'4e560c892fdf4fa2b42e0671aa42fa9d','eae2b847ef8503b81f5d5593d769dde2.mp4',0,0,1,0,'Empty',0,1,
'2019-11-08 10:38:40','2019-11-08 10:38:40'),('1194117638832111617','1192252213659774977','1192252428399751169',
'第四段落','4e560c892fdf4fa2b42e0671aa42fa9d','eae2b847ef8503b81f5d5593d769dde2.mp4',0,0,0,0,'Empty',0
,1,'2019-11-12 13:00:05','2019-11-12 13:00:05'),('1196263770832023554','1192252213659774977',
'1192252428399751169','第五段落','27d21158b0834cb5a8d50710937de330','eae2b847ef8503b81f5d5593d769dde2.mp4',
5,0,0,0,'Empty',0,1,'2019-11-18 11:08:03','2019-11-18 11:08:03'),
('17','18','15','第一节：喜剧','196116a6fee742e1ba9f6c18f65bd8c1','1',1,1000,1,100,'喜剧1',
0,1,'2019-01-01 13:08:57','2019-10-11 11:26:39'),('18','18','15','第二节：爱情剧',
'2d99b08ca0214909899910c9ba042d47','爱情剧',2,999,1,100,'爱情剧',0,1,'2019-01-01 13:09:02','2019-03-08 03:30:27'),
('19','18','15','第三节：爱情剧','51120d59ddfd424cb5ab08b44fc8b23a',
'eae2b847ef8503b81f5d5593d769dde2.mp4',3,888,0,100,'Draft',0,1,'2019-01-01 13:09:05','2019-11-12 12:50:45'),
('20','18','15','第四节：爱情剧','2a38988892d84df598752226c50f3fa3','爱情剧总结.avi',4,666,0,100,
'Draft',0,1,'2019-01-01 13:09:05','2019-10-11 09:20:09');

3.2 代码生成器

package com.example.movies;
import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.generator.AutoGenerator;
import com.baomidou.mybatisplus.generator.config.DataSourceConfig;
import com.baomidou.mybatisplus.generator.config.GlobalConfig;
import com.baomidou.mybatisplus.generator.config.PackageConfig;
import com.baomidou.mybatisplus.generator.config.StrategyConfig;
import com.baomidou.mybatisplus.generator.config.rules.DateType;
import com.baomidou.mybatisplus.generator.config.rules.NamingStrategy;
import org.junit.Test;
/**
 * 自动生成代码.
 * 记得修改配置信息.
 */
public class CodeGenerator {
    @Test
    public void run() {
        // 1、创建代码生成器
        AutoGenerator mpg = new AutoGenerator();
        // 2、全局配置
        GlobalConfig gc = new GlobalConfig();
        String projectPath = System.getProperty("user.dir");
        gc.setOutputDir(projectPath + "/src/main/java");
        gc.setAuthor("yourName");
        gc.setOpen(false); //生成后是否打开资源管理器
        gc.setFileOverride(false); //重新生成时文件是否覆盖
        gc.setServiceName("%sService");    //去掉Service接口的首字母I
        gc.setIdType(IdType.ID_WORKER_STR); //主键策略
        gc.setDateType(DateType.ONLY_DATE);//定义生成的实体类中日期类型
        gc.setSwagger2(true);//开启Swagger2模式
        mpg.setGlobalConfig(gc);
        // 3、数据源配置
        DataSourceConfig dsc = new DataSourceConfig();
        dsc.setUrl("jdbc:mysql://localhost:3306/movies?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8");
        dsc.setDriverName("com.mysql.cj.jdbc.Driver");
        dsc.setUsername("root");
        dsc.setPassword("123456");
        dsc.setDbType(DbType.MYSQL);
        mpg.setDataSource(dsc);
        // 4、包配置
        PackageConfig pc = new PackageConfig();
        pc.setModuleName("movies"); //模块名
        pc.setParent("com.example");
        pc.setController("controller");
        pc.setEntity("entity");
        pc.setService("service");
        pc.setMapper("mapper");
        mpg.setPackageInfo(pc);
        // 5、策略配置
        StrategyConfig strategy = new StrategyConfig();
        strategy.setInclude("edu_actor", "edu_movies"); // 表名称
        strategy.setNaming(NamingStrategy.underline_to_camel);//数据库表映射到实体的命名策略
        strategy.setTablePrefix(pc.getModuleName() + "_"); //生成实体时去掉表前缀
        strategy.setColumnNaming(NamingStrategy.underline_to_camel);//数据库表字段映射到实体的命名策略
        strategy.setEntityLombokModel(true); // lombok 模型 @Accessors(chain = true) setter链式操作
        strategy.setRestControllerStyle(true); //restful api风格控制器
        strategy.setControllerMappingHyphenStyle(true); //url中驼峰转连字符
        mpg.setStrategy(strategy);
        // 6、执行
        mpg.execute();
    }
}

3.3 编写演员的功能实现

3.3.1 dao数据访问层

package com.example.movies.mapper;
import com.example.movies.entity.EduActor;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
/**
 * <p>
 * 演员 Mapper 接口
 * </p>
 */
public interface EduActorMapper extends BaseMapper<EduActor> {
}

3.3.2 service业务层

• 接口

package com.example.movies.service;
import com.example.movies.entity.EduActor;
import com.baomidou.mybatisplus.extension.service.IService;
/**
 * <p>
 * 演员 服务类
 * </p>
 */
public interface EduActorService extends IService<EduActor> {
}

• 实现类

package com.example.movies.service.impl;
import com.example.movies.entity.EduActor;
import com.example.movies.mapper.EduActorMapper;
import com.example.movies.service.EduActorService;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.springframework.stereotype.Service;
/**
 * <p>
 * 演员 服务实现类
 * </p>
 */
@Service
public class EduActorServiceImpl extends ServiceImpl<EduActorMapper, EduActor> implements EduActorService {
}

3.3.3 controller控制层

package com.example.movies.controller;
import com.example.movies.service.EduActorService;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import java.util.List;
/**
 * <p>
 * 演员 前端控制器
 * </p>
 */
@RestController
@RequestMapping("/movies/edu-actor")
public class EduActorController {
    /**
     * 依赖注册service
     */
    @Autowired
    private EduActorService actorService;
    @ApiOperation("显示演员信息")
    @GetMapping("/list")
    public List list(){
        return actorService.list(null);
    }
}

3.4 编写逻辑删除(假删除)拦截器、编写分页的拦截器

• service_base模块中编写

package com.example.movies.config;
import com.baomidou.mybatisplus.core.injector.ISqlInjector;
import com.baomidou.mybatisplus.extension.injector.LogicSqlInjector;
import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.transaction.annotation.EnableTransactionManagement;
/**
 * 配置拦截器.
 */
@Configuration
@EnableTransactionManagement
public class MoviesConfig {
    /**
     * 逻辑删除插件
     * @return
     */
    @Bean
    public ISqlInjector sqlInjector() {
        return new LogicSqlInjector();
    }
    /**
     * 分页插件
     * @return
     */
    @Bean
    public PaginationInterceptor paginationInterceptor() {
        return new PaginationInterceptor();
    }
}

3.5 在service_base模块中完成自动填充

• 就是自动完成数据添加的时间和修改的时间及逻辑删除的默认值填写

• 编写实现

package com.example.movies.config;
import com.baomidou.mybatisplus.core.handlers.MetaObjectHandler;
import org.apache.ibatis.reflection.MetaObject;
import org.springframework.stereotype.Component;
import java.util.Date;
@Component
public class MyMetaObjectHandler implements MetaObjectHandler {
    @Override
    public void insertFill(MetaObject metaObject) { // 添加数据
        // 添加日期到指定的字段中
        setFieldValByName("gmtCreate", new Date(), metaObject);
        setFieldValByName("gmtModified", new Date(), metaObject);
        // 逻辑删除的默认值
        setFieldValByName("isDeleted", 0, metaObject);
    }
    @Override
    public void updateFill(MetaObject metaObject) { // 修改数据
        setFieldValByName("gmtModified", new Date(), metaObject);
    }
}

• 添加一个日志输出，方便代码的调试

#配置日志
mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl

• 在对应的实体Bean中添加

package com.example.movies.controller;
import com.example.movies.entity.EduActor;
import com.example.movies.service.EduActorService;
import io.swagger.annotations.ApiOperation;
import io.swagger.annotations.ApiParam;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import java.util.List;
/**
 * <p>
 * 演员 前端控制器
 * </p>
 */
@RestController
@RequestMapping("/movies/edu-actor")
public class EduActorController {
    /**
     * 依赖注册service
     */
    @Autowired
    private EduActorService actorService;
    @ApiOperation("显示演员信息")
    @GetMapping("/list")
    public List list(){
        return actorService.list(null);
    }
    @ApiOperation("保存演员数据")
    @PostMapping("/save")
    public void saveActor(EduActor actor) {
        actorService.save(actor);
    }
    @ApiOperation("逻辑删除演员")
    @DeleteMapping("del/{id}")
    public void delect(@ApiParam(name = "id", value = "演员的主键", required = true) @PathVariable String id) {
        actorService.removeById(id);
    }
}

3.6 在subProject_service模块中添加依赖

 <!--添加依赖-->
<dependency>
  <groupId>com.example</groupId>
  <artifactId>service_base</artifactId>
  <version>1.0-SNAPSHOT</version>
</dependency>

第四章：配置公共设置

4.1 公共的返回数据格式

• 在我们的项目中要求都是封装成json返回，一般我们会将所有接口的数据格式统一。
• 列表格式：

{
   "success":true,
   "code":20000,
   "message":"成功",
   "data":{
      "items":[
         {
            "id":"1001",
            "name":"刘德华",
            "intro":"香港的著名演员"
         }
      ]
   }
}

• 分页格式：

{
   "success":true,
   "code":20000,
   "message":"成功",
   "data":{
      "total":20,
      "rows":[
         {
            "id":"1001",
            "name":"刘德华",
            "intro":"香港的著名演员"
         }
      ]
   }
}

• 无返回数据格式

{
   "success":true,
   "code":20000,
   "message":"成功",
   "data":{}
}

• 失败数据格式

{
   "success":false,
   "code":20001,
   "message":"失败",
   "data":{}
}

• 统一格式：

{
   "success":布尔,//响应是否成功
   "code":数字,//响应码
   "message":字符串,//返回信息
   "data":HashMap//返回数据
}

4.2 在子模块public_common/common_util中创建

• 创建返回码的接口

package com.example.util;
/**
 * 返回码接口.    
 */
public interface ResultCode {
    /**
     * 成功
     */
    int SUCCESS = 20000;
    /**
     * 失败
     */
    int ERROR = 20001;
}

• 创建结果类

package com.example.util;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import java.util.HashMap;
import java.util.Map;
/**
 * 结果类.
 */
@Data
public class R {
    @ApiModelProperty("是否成功")
    private Boolean success;
    @ApiModelProperty("返回码")
    private Integer code;
    @ApiModelProperty("返回消息")
    private String message;
    @ApiModelProperty("返回数据")
    private Map<String, Object> data = new HashMap<>();
    public R() { } // 构造方法
    /**
     * 静态方法
     */
    public static R ok() {
        R r = new R();
        r.setSuccess(true);
        r.setCode(ResultCode.SUCCESS);
        r.setMessage("成功");
        return r;
    }
    public static R error() {
        R r = new R();
        r.setSuccess(false);
        r.setCode(ResultCode.ERROR);
        r.setMessage("失败");
        return r;
    }
    public R success(boolean success) {
        this.setSuccess(success);
        return this;
    }
    public R message(String message) {
        this.setMessage(message);
        return this;
    }
    public R code(int code) {
        this.setCode(code);
        return this;
    }
    public R data(String key, Object value) {
        this.data.put(key, value);
        return this;
    }
    public R data(Map<String, Object> map) {
        this.data(map);
        return this;
    }
}