mybatis plus实战增删该查

@SpringBootTest(classes = Application.class)
@Slf4j
class BannerTest {


    @Autowired
    private BannerMapper bannerMapper;


    /**
     * id查找
     */
    @Test
    public void testSelectById(){
        BannerDO bannerDO = bannerMapper.selectById(2);
        log.info("bannerDO: {}",bannerDO);
    }
    
    /**
     * 根据id查找，返回指定列的数据【id，url】
     */
    @Test
    public void testSelectCol(){
        BannerDO bannerDO = bannerMapper.selectOne(new QueryWrapper<BannerDO>().eq("id",8).select("id","url"));
        log.info("bannerDO: {}",bannerDO);
    }
    
    /**
     * 批量查找
     */
    @Test
    public void testSelectBatchIds(){
        List<BannerDO> list = bannerMapper.selectBatchIds( Arrays.asList(2,3));
        log.info("bannerDO: {}",list);
    }


    /**
     * 选择1条
     */
    @Test
    public void testSelectOne(){
        BannerDO bannerDO = bannerMapper.selectOne(new QueryWrapper<BannerDO>().eq("id",1));
        log.info("bannerDO: {}",bannerDO);
    }




    /**
     * 统计行数
     */
    @Test
    public void testSelectCount(){
        int size = bannerMapper.selectCount(null);
        log.info("bannerDO: {}",size);
    }


    /***
     * 查找全部数据
     */
    @Test
    public void testBannerList(){


       List<BannerDO> list = bannerMapper.selectList(null);
        log.info("轮播图列表:{}",list);


    }


    /***
     * 新增
     */
    @Test
    public void testAdd(){
        BannerDO bannerDO = new BannerDO();
        bannerDO.setImg("xxxx.img");
        bannerDO.setUrl("lianglin.com");
        bannerMapper.insert(bannerDO);


        log.info("轮播图:{}",bannerDO);


    }


    /**
     * 根据ID删除
     */
    @Test
    public void testDeleteId(){
       int rows = bannerMapper.deleteById(2);
       log.info("rows:{}",rows);
    }


    /**
     * 根据条件删除
     */
    @Test
    public void testDeleteByMap(){
        Map<String,Object> columnMap = new HashMap<>();
        columnMap.put("weight",12);
        columnMap.put("url","bbb");
        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",3));
        log.info("rows:{}",rows);
    }


    /**
     * 更新 updateWrapper通过id进行更新
     */
    @Test
    public void testUpdateWrapper(){
        UpdateWrapper updateWrapper = new UpdateWrapper();
        updateWrapper.set("url","aaaa.com");
        updateWrapper.eq("id",1);
        int rows = bannerMapper.update(null,updateWrapper);
        log.info("rows:{}",rows);
    }


}