QueryWrapper或LambdaQueryWrapper条件构造器传参不到.xml文件时，可以使用${ew.SqlSegment}

最新推荐文章于 2024-04-02 14:29:25 发布

admin码云

最新推荐文章于 2024-04-02 14:29:25 发布

阅读量935

点赞数 2

文章标签： intellij-idea java

本文链接：https://blog.csdn.net/weixin_55181056/article/details/123352254

版权

1.条件构造器

   //获取模板名称
        PublishCategory publishCategory = publishCategoryService.
                queryTemplateName(new QueryWrapper<PublishCategory>().
                        eq("c.style_no",styleNo).
                        eq("c.online_platform_id",onlinePlatformId));

2.xml

    <select id="queryTemplateName" resultType="com.qrkjdiy.publish.entity.publish.PublishCategory">

        select c.id,c.style_no,c.one_category_id,c.one_category_name,c.two_category_id,
        c.two_category_name,c.three_category_id,c.three_category_name,c.excel_template_name,
        c.online_platform_id,c.online_platform_name,c.create_time,c.update_time,s.name,
        s.english_style_name from pb_publish_category c
        join qr_style s on c.style_no=s.style_no
        <where>
            ${ew.SqlSegment} and s.open_status=1

        </where>

    </select>