搭建MyBatis plus 入门（maven）

版本：idea2020.1.1    jdk1.8   maven3.6.3

1.搭建一个maven项目

详见（https://blog.csdn.net/qq_44759192/article/details/114296147?spm=1001.2014.3001.5501）

目录结构如下

2.编辑pom.xml文件，添加maven依赖 

<parent>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-parent</artifactId>
    <version>2.0.1.RELEASE</version>
    <relativePath/>
</parent>

  <dependencies>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <scope>test</scope>
    </dependency>
    <!--springboot 依赖-->
    <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter</artifactId>
    </dependency>
    <!--mybatis-plus 的依赖-->
    <dependency>
      <groupId>com.baomidou</groupId>
      <artifactId>mybatis-plus-boot-starter</artifactId>
      <version>3.4.2</version>
    </dependency>
    <!--        MySQL 的驱动-->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <scope>5.1.7</scope>
    </dependency>
    <!-- lombok 省去写 set get 的操作-->
    <dependency>
      <groupId>org.projectlombok</groupId>
      <artifactId>lombok</artifactId>
      <version>1.18.16</version>
    </dependency>
    <!--  springboot 单元测试的依赖-->

    <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-test</artifactId>
      <scope>test</scope>
    </dependency>

    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>RELEASE</version>
      <scope>compile</scope>
    </dependency>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.13.2</version>
    </dependency>
    <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-test</artifactId>
      <version>2.1.1.RELEASE</version>
      <scope>compile</scope>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-test</artifactId>
      <version>5.0.5.RELEASE</version>
      <scope>compile</scope>
    </dependency>
  </dependencies>

 3.创建数据库和与其对应的po实体类

数据库的建立

CREATE TABLE IF NOT EXISTS `user` (
  `id` int(10) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL,
  `pass` varchar(50) NOT NULL,
  PRIMARY KEY  (`id`)
) 

INSERT INTO `user` (`id`, `name`, `pass`) VALUES
	(2, '李四', '21');

 java实体类代码

@Data
public class User {
    private Integer id;
    private String name;
    private String pass;
}

 4.配置application.yml文件

在resources包下建立一个application.yml并添加如下代码（username 和 password根据自己的数据库账号密码填写）

spring:
  datasource:
    driver-class-name: com.mysql.jdbc.Driver
    url: jdbc:mysql://localhost:3306/test
    username: root
    password: x5

5.建立Mapper接口与实体类关联

@Mapper
@Component(value="UserMapper")
public interface UserMapper extends BaseMapper<User> {}

6. 编写springboot启动类

@MapperScan注解是为了找到第5步建立的Mapper接口

@SpringBootApplication
@MapperScan("com.jc.dao")
public class Run {
    public static void main(String[] args) {
        SpringApplication.run(Run.class, args);
    }
}

 7.编写测试类

@RunWith(SpringRunner.class)
@SpringBootTest
public class TestS {
    @Autowired
    private UserMapper userMapper;
    @Test
    public void testSelect() {
        List<User> userList = userMapper.selectList(null);
        userList.forEach(System.out::println);
        User user = userMapper.selectById(2);
        System.out.println(user);
    }
}

8.查看测试结果

第一条结果是我查询了表的全部数据出来的，第二条结果是根据id查询的数据