mybatisPlus常见查询

实体类

package com.mujin.entity;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

/**
 * author:mujin
 * Date:2021/11/2910:33
 */

@Data
@AllArgsConstructor
@NoArgsConstructor
public class PiccConfigInfo {
    private Integer id;
    private String configCode;
    private String configName;
    private String configValue;
    private String configValueDesc;
    private String levelCode;
    private String insertTimeForhis;
    private String vaildStutus;

}

mapper接口

package com.mujin.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.mujin.entity.PiccConfigInfo;

/**
 * author:mujin
 * Date:2021/11/2910:36
 */
public interface PiccConfigInfoMapper extends BaseMapper<PiccConfigInfo> {

}

常见方法测试类

package com.mujin;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.mujin.entity.PiccConfigInfo;
import com.mujin.mapper.PiccConfigInfoMapper;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;

import java.util.*;

/**
 * author:mujin
 * Date:2021/11/2910:37
 */
@SpringBootTest
@RunWith(SpringRunner.class)
public class Test1 {

    @Autowired
    private PiccConfigInfoMapper piccConfigInfoMapper;

    @Test
    public void testSelectMapsPage(){
        QueryWrapper<PiccConfigInfo> queryWrapper = new QueryWrapper<>();
        Page<Map<String,Object>> page = new Page<>(0,20);
        Page<Map<String,Object>> pageList = piccConfigInfoMapper.selectMapsPage(page, queryWrapper);
        List list = pageList.getRecords();
        System.out.println(list.size());
        list.forEach(System.out::println);
    }

    @Test
    public void testSelectPage(){
        QueryWrapper<PiccConfigInfo> queryWrapper = new QueryWrapper<>();
        Page<PiccConfigInfo> page = new Page<>(0,20);
        Page<PiccConfigInfo> pageList = piccConfigInfoMapper.selectPage(page, queryWrapper);
        List<PiccConfigInfo> list = pageList.getRecords();
        System.out.println(list.size());
        list.forEach(System.out::println);
    }

    @Test
    public void testSelectMaps(){
        //返回Map集合对象
        //SELECT id,configCode,configName,configValue,configValueDesc,levelCode,insertTimeForhis,vaildStutus
        // FROM picc_config_info
        // WHERE (configName LIKE ? AND id LIKE ?)
        //Parameters: %评价%(String), %10%(String)
        QueryWrapper<PiccConfigInfo> queryWrapper = new QueryWrapper<>();
        queryWrapper.like("configName","评价");
        queryWrapper.like("id", 10);
        List<Map<String,Object>> list = piccConfigInfoMapper.selectMaps(queryWrapper);
        list.forEach(System.out::println);

    }

    @Test
    public void testSelectList(){
        //SELECT id,configCode,configName,configValue,configValueDesc,levelCode,insertTimeForhis,vaildStutus
        // FROM picc_config_info
        // WHERE (configName LIKE ? AND id LIKE ?)
        //Parameters: %评价%(String), %10%(String)
        QueryWrapper<PiccConfigInfo> queryWrapper = new QueryWrapper<>();
        queryWrapper.like("configName","评价");
        queryWrapper.like("id", 10);
        List<PiccConfigInfo> list = piccConfigInfoMapper.selectList(queryWrapper);
        list.forEach(System.out::println);
    }


    @Test
    public void testSelectCount(){
        //SELECT COUNT( * ) FROM picc_config_info WHERE (id = ? AND configCode = ?)
        QueryWrapper<PiccConfigInfo> queryWrapper = new QueryWrapper<>();
        queryWrapper.eq("id", 1974757771).eq("configCode","wechatServiceIp");
        Integer count = piccConfigInfoMapper.selectCount(queryWrapper);
        System.out.println(count);
    }

    //只能返回一条记录数，多会报错
    @Test
    public void testSelectOne(){
        //SELECT id,configCode,configName,configValue,configValueDesc,levelCode,insertTimeForhis,vaildStutus
        // FROM picc_config_info
        // WHERE (id = ? AND configCode = ?)
        QueryWrapper<PiccConfigInfo> queryWrapper = new QueryWrapper<>();
        queryWrapper.eq("id", 1974757771).eq("configCode","wechatServiceIp");
        PiccConfigInfo piccConfigInfo = piccConfigInfoMapper.selectOne(queryWrapper);
        System.out.println(piccConfigInfo);
    }


    @Test
    public void testSelectByMap(){
        //SELECT id,configCode,configName,configValue,configValueDesc,levelCode,insertTimeForhis,vaildStutus
        // FROM picc_config_info
        // WHERE configCode = ?
        // AND id = ?
        HashMap<String,Object> thisMap = new HashMap<>();
        thisMap.put("id", 1974757771);
        thisMap.put("configCode","wechatServiceIp");
        List<PiccConfigInfo> list = piccConfigInfoMapper.selectByMap(thisMap);
        list.forEach(System.out::println);
    }


    @Test
    public void testSelectBatchIds(){
        //SELECT id,configCode,configName,configValue,configValueDesc,levelCode,insertTimeForhis,vaildStutus
        // FROM picc_config_info
        // WHERE id IN ( ? , ? , ? )
        List<Integer> isList = Arrays.asList(2065473541,1239327872,812930411);
        List<PiccConfigInfo> list = piccConfigInfoMapper.selectBatchIds(isList);
        list.forEach(System.out::println);
    }

    @Test
    public void testSelectById(){
        PiccConfigInfo piccConfigInfo = piccConfigInfoMapper.selectById(1859522099);
        System.out.println(piccConfigInfo);
    }

    @Test
    public void testGet(){
        List<PiccConfigInfo> list = piccConfigInfoMapper.selectList(null);
        list.forEach(System.out::println);
    }

}