MyBatis Plus 入门案例

使用 Docker 部署 MySQL5.7

可使用navicat管理

使用 Spring Boot 项目进行 MyBatis Plus 入门程序开发

• 引入依赖

<dependencies>
	<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>mysql</groupId>
		<artifactId>mysql-connector-java</artifactId>
		<version>8.0.25</version>
	</dependency>
</dependencies>

• 使用逆向工程插件生成代码

<?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="club.dliksr.study.mapper.UserMapper">

    <resultMap id="BaseResultMap" type="club.dliksr.study.domain.User">
        <!--@mbg.generated-->
        <!--@Table `user`-->
        <id column="id" jdbcType="BIGINT" property="id"/>
        <result column="name" jdbcType="VARCHAR" property="name"/>
        <result column="email" jdbcType="VARCHAR" property="email"/>
        <result column="age" jdbcType="INTEGER" property="age"/>
    </resultMap>

    <sql id="Base_Column_List">
        <!--@mbg.generated-->
        id, `name`, email, age
    </sql>

</mapper>

package club.dliksr.study.mapper;

import club.dliksr.study.domain.User;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;

/**
 * <p>项目名称: webstudy </p>
 * <p>文件名称: club.dliksr.study.mapper.UserMapper </p>
 * <p>创建时间: 2021/7/18 </p>
 * <p>描述: TODO </p>
 *
 * @author <a href="mailto:dliksr.kou@gmail.com">dliksr</a>
 * @version v1.0
 */
@Mapper
public interface UserMapper extends BaseMapper<User> {
}

package club.dliksr.study.domain;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.*;

import java.io.Serializable;

/**
 * <p>项目名称: webstudy </p>
 * <p>文件名称: club.dliksr.study.domain.User </p>
 * <p>创建时间: 2021/7/18 </p>
 * <p>描述: TODO </p>
 *
 * @author <a href="mailto:dliksr.kou@gmail.com">dliksr</a>
 * @version v1.0
 */
@Getter
@Setter
@ToString
@Builder
@AllArgsConstructor
@NoArgsConstructor
@TableName(value = "`user`")
public class User implements Serializable {

    private static final long serialVersionUID = -3013316176612114576L;

    /**
     * 主键ID
     */
    @TableId(value = "id", type = IdType.AUTO)
    private Long id;

    /**
     * 姓名
     */
    @TableField(value = "`name`")
    private String name;

    /**
     * 邮箱
     */
    @TableField(value = "email")
    private String email;

    /**
     * 年龄
     */
    @TableField(value = "age")
    private Integer age;
}

• 编写测试类进行测试

package club.dliksr.study.mapper;

import org.junit.jupiter.api.Test;
import org.springframework.boot.test.context.SpringBootTest;

import javax.annotation.Resource;

/**
 * <p>项目名称: webstudy </p>
 * <p>文件名称: club.dliksr.study.mapper.UserMapperTest </p>
 * <p>创建时间: 2021/7/18 </p>
 * <p>描述: TODO </p>
 *
 * @author <a href="mailto:dliksr.kou@gmail.com">dliksr</a>
 * @version v1.0
 */
@SpringBootTest
public class UserMapperTest {

    @Resource
    UserMapper userMapper;

    @Test
    public void test(){
        userMapper.selectList(null).forEach(System.out::println);
    }
}

• 测试结果