SpringBoot整合MybatisPlus

• 一、引入依赖
• 二、application文件
• 三、建表
• 四、bean
• 五、mapper
• 六、测试

    org.projectlombok
    lombok




    mysql
    mysql-connector-java




    com.baomidou
    mybatis-plus-boot-starter
    3.4.3.4




    com.alibaba
    druid-spring-boot-starter
    1.2.8




    org.springframework.boot
    spring-boot-starter-test
    test
    
        
            org.junit.vintage
            junit-vintage-engine
        
    

# 应用名称
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

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;
}

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 {

}

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 lqw = new LambdaQueryWrapper<>();
//        lqw.select(User::getUsername);
//        List userList = userMapper.selectList(lqw);

        List userList = userMapper.selectList(null);

        System.out.println(userList);
    }

}