Mybatis-plus入门

springboot项目

导入依赖

<!--数据库驱动-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <!--lombok-->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
        </dependency>
        <!--mybstis-plus-->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.0.5</version>
        </dependency>

写配置

spring.datasource.username=root
spring.datasource.password=root
spring.datasource.url=jdbc:mysql://localhost:3306/mybatisplus?useSSL=true&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
#配置日志
mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl

准备工作

实体类

import java.util.Date;

@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {
    @TableId(type= IdType.AUTO)
    private Long id;//数据库字段设置为是自增的
    private String name;
    private Integer age;
    private String email;
    /*@TableField(fill = FieldFill.INSERT)*/
    private Date createTime;
    /*@TableField(fill = FieldFill.UPDATE)*/
    private Date updateTime;
}

Mapper接口

package com.jun.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.jun.beans.User;
import org.springframework.stereotype.Repository;

@Repository
public interface UserMapper extends BaseMapper<User> {

}

注意点：BaseMapper<User>是必须的，javabean会和字段自动映射

应用需要加一个注解@MapperScan("com.jun.mapper")

package com.jun;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@MapperScan("com.jun.mapper")
@SpringBootApplication
public class TestmpApplication {

    public static void main(String[] args) {
        SpringApplication.run(TestmpApplication.class, args);
    }

}

测试

package com.jun;

import com.jun.beans.User;
import com.jun.mapper.UserMapper;
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 TestmpApplicationTests {
    @Autowired
    UserMapper userMapper;
    @Test
    /**
     * 查询全部
     */
    void contextLoads() {
        List<User> users = userMapper.selectList(null);
        for(User u:users){
            System.out.println(u);
        }
    }

    /**
     * 全字段插入
     */
    @Test
    void TestAdd(){
        User user = new User();
        user.setName("zcj");
        user.setAge(22);
        user.setEmail("lukas@sina.com");
        int result = userMapper.insert(user);//自动生成id
        System.out.println(user);//id自动回填
        System.out.println(result);
    }
    /**
     * 更新操作
     */
    @Test
    void testUpdate(){
        User user = new User();
        user.setId(5L);
        user.setName("大巴票");
        userMapper.updateById(user);
    }
}