14.SpringCloud实战项目-整合MyBatis-Plus实现CRUD

<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>3.2.0</version>
</dependency>

<!--添加mysql驱动-->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.17</version>
</dependency>

spring:
  datasource:
      driver-class-name:com.mysql.cj.jdbc.Driver
      url:jdbc:mysql://129.211.188.xxx:3306/passjava_admin?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
      username:root
      password:xxx

mybatis-plus:
  mapper-locations: classpath:/mapper/**/*.xml
  global-config:
    db-config:
      id-type: auto

@MapperScan("com.jackson0714.passjava.question.dao")
@SpringBootApplication
publicclass PassjavaQuestionApplication {
    public static void main(String[] args) {
        SpringApplication.run(PassjavaQuestionApplication.class, args);
    }
}

@Autowired
TypeService typeService;

// 创建题目类型
@Test
void testCreateType() {
    TypeEntity typeEntity = new TypeEntity();
    typeEntity.setType("javaBasic");
    typeService.save(typeEntity);
    System.out.println("创建成功");
}

// 更新type=jvm
@Test
void testUpdateType() {
    TypeEntity typeEntity = new TypeEntity();
    typeEntity.setId(1L);
    typeEntity.setType("jvm");
    typeService.updateById(typeEntity);
    System.out.println("修改成功");
}

// 查询题目类型
@Test
void testSelectType() {
    List<TypeEntity> typeEntityList = typeService.list(new QueryWrapper<TypeEntity>().eq("id",1L));
    typeEntityList.forEach((item)-> {
        System.out.println(item);
    });
    System.out.println("查询成功");
}

// 删除题目类型记录
@Test
void testRemoveType() {
    typeService.removeById(1L);
    System.out.println("删除成功");
}