mybatisplus 增删改查(普通)

一、insert

主键生成策略

1、雪花算法(默认)插入

@Test
public void insertSql(){
    User user = new User();
    user.setName("zwj");
    user.setAge(18);
    user.setEmail("917199375@qq.com");
    userMapper.insert(user);
}

2、自增 修改实体类

package com.zwj.entity;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {

    @TableId(type = IdType.AUTO)
    private Integer id;
    
    private String name;
    
    private Integer age;
    
    private String email;
}

二、update

@Test
public void updateUser(){
    User user = new User();
    user.setId(10);
    user.setName("zhangwuji");
    userMapper.updateById(user);
}

三、select

@Test
    // 查询通过ID
    public void selectByID(){
        User user = userMapper.selectById(1);
        System.out.println(user);
    }

@Test
// 查询通过ids
public void  selectBatchByIds(){
    List<User> userList = userMapper.selectBatchIds(Arrays.asList(1, 3, 5));
    for (User user : userList) {
        System.out.println(user);
    }
}

@Test
// 查询通过 map
public void selectByMap(){
    Map<String, Object> map = new HashMap<>();
    map.put("name", "zhaomin");
    List<User> userList = userMapper.selectByMap(map);
    for (User user : userList) {
        System.out.println(user);
    }
}

@Test
// 查询所有
public void selectAll(){
    List<User> userList = userMapper.selectList(null);
    for (User user : userList) {
        System.out.println(user);
    }
}

四、delete

@Test
// 根据 ID 删除
public void deleteById(){
    userMapper.deleteById(1);
}

@Test
// 根据 ID 批量删除
public void deleteBatch(){
    userMapper.deleteBatchIds(Arrays.asList(1, 2));
}

@Test
// 根据 map 删除
public void deleteByMap(){
    Map<String, Object> map = new HashMap<>();
    map.put("name", "zhouhiznuo");
    userMapper.deleteByMap(map);
}