【java】【MyBatisPlus】【一】快速入门程序

目录

1、创建空项目mybatisProject

2、创建springboot模块

3、删除多余文件

4、修改pom，引入mybatisplus

5、设置application.yml

6、配置logback.xml减少控制台输出

7、准备实体Emp

8、创建EmpMapper接口

9、测试MybatisQuickstartApplicationTests

---

前言：学习MyBatisPlus的基本使用，MyBatisPlus是基于MyBatis框架基础上开发的增强型工具，旨在简化开发、提高效率。本教程基于SpringBoot使用MyBatisPlus

1、创建空项目mybatisProject

创建略，（下面这个设置必须要设置，不然创建模块pom会加载失败）

2、创建springboot模块

3、删除多余文件

4、修改pom，引入mybatisplus

<?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>
        <!-- 1、修改为2.7.5 -->
        <version>2.7.5</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>com.bocai</groupId>
    <artifactId>mybatis_quickstart</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <!--   2、 删除这里
    <name>mybatis_quickstart</name>
    <description>mybatis_quickstart</description>
    -->
    <properties>
        <java.version>1.8</java.version>
    </properties>
    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter</artifactId>
        </dependency>

        <dependency>
            <groupId>com.mysql</groupId>
            <artifactId>mysql-connector-j</artifactId>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
        <!--  3、 引入mybatisplus -->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.4.2</version>
        </dependency>
        <!--  4、 引入druid -->
        <!--
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.21</version>
        </dependency>
        -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.23</version>
        </dependency>

        <!--   5、lombok -->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
            <scope>provided</scope> <!-- 不打包 -->
            <version>1.18.24</version>
        </dependency>
    </dependencies>

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

</project>

 

5、设置application.yml

spring:
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/mybatis?serverTimezone=UTC
    username: root
    password: XXX2050
  main:
    banner-mode: off  # 关闭控制台springboot的logo
mybatis-plus:
  configuration:
    #在映射实体或者属性时，将数据库中表名和字段名中的下划线去掉，按照驼峰命名法映射
    map-underscore-to-camel-case: true
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl  # 控制台显示sql
  global-config:
    db-config:
      id-type: ASSIGN_ID
    banner: false   # 关闭控制台mybatis-plus的logo

6、配置logback.xml减少控制台输出

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
    
</configuration> 

7、准备实体Emp

Emp

package com.bocai.entity;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.time.LocalDate;
import java.time.LocalDateTime;

/**
 * 员工实体类
 */
@Data
@NoArgsConstructor
@AllArgsConstructor
public class Emp {
    private Integer id; //ID
    private String username; //用户名
    private String password; //密码
    private String name; //姓名
    private Short gender; //性别 , 1 男, 2 女
    private String image; //图像url
    private Short job; //职位 , 1 班主任 , 2 讲师 , 3 学工主管 , 4 教研主管 , 5 咨询师
    private LocalDate entrydate; //入职日期
    private Integer deptId; //部门ID
    private LocalDateTime createTime; //创建时间
    private LocalDateTime updateTime; //修改时间
}

8、创建EmpMapper接口

package com.bocai.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.bocai.entity.Emp;
import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface EmpMapper extends BaseMapper<Emp> {
}

9、测试MybatisQuickstartApplicationTests

 在MybatisQuickstartApplicationTests编写测试

package com.bocai;

import com.bocai.entity.Emp;
import com.bocai.mapper.EmpMapper;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

import java.util.List;

@SpringBootTest
class MybatisQuickstartApplicationTests {

    @Autowired
    private EmpMapper empMapper;

    @Test
    void testGetAll() {
        List<Emp> empList = empMapper.selectList(null);
        System.out.println(empList);
    }

}