网站悬浮二维码,新浪云部署wordpress,it培训机构有哪些,英文网站模板源代码QueryWrapper, mybatisplus 中封装了大量的查询方法。用于高级查询。传入表的列和查询的值#xff0c;就能反射对应的sql. 简化了查询。
更多api#xff0c;查询使用#xff0c;看#xff1a; https://baomidou.com/guide/wrapper.html
package cn.bitqian;import cn.bit…QueryWrapper, mybatisplus 中封装了大量的查询方法。用于高级查询。传入表的列和查询的值就能反射对应的sql. 简化了查询。
更多api查询使用看 https://baomidou.com/guide/wrapper.html
package cn.bitqian;import cn.bitqian.entity.User;
import cn.bitqian.mapper.UserMapper;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;import java.util.List;/*** author echo lovely* date 2020/11/17 08:19*/SpringBootTest
public class WrapperDemo {Autowiredprivate UserMapper userMapper;// 测试普通的条件查询Testvoid test1() {// 条件构造器QueryWrapperUser queryWrapper new QueryWrapper();// 查询name为jack的人 并且年龄大于等于3岁queryWrapper.eq(true,name, Jack).ge(age, 3).between(age, 10, 20);User user userMapper.selectOne(queryWrapper);System.out.println(user);queryWrapper.clear();}// 测试模糊查询 demoTestvoid test2() {// 查询构造器QueryWrapperUser userWrapper new QueryWrapper();// condition 条件为 false 不包含该条件查询// LIKE 值%userWrapper.like(name, J).likeRight(false, name, e);ListUser users userMapper.selectList(userWrapper);users.forEach(System.out::println);}// 测试子查询Testvoid test3() {// Preparing: SELECT id,name,age,email,version,// deleted,gmt_create,gmt_modify FROM user WHERE deleted0// AND (id IN (select id from user where id 3))QueryWrapperUser userWrapper new QueryWrapper();userWrapper.inSql(id, select id from user where id 3);ListObject users userMapper.selectObjs(userWrapper);users.forEach(System.out::println);}// order by ..Testvoid test4() {QueryWrapperUser userWrapper new QueryWrapper();userWrapper.orderByDesc(id);ListUser users userMapper.selectList(userWrapper);users.forEach(System.out::println);}}
