1.QueryWrapper
@Test
public void testQueryWrapper() {
//查询条件构造器(方式一)
QueryWrapper<BannerItem> wrapper = new QueryWrapper<>();
wrapper.eq("banner_id", id);
List<BannerItem> bannerItems = bannerItemMapper.selectList(wrapper);
//我们可以引入lambda,避免在代码中写类似的于banner_id的硬编码(方式二)
LambdaQueryWrapper<BannerItem> wrapper = new QueryWrapper<BannerItem>().lambda();
wrapper.eq(BannerItem::getBannerId, id);
List<BannerItem> bannerItems = bannerItemMapper.selectList(wrapper);
//方式三
LambdaQueryWrapper<BannerItem> wrapper = new LambdaQueryWrapper<>();
wrapper.eq(BannerItem::getBannerId, id);
List<BannerItem> bannerItems = bannerItemMapper.selectList(wrapper);
}
2.updateById更新说明
根据id更新不为null的数据
实例:
TShopGoods t=new TShopGoods();
t.setId(id);
t.setTotalMum(tShopGoods.getTotalMum());
tShopGoodsService.updateById(t);
输出sql为:
3.UpdateWrapper
UpdateWrapper<SysUser> updateWrapper=new UpdateWrapper<>();
updateWrapper.eq("user_id",1);
updateWrapper.set("create_time",new Date());
boolean update = userService.update(updateWrapper);
System.out.println(update);
4.Wrappers.lambdaQuery
List<TPromotion> tPromotions = tPromotionMapper.selectList(Wrappers.lambdaQuery(tPromotion));
if (tPromotions.isEmpty()){
tPromotion.setCreateBy(SecurityUtils.getUsername());
tPromotion.setCreateTime(new Date());
this.save(tPromotion);
}