//新增
@Test
public void testAdd(){
BannerDo bannerDo= new BannerDo();
bannerDo.setImg("xxxx");
bannerDo.setUrl("abc.com");
bannerDo.setWeighta(3);
bannerMapper.insert(bannerDo);
log.info("bannerDo{}",bannerDo);
}
//根据id删除
@Test
public void testDeleteId(){
int rows = bannerMapper.deleteById(4);
log.info("rows{}",rows);
}
//根据条件删除
@Test
public void testDeleteByMap(){
Map<String,Object> columnMap = new HashMap<>();
//删除条件,会吧条件拼接成where and语句
columnMap.put("weight",12);
columnMap.put("url","aaa");
int rows = bannerMapper.deleteByMap(columnMap);
log.info("rows{}",rows);
}
//修改
@Test
public void testUpdate(){
BannerDo bannerDo = new BannerDo();
bannerDo.setUrl("taobao.com");
//空字段不会更新
int rows = bannerMapper.update(bannerDo, new QueryWrapper<BannerDo>().eq("id", 1));
log.info("row
mybatisplus常用的增删改操作,以及核心api
最新推荐文章于 2024-05-13 01:36:29 发布