【mybatis】第二篇：@Select注解中加入字段判断

专家-郭老师

已于 2022-11-23 10:53:07 修改

阅读量3.4k

点赞数

分类专栏： SpringBoot mybatis 文章标签： mybatis java

于 2022-11-23 10:48:27 首次发布

本文链接：https://blog.csdn.net/qq_23126581/article/details/127995866

版权

SpringBoot 同时被 2 个专栏收录

21 篇文章 6 订阅

订阅专栏

mybatis

5 篇文章 0 订阅

订阅专栏

背景

因需要链表操作，所以采用了@select注解来写sql，抛弃了传统的xml形式。

1.错误性示范代码

@Select({"<script>",
         "select a.*,b.uuid,b.denoter_name as denoterName,b.spelling,b.public_name as publicName from t_denoter_qrcode a right join t_bz_denoter b on a.denoter_uuid=b.denoter_uuid ",
             "where 1=1 ",
                 "<if test='qrcodeRequest.denoterAddress !=null and qrcodeRequest.denoterAddress!="" '>" ,
                    "  and a.address like concat('%',#{qrcodeRequest.denoterAddress},'%')" ,
                 "</if> ",
                 "<if test='qrcodeRequest.denoterName !=null and qrcodeRequest.denoterName!="" '>" ,
                    " and b.denoter_name like concat('%',#{qrcodeRequest.denoterName},'%') " ,
                 "</if> ",
                 "<if test='qrcodeRequest.publicName !=null and qrcodeRequest.publicName!="" '> " ,
                    " and b.public_name like concat('%',#{qrcodeRequest.publicName},'%')" ,
                 "</if> ",
                    " <if test='qrcodeRequest.xzqhdm !=null and qrcodeRequest.xzqhdm!="" '>" ,
                    " and b.zzzz9998 like concat(#{qrcodeRequest.xzqhdm},'%') " ,
                 "</if> ",
            "</script>"})
    List<DenoterQrcodeEntity> denoterQueryList(@Param("qrcodeRequest") QrcodeRequest qrcodeRequest);

会报如下错误：

if元素类型必须后跟属性规范、">“或"/>”

这是因为我们在写sql时候没有转义导致的！

2、正确的写法，看仔细哦

@Select({"<script>",
            "select a.*,b.uuid,b.denoter_name as denoterName,b.spelling,b.public_name as publicName from t_denoter_qrcode a right join t_bz_denoter b on a.denoter_uuid=b.denoter_uuid ",
              "where 1=1 ",
                 "<if test='qrcodeRequest.denoterAddress !=null and qrcodeRequest.denoterAddress!=\"\" '>" ,
                    "  and a.address like concat('%',#{qrcodeRequest.denoterAddress},'%')" ,
                 "</if> ",
                 "<if test='qrcodeRequest.denoterName !=null and qrcodeRequest.denoterName!=\"\" '>" ,
                    " and b.denoter_name like concat('%',#{qrcodeRequest.denoterName},'%') " ,
                 "</if> ",
                 "<if test='qrcodeRequest.publicName !=null and qrcodeRequest.publicName!=\"\" '> " ,
                    " and b.public_name like concat('%',#{qrcodeRequest.publicName},'%')" ,
                 "</if> ",
                 "<if test='qrcodeRequest.xzqhdm !=null and qrcodeRequest.xzqhdm!=\"\" '>" ,
                    " and b.zzzz9998 like concat(#{qrcodeRequest.xzqhdm},'%') " ,
                 "</if> ",
            "</script>"})
    List<DenoterQrcodeEntity> denoterQueryList(@Param("qrcodeRequest") QrcodeRequest qrcodeRequest);