注意:selectOne 只是取查询结果中的一条数据,打出的sql语句的结尾没有limit 1限制。用了selectOne查询是必须保证查出来的结果是1条或0条。如果查询结果的条数大于1就会报错,如果查询结果是0条或1条是不报错的。为了保险起见,在wrapper条件后加上 .last(“limit 1”)
LambdaQueryWrapper wrapper = new LambdaQueryWrapper<>();
wrapper.eq(Goods::getStorage,param.getStorage()).last(“limit 1”);
Goods one = goodsMapper.selectOne(wrapper1);
wrapper条件后加上 .last(“limit 1”) sql日志:
SELECT id,name,storage,goodsType,count,remark,target_value,target_value_string,target_big FROM goods WHERE (storage = 11) limit 1
wrapper条件后没有 .last(“limit 1”) sql日志:
SELECT id,name,storage,goodsType,count,remark,target_value,target_value_string,target_big FROM goods WHERE (storage = 11)
LambdaQueryWrapper wrapper = new LambdaQueryWrapper<>();
wrapper.like(Goods::getName,String.valueOf(param.getStorage())); //Integer 类型的storage 字段转字符串
List list=goodsMapper.selectList(wrapper);