使用 mybatisplus条件构造器进行简单的数据库操作

准备阶段
1.实体类(@TableName,与 @TableField很重要)

/**
 * @author: Boss
 * Date: 2021/1/14
 * Time: 10:31
 * Description:
 */
@Data
@AllArgsConstructor
@NoArgsConstructor
@Builder
@TableName(value = "clue_users")
public class UsersPO {
    @TableId
    private Integer pkId;

    @TableField(value = "user_id")
    private String userId;

    @TableField(value = "user_account")
    private String userAccount;

    @TableField(value = "user_password")
    private String userPassword;

    @TableField(value = "user_name")
    private String userName;

}

2.mapper (主要是要继承extends BaseMapper)

/**
 * @author: Boss
 * Date: 2021/1/14
 * Time: 16:34
 * Description:
 */
public interface UserMapper extends BaseMapper<UsersPO> {


}

3.进行操作

@Api(tags = {"测试接口"})
@Slf4j
@RestController
@RequestMapping("/test")
public class TestController {

    @Autowired
    private UserMapper userMapper;

    @GetMapping("/test1")
    public ResponseVO<Object> test1() {

        //查询1(QueryWrapper)(直接写列名)
        QueryWrapper<UsersPO> usersPOQueryWrapper = new QueryWrapper<>();
        usersPOQueryWrapper.select("user_id", "user_account")
                .eq("user_id", "USER-f519c").or().eq("user_id", "USER-b5fdc");
        List<UsersPO> objs = userMapper.selectList(usersPOQueryWrapper);
        objs.forEach(System.out::println);

        //查询2(LambdaQueryWrapper)(传函数mybatisplus会自动获取列名)
        LambdaQueryWrapper<UsersPO> usersPOLambdaQueryWrapper = new LambdaQueryWrapper<>();
        usersPOLambdaQueryWrapper.select(UsersPO::getUserId, UsersPO::getUserName)
                .eq(UsersPO::getUserId, "USER-f519c").or().eq(UsersPO::getUserId, "USER-b5fdc");
        List<UsersPO> objs2 = userMapper.selectList(usersPOLambdaQueryWrapper);
        objs2.forEach(System.out::println);

        //删除
        usersPOLambdaQueryWrapper.eq(UsersPO::getUserId, "USER-f519c");
        userMapper.delete(usersPOLambdaQueryWrapper);


        //更新1(UpdateWrapper)(直接写列名)
        UpdateWrapper<UsersPO> usersPOUpdateWrapper = new UpdateWrapper<>();
        usersPOUpdateWrapper.eq("user_id", "USER-f519c").set("user_id", "1-1-d-1");
        userMapper.update(null, usersPOUpdateWrapper);

        //更新2(LambdaUpdateWrapper)(传函数mybatisplus会自动获取列名)
        LambdaUpdateWrapper<UsersPO> usersPOLambdaUpdateWrapper = new LambdaUpdateWrapper<>();
        usersPOLambdaUpdateWrapper.eq(UsersPO::getUserId, "USER-f519c").set(UsersPO::getUserId, "1-1-d-1");
        userMapper.update(null, usersPOLambdaUpdateWrapper);

        return ResponseVO.buildSuccess();
    }

}