springboot+mybatis-plus快速搭建CRUD（黑马springboot）

一、数据库准备

• 在navicat中创建数据库ssm_db，表名为tbl_book
• 

二、打开最喜欢的idea，创建springboot工程，选择spring web和Mysql driver

1. 将application.property文件改为yml文件*

**pop.xml中缺mybatis-plus-boot-starter、druid-spring-boot-starter、以及lombok（切记导完坐标务必刷新maven）**下面是完整的pop.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 https://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.7.0</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>com.luoke</groupId>
    <artifactId>springboot_01_test01</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <properties>
        <java.version>1.8</java.version>
    </properties>
    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.4.3</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.2.6</version>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>

</project>

2.创建domain.Book实体类

package com.luoke.domain;
import lombok.Data;
//lombok插件中包含了get、set方法
@Data
public class Book {
    private String id;
    private String type;
    private String name;
    private String description;
}

3.数据层开发用Druid

• application.yml中的配置（记得修改成自己的数据库名称和密码）

server:
  port: 80

spring:
  datasource:
    druid:
      driver-class-name: com.mysql.cj.jdbc.Driver
      url: jdbc:mysql://localhost:3306/ssm_db?serverTimezone=UTC
      username: root
      password: 1234

mybatis-plus:
  configuration:
    log-prefix: tbl_#我的表是tbl_book,这样写会在后期代码中不用加前缀，比较简便

• 创建dao.BookDao接口

package com.luoke.dao;

import com.luoke.domain.Book;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface BookDao {

    @Select("select * from tbl_book where id = #{id}")
    Book getById(Integer id);
}

然后就可以去测式类中去测试这个方法了

• 在test中创建dao.BookDaoTestCase

 - package com.luoke.dao;

import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

@SpringBootTest
public class BookDaoTestCase {

    @Autowired
    private BookDao bookDao;

    @Test
    void testGetById(){
        System.out.println(bookDao.getById(1));
    }

}

然后启动测试类

然后就成功了！！！后续