【MyBatis-Plus】QueryWrapper、QueryChainWrapper、LambdaQueryWrapper、LambdaQueryChainWrapperの比較

機能の比較

	QueryWrapper	QueryChainWrapper	LambdaQueryWrapper	LambdaQueryChainWrapper
カラム名のメソッド参照	×	×	○	○
チェーンクエリの使用	×	○	×	○

コード例

QueryWrapper

QueryWrapper<User> queryWrapper = new QueryWrapper<>();
queryWrapper.eq("username", username);
User user = this.baseMapper.selectOne(queryWrapper);

QueryChainWrapper

QueryChainWrapper<User> queryWrapper = new QueryChainWrapper<>(this.baseMapper);
User user = queryWrapper.eq("username", username).one();

LambdaQueryWrapper

LambdaQueryWrapper<User> queryWrapper = new LambdaQueryWrapper<>();
queryWrapper.eq(User::getUsername, username);
User user = this.baseMapper.selectOne(queryWrapper);

LambdaQueryChainWrapper

LambdaQueryChainWrapper<User> queryWrapper = new LambdaQueryChainWrapper<>(this.baseMapper);
User user = queryWrapper.eq(User::getUsername, username).one();

参考ページ