MyBatis-Plus使用小结

官网：

https://mybatis.plus/

https://gitee.com/baomidou/mybatis-plus

https://github.com/baomidou/mybatis-plus

1.引入依赖：

 		<dependency>

            <groupId>com.baomidou</groupId>

            <artifactId>mybatis-plus-boot-starter</artifactId>

            <version>3.3.1.tmp</version>

        </dependency>

2.编写自己接口继承BaseMapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;

@Repository

public interface StuDescMapper extends BaseMapper<StuDesc> {}

3.设置yml文件，官方配置介绍https://mybatis.plus/config/

spring:

  datasource:

    name: student_info

    url: jdbc:mysql://127.0.0.1:3306/student_info?serverTimezone=GMT%2B8

    username: root

    password: test

    driver-class-name: com.mysql.cj.jdbc.Driver

server:

  port: 9090

#根据自己的需求配置

mybatis-plus:

 mapperLocations: classpath:mapper/*.xml

 configuration :

  mapUnderscoreToCamelCase: true

 globalConfig:

  banner: true

4.编辑实体，官方注解说明https://mybatis.plus/guide/annotation.html

@TableName(value = "s_desc")

public class StuDesc {

    private String id;

    @TableId

    private Integer userId;

    private String scoreLevel;

    @TableField(value = "`desc`")

    private String desc;

5.crdu的使用

查询条件的构造：

QueryWrapper<StuDesc> stuDescQueryWrapper = new QueryWrapper<>();

(1)QueryWrapper可以直接填充实体StuDesc，根据实体的内容去执行；

(2)QueryWrapper也可构造添加去执行，stuDescQueryWrapper.eq(“表字段名”,“具体的值”);

附加：MyBatis-Plus功能很强大，还有很多功能可以使用，

CRUD 接口：https://mybatis.plus/guide/crud-interface.html

条件构造器：https://mybatis.plus/guide/wrapper.html

巴特西

MyBatis-Plus使用小结

最新文章

热门文章