SpringBoot---MybatisPlus

导入依赖

    <!--springboot工程需要继承的父工程-->
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.1.8.RELEASE</version>
    </parent>

    <dependencies>
        <!-- mybatis-plus支持 -->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.1.2</version>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter</artifactId>
        </dependency>
        <!-- MySql -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.47</version>
        </dependency>
        <!--简化bean代码的工具包-->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
            <version>1.18.4</version>
        </dependency>
    </dependencies>

application.yml配置文件

server:
  port: 8000
spring:
  application:
    name: goods
  datasource:
    driver-class-name: com.mysql.jdbc.Driver
    url: jdbc:mysql://localhost:3307/test?serverTimezone=UTC
    username: root
    password: root

mybatis-plus:
  configuration:
    map-underscore-to-camel-case: false #自动驼峰命名
  type-enums-package: com.eunm  //枚举
  mapper-locations: classpath*:mapper/*.xml #配置文件地址
  type-aliases-package: com.domain

模块结构

domain

@Data
@TableName("person")  //表名
public class Person {
    @TableId(type = IdType.AUTO)  //主键
    private Integer id;
    private String name;
    private Integer age;
    private sex person_sex;
}

dao

public interface PersonMapper extends BaseMapper<Person> {

    public List<Person> selectAll();
}

继承BaseMapper可以使用一些简单的基础方法

enum

public enum  sex implements IEnum<Integer> {
    MAN(1,"男"),
    WOMAN(2,"女");

    private Integer value;
    private String sex;

    sex(int value, String sex) {
        this.value=value;
        this.sex=sex;
    }

    @Override
    public Integer getValue() {
        return this.value;
    }

    @Override
    public String toString() {
        return this.sex;
    }
}

启动类

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

PersonMapper.xml自定义的查询方法

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.dao.PersonMapper"> //全类名

    <select id="selectAll" resultType="Person">
        select * from person
    </select>

</mapper>

测试

@SpringBootTest(classes = PlusApplication.class)
@RunWith(SpringRunner.class)
public class PersonServiceTest {

    @Autowired
    private PersonMapper personMapper;

    @Test
    public void selectById(){
        Person person = personMapper.selectById(1);
        System.out.println(person);
    }

    @Test
    public void save(){
        Person person = new Person();
        person.setName("aa");
        person.setAge(15);
        person.setPerson_sex(sex.MAN);
        int insert = personMapper.insert(person);
    }

    @Test
    public void selectAll(){
        List<Person> people = personMapper.selectAll();
        System.out.println(people);
    }
}

selectById

selectAll

save