AreaMp areaMp1 = areaMpDao.getById(id);
// SELECT id,name,area_type,parent_id,is_primary,pinyin_initial,full_pinyin,full_word_pinyin,addtime,modtime FROM area WHERE id=?
QueryWrapper<AreaMp> wrapper = new QueryWrapper<>();
wrapper.lambda().eq(AreaMp::getId,id);
AreaMp areaMp2 = areaMpDao.getOne(wrapper);
// SELECT id,name,area_type,parent_id,is_primary,pinyin_initial,full_pinyin,full_word_pinyin,addtime,modtime FROM area WHERE (id = ?)
LambdaQueryWrapper<AreaMp> rapper = Wrappers.<AreaMp>lambdaQuery()
.eq(AreaMp::getId,id);
AreaMp areaMp3 = areaMpDao.getOne(rapper);
// SELECT id,name,area_type,parent_id,is_primary,pinyin_initial,full_pinyin,full_word_pinyin,addtime,modtime FROM area WHERE (id = ?)
列表
LambdaQueryWrapper<AreaMp> rapper = Wrappers.<AreaMp>lambdaQuery()
.eq(AreaMp::getAreaType,2)
.like(AreaMp::getName,"河");
List<AreaMp> list = areaMpDao.list(rapper);
// SELECT id,name,area_type,parent_id,is_primary,pinyin_initial,full_pinyin,full_word_pinyin,addtime,modtime FROM area WHERE (area_type = ? AND name LIKE ?)
分页
Page<AreaMp> page = new Page<>(1, 3);
LambdaQueryWrapper<AreaMp> rap = Wrappers.<AreaMp>lambdaQuery()
.eq(AreaMp::getAreaType,2)
.orderByDesc(AreaMp::getId)
.orderByAsc(AreaMp::getAreaType);
Page<AreaMp> mpPage = areaMpDao.page(page, rap);
// SELECT COUNT(1) FROM area WHERE (area_type = ?)
// SELECT id,name,area_type,parent_id,is_primary,pinyin_initial,full_pinyin,full_word_pinyin,addtime,modtime FROM area WHERE (area_type = ?) ORDER BY id DESC,area_type ASC LIMIT ?,?
Page<AreaMp> areaMpPage = areaMpDao.lambdaQuery()
.eq(AreaMp::getAreaType, 2)
.orderByDesc(AreaMp::getId)
.page(new Page<>(1, 6));
// SELECT COUNT(1) FROM area WHERE (area_type = ?)
// SELECT id,name,area_type,parent_id,is_primary,pinyin_initial,full_pinyin,full_word_pinyin,addtime,modtime FROM area WHERE (area_type = ?) ORDER BY id DESC LIMIT ?,?
新增
AreaMp add = new AreaMp();
areaMpDao.save(add);
areaMpDao.saveBatch(Collections.singletonList(add));
Wrapper<AreaMp> whereWrapper = Wrappers.<AreaMp>lambdaUpdate()
.eq(AreaMp::getId,666);
AreaMp up = new AreaMp();
up.setIsPrimary(1);
boolean upda = areaMpDao.update(up, whereWrapper);
删除
boolean b = areaMpDao.removeById(10000);
// DELETE FROM area WHERE id=?
boolean remove = areaMpDao.remove(Wrappers.<AreaMp>lambdaQuery().eq(AreaMp::getAreaType, 4));