mybtais-plus中条件构造器实现查询的三种写法

mybtais-plus中条件构造器查询的三种写法

代码

1.Wrappers写法

UserFinanceScore userFinanceScore = baseMapper.selectOne(Wrappers.<UserFinanceScore>lambdaQuery().eq(UserFinanceScore::getUserId, userId));

2.标准写法

QueryWrapper<UserFinanceScore> queryWrapper = new QueryWrapper<UserFinanceScore>();
queryWrapper.eq("user_id", userId);
UserFinanceScore userFinanceScore = baseMapper.selectOne(queryWrapper);

3.lambdaQueryWrapper写法

LambdaQueryWrapper<UserFinanceScore> wrapper = new QueryWrapper<UserFinanceScore>().lambda();
wrapper.eq(UserFinanceScore ::getUserId, userId);
UserFinanceScore userFinanceScore = baseMapper.selectOne(wrapper);

结果

==>  Preparing: SELECT id,user_id,balance,created_time,updated_time FROM user_finance_score WHERE (user_id = ?)
==> Parameters: da(String)
<==    Columns: id, user_id, balance, created_time, updated_time
<==        Row: 13, da, 0.00, 2022-01-12 10:40:46, 2022-01-13 01:00:00
<==      Total: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@ac7b02f]