tyroscz的博客

mybatis plus sum函数QueryWrapper<CmsVideo> ew = new QueryWrapper<>();ew.eq("user_id", userId );ew.select("IFNULL(sum(give_num),0) AS giveNum");Map<String, Object> map = cmsVideoService.getMap(ew);System.out.println(map);打印 map结果{giv

Mybatis传多个参数（三种解决方案）1.参数出现的顺序 方式传参List<CmsImg> selectCmsImgListT1(String modelType, Long modelId);<select id="selectCmsImgListT1" resultMap="BaseResultMap">SELECT * FROM cms_img WHERE model_type=#{arg0} AND model_id=#{arg1} AND del_flag='0