3-6 select不列出全部字段

10.名字中包含雨并且年龄小于40(需求1加强版)

第一种情况:
select id,name from user where name like '%雨%' and age < 40

Java代码:

    @Test
    public void selectByWrapperSupper(){
        QueryWrapper<User> queryWrapper = new QueryWrapper();
        queryWrapper.select("id","name").like("name","雨").lt("age",40);

        List<User> userList = userMapper.selectList(queryWrapper);
        userList.forEach(System.out::println);
    }

输出结果:

DEBUG==>  Preparing: SELECT id,name FROM user WHERE (name LIKE ? AND age < ?)
DEBUG==> Parameters: %雨%(String), 40(Integer)
TRACE<==    Columns: id, name
TRACE<==        Row: 1094590409767661570, 张雨琪
TRACE<==        Row: 1094592041087729666, 刘红雨
DEBUG<==      Total: 2
User(id=1094590409767661570, name=张雨琪, age=null, email=null, managerId=null, createTime=null)
User(id=1094592041087729666, name=刘红雨, age=null, email=null, managerId=null, createTime=null)

第二种情况:
select id,name,age,email from user where name like '%雨% and age < 40'
Java代码:

    @Test
    public void selectByWrapperSupper2(){
        QueryWrapper<User> queryWrapper = new QueryWrapper();
        queryWrapper.select(User.class,info -> info.getColumn()
                .equals("create_time")&&!info.getColumn().equals("manager_id")).like("name","雨")
                .lt("age",40);

        List<User> userList = userMapper.selectList(queryWrapper);
        userList.forEach(System.out::println);
    }

输出结果:

DEBUG==>  Preparing: SELECT id,create_time FROM user WHERE (name LIKE ? AND age < ?)
DEBUG==> Parameters: %雨%(String), 40(Integer)
TRACE<==    Columns: id, create_time
TRACE<==        Row: 1094590409767661570, 2019-01-14 09:15:15.0
TRACE<==        Row: 1094592041087729666, 2019-01-11 14:20:20.0
DEBUG<==      Total: 2
User(id=1094590409767661570, name=null, age=null, email=null, managerId=null, createTime=2019-01-14T09:15:15)
User(id=1094592041087729666, name=null, age=null, email=null, managerId=null, createTime=2019-01-11T14:20:20)

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值