@select注解中可以用条件构造器

最新推荐文章于 2023-05-07 11:38:44 发布

superXX07

最新推荐文章于 2023-05-07 11:38:44 发布

阅读量302

点赞数

原文链接：http://www.cnblogs.com/lhuser/p/11231704.html

版权

https://mp.baomidou.com/guide/wrapper.html#lambda

https://blog.csdn.net/weixin_42236404/article/details/90897484

https://blog.csdn.net/baidu_33552969/article/details/88977014 例子

***** https://www.cnblogs.com/liuyangfirst/p/9739063.html

https://blog.csdn.net/m0_37034294/article/details/82917234

List<ArticleVo> list = articleDao.queryList(page,queryWrapper);
 
 
@Select("SELECT\n" +
            "\tarticle.*, category. NAME category_name\n" +
            "FROM\n" +
            "\tarticle\n" +
            "LEFT JOIN category ON article.category_id = category.category_id\n" +
            "${ew.customSqlSegment} ")
List<ArticleVo> queryList(Page<ArticleVo> page,@Param(Constants.WRAPPER) QueryWrapper wrapper);

https://www.wandouip.com/t5i54518/ 关于 condition用法

mybatisPlus_eq 实现类似

<if test="a!=null">
    AND a = #{a}
</if>

 

Wrapper wrapper= Condition.create().eq(VerifyUtil.isNNull(sysOffice.getParentId()),"PARENT_ID",sysOffice.getParentId());
 
VerifyUtil.isNNull(sysOffice.getParentId()),"PARENT_ID",sysOffice.getParentId());