package com.dy.pipIrrDemo.mp;
|
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
|
import com.dy.common.multiDataSource.DataSourceContext;
|
import com.dy.pipIrrGlobal.daoDemo.DemoMpMapper;
|
import com.dy.pipIrrGlobal.pojoDemo.DemoMp;
|
import org.junit.Before;
|
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.Arrays;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
|
@RunWith(SpringRunner.class)
|
@SpringBootTest
|
public class MpTest2 {
|
|
@Autowired
|
private DemoMpMapper demoMpMapper ;
|
|
@Before
|
public void setup(){
|
DataSourceContext.set("ym");
|
}
|
|
@Test
|
public void selectById(){
|
DemoMp po = this.demoMpMapper.selectById(2023110716001900000L) ;
|
System.out.println(po);
|
}
|
@Test
|
public void selectBatchIds(){
|
List<Long> listIds = Arrays.asList(1L, 2L, 2023110716001900000L) ;
|
List<DemoMp> poList = this.demoMpMapper.selectBatchIds(listIds) ;
|
System.out.println(poList);
|
}
|
@Test
|
public void selectByMap(){
|
Map<String, Object > paramMap = new HashMap<>() ;
|
paramMap.put("name", "李四");
|
paramMap.put("age", "22") ;
|
List<DemoMp> poList = this.demoMpMapper.selectByMap(paramMap) ;
|
System.out.println(poList);
|
}
|
|
@Test
|
public void selectByWrapperLt(){
|
QueryWrapper<DemoMp> queryWrapper = new QueryWrapper<>();
|
//QueryWrapper<DemoMp> queryWrapper = Wrappers.<DemoMp>query() ;
|
queryWrapper.like("name", "四").lt("age", 40) ;
|
List<DemoMp> poList = this.demoMpMapper.selectList(queryWrapper) ;
|
poList.forEach(System.out::println);
|
}
|
|
@Test
|
public void selectByWrapperBt(){
|
QueryWrapper<DemoMp> queryWrapper = new QueryWrapper<>();
|
//QueryWrapper<DemoMp> queryWrapper = Wrappers.<DemoMp>query() ;
|
queryWrapper.like("name", "四")
|
.between("age", 20, 40)
|
.isNotNull("dt");
|
List<DemoMp> poList = this.demoMpMapper.selectList(queryWrapper) ;
|
poList.forEach(System.out::println);
|
}
|
|
@Test
|
public void selectByWrapperOr(){
|
QueryWrapper<DemoMp> queryWrapper = new QueryWrapper<>();
|
//QueryWrapper<DemoMp> queryWrapper = Wrappers.<DemoMp>query() ;
|
queryWrapper.like("name", "四")
|
.or()
|
.between("age", 20, 40)
|
.isNotNull("dt")
|
.orderByAsc("id")
|
.orderByAsc("age");
|
List<DemoMp> poList = this.demoMpMapper.selectList(queryWrapper) ;
|
poList.forEach(System.out::println);
|
}
|
|
@Test
|
public void selectByWrapperOr1(){
|
QueryWrapper<DemoMp> queryWrapper = new QueryWrapper<>();
|
//QueryWrapper<DemoMp> queryWrapper = Wrappers.<DemoMp>query() ;
|
queryWrapper.likeLeft("name", "四")
|
.and(wq->wq.between("age", 20, 40).or().isNotNull("dt"))
|
.orderByAsc("id")
|
.orderByAsc("age");
|
List<DemoMp> poList = this.demoMpMapper.selectList(queryWrapper) ;
|
poList.forEach(System.out::println);
|
}
|
|
@Test
|
public void selectByWrapperOr2(){
|
QueryWrapper<DemoMp> queryWrapper = new QueryWrapper<>();
|
//QueryWrapper<DemoMp> queryWrapper = Wrappers.<DemoMp>query() ;
|
queryWrapper.likeLeft("name", "四")
|
.and(wq->wq.between("age", 20, 40).isNotNull("dt"))
|
.orderByAsc("id")
|
.orderByAsc("age");
|
List<DemoMp> poList = this.demoMpMapper.selectList(queryWrapper) ;
|
poList.forEach(System.out::println);
|
}
|
|
@Test
|
public void selectByWrapperOr3(){
|
QueryWrapper<DemoMp> queryWrapper = new QueryWrapper<>();
|
//QueryWrapper<DemoMp> queryWrapper = Wrappers.<DemoMp>query() ;
|
queryWrapper.likeLeft("name", "四")
|
.or(wq->wq.lt("age", 100).gt("age", 10).isNotNull("dt"))
|
.orderByAsc("id")
|
.orderByAsc("age");
|
List<DemoMp> poList = this.demoMpMapper.selectList(queryWrapper) ;
|
poList.forEach(System.out::println);
|
}
|
|
@Test
|
public void selectByWrapperOr4(){
|
QueryWrapper<DemoMp> queryWrapper = new QueryWrapper<>();
|
//QueryWrapper<DemoMp> queryWrapper = Wrappers.<DemoMp>query() ;
|
queryWrapper.nested(wq->wq.lt("age", 50).or().isNotNull("dt"))
|
.likeLeft("name", "四")
|
.orderByAsc("id")
|
.orderByAsc("age");
|
List<DemoMp> poList = this.demoMpMapper.selectList(queryWrapper) ;
|
poList.forEach(System.out::println);
|
}
|
|
|
@Test
|
public void selectByWrapperAnd(){
|
QueryWrapper<DemoMp> queryWrapper = new QueryWrapper<>();
|
//QueryWrapper<DemoMp> queryWrapper = Wrappers.<DemoMp>query() ;
|
queryWrapper.likeLeft("name", "四")
|
.and(wq->wq.between("age", 20, 40))
|
.isNotNull("dt")
|
.orderByAsc("id")
|
.orderByAsc("age");
|
List<DemoMp> poList = this.demoMpMapper.selectList(queryWrapper) ;
|
poList.forEach(System.out::println);
|
}
|
|
|
@Test
|
public void selectByWrapperIn(){
|
QueryWrapper<DemoMp> queryWrapper = new QueryWrapper<>();
|
//QueryWrapper<DemoMp> queryWrapper = Wrappers.<DemoMp>query() ;
|
queryWrapper.in("age", Arrays.asList(38, 45))
|
.orderByAsc("id")
|
.orderByAsc("age");
|
List<DemoMp> poList = this.demoMpMapper.selectList(queryWrapper) ;
|
poList.forEach(System.out::println);
|
}
|
|
@Test
|
public void selectByWrapperLimit(){
|
QueryWrapper<DemoMp> queryWrapper = new QueryWrapper<>();
|
//QueryWrapper<DemoMp> queryWrapper = Wrappers.<DemoMp>query() ;
|
queryWrapper.in("age", Arrays.asList(38, 45)).last("limit 1")
|
.orderByAsc("id")
|
.orderByAsc("age");
|
List<DemoMp> poList = this.demoMpMapper.selectList(queryWrapper) ;
|
poList.forEach(System.out::println);
|
}
|
|
@Test
|
public void selectByWrapperLimitSupper(){
|
QueryWrapper<DemoMp> queryWrapper = new QueryWrapper<>();
|
//QueryWrapper<DemoMp> queryWrapper = Wrappers.<DemoMp>query() ;
|
queryWrapper.select("id", "name").in("age", Arrays.asList(38, 45)).last("limit 1")
|
.orderByAsc("id")
|
.orderByAsc("age");
|
List<DemoMp> poList = this.demoMpMapper.selectList(queryWrapper) ;
|
poList.forEach(System.out::println);
|
}
|
|
}
|
