mybatisPlus常见查询

常见查询"/>

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 {@Autowiredprivate PiccConfigInfoMapper piccConfigInfoMapper;@Testpublic 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);}@Testpublic 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);}@Testpublic 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);}@Testpublic 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);}@Testpublic 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);}//只能返回一条记录数，多会报错@Testpublic 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);}@Testpublic 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);}@Testpublic 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);}@Testpublic void testSelectById(){PiccConfigInfo piccConfigInfo = piccConfigInfoMapper.selectById(1859522099);System.out.println(piccConfigInfo);}@Testpublic void testGet(){List<PiccConfigInfo> list = piccConfigInfoMapper.selectList(null);list.forEach(System.out::println);}}