Java编程-集成mybatis plus以及数据库初始化

1. 数据库初始化
1. 新建对应调试库

# docker ps
# docker exec -it 6d542566d077 /bin/bash
postgres=#create database novel;

2. 执行全量脚本





2. 集成mybatis plus
1. 新建对应目录
2. 新建对应接口



3. 集成mybatis plus依赖



<version>2.1.6.RELEASE</version>
<mybatis.plus.version>3.1.2</mybatis.plus.version>
<dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>${mybatis.plus.version}</version>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-generator</artifactId>
            <version>${mybatis.plus.version}</version>
        </dependency>

4. 配置mybatis plus的XML扫描路径



mybatis-plus:
  #  mapperLocations: classpath:mapping/*Mapper.xml
  #  typeAliasesPackage: com.tdx.account_service.entity
  mapper-locations: classpath:mapping/*Mapper.xml

spring:
  datasource:
    url: jdbc:postgresql://47.108.52.160:5432/novel?useUnicode=true&characterEncoding=utf-8
    username: root
    password: 88888888

5. 补充mapper层XML