SpringBoot整合MybatisPlus

---

一、引入依赖

<!-- lombok -->
<dependency>
    <groupId>org.projectlombok</groupId>
    <artifactId>lombok</artifactId>
</dependency>

<!-- connector -->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
</dependency>

<!-- Mybatis Plus -->
<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>3.4.3.4</version>
</dependency>

<!-- druid -->
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid-spring-boot-starter</artifactId>
    <version>1.2.8</version>
</dependency>

<!-- test -->
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-test</artifactId>
    <scope>test</scope>
    <exclusions>
        <exclusion>
            <groupId>org.junit.vintage</groupId>
            <artifactId>junit-vintage-engine</artifactId>
        </exclusion>
    </exclusions>
</dependency>

---

二、application文件

# 应用名称
spring:
  application:
    name: jwtLogin
  datasource:
    druid:
      url: jdbc:mysql://192.168.0.46:3306/login_test?useSSL=false&serverTimezone=UTC
      username: python
      password: 123456
      driver-class-name: com.mysql.jdbc.Driver

# 应用服务 WEB 访问端口
server:
  port: 8848

---

三、建表

---

四、bean

package com.cxstar.bean;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import lombok.Data;

@Data
public class User {
    // 自增长id
    @TableId(type = IdType.AUTO)
    private Integer id;

    private String username;
    private String password;
}

---

五、mapper

package com.cxstar.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.cxstar.bean.User;
import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface UserMapper extends BaseMapper<User> {

}

---

六、测试

package com.cxstar;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.cxstar.bean.User;
import com.cxstar.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 JwtLoginApplicationTests {

    @Autowired
    public UserMapper userMapper;

    @Test
    void insert() {
        User user = new User();
        user.setUsername("ps");
        user.setPassword("123");
        Integer count = userMapper.insert(user);
        System.out.println(count);
    }

    @Test
    void selectAll() {

//        LambdaQueryWrapper<User> lqw = new LambdaQueryWrapper<>();
//        lqw.select(User::getUsername);
//        List<User> userList = userMapper.selectList(lqw);

        List<User> userList = userMapper.selectList(null);

        System.out.println(userList);
    }

}