mybatis plus 查询数量_Mybatis Plus各种查询方法

Mybatis Plus各种查询方法

Mybatis Plus各种查询方法

package com.xiao.permission_system;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;

import com.baomidou.mybatisplus.extension.service.additional.query.impl.LambdaQueryChainWrapper;

import com.mysql.cj.util.StringUtils;

import com.xiao.permission_system.entity.UserInfo;

import com.xiao.permission_system.mapper.UserInfoMapper;

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 PermissionSystemApplicationTests {

@Test

public void contextLoads() {

}

@Autowired

private UserInfoMapper userInfoMapper;

/**

* 普通查询

*/

@Test

public void selectById() {

UserInfo userInfo = userInfoMapper.selectById(123);

System.out.println(userInfo);

}

/**

* 批量查询

*/

@Test

public void selectByIds() {

List ids = Arrays.asList(123L,124L,125L);

List userInfo = userInfoMapper.selectBatchIds(ids);

System.out.println(userInfo);

}

/**

* 名字包含娟并且年龄小雨30

*/

@Test

public void selectByWrapper() {

QueryWrapper queryWrapper = new QueryWrapper();

queryWrapper.like("username","娟").lt("age",30);

List userInfoList = userInfoMapper.selectList(queryWrapper);

userInfoList.forEach(System.out::println);

}

/**

* 名字包含娟并且年龄大雨等于20且小于等于40并且email不为空

*/

@Test

public void selectByWrapper2() {

QueryWrapper queryWrapper = new QueryWrapper();

queryWrapper.like("username","娟").between("age",20,30).isNotNull("email");

List userInfoList = us