mybatis通过注解使用动态sql

最新推荐文章于 2024-08-05 18:33:11 发布

不爱写代码的一位同学

最新推荐文章于 2024-08-05 18:33:11 发布

阅读量468

点赞数

文章标签： mybatis sql java

本文链接：https://blog.csdn.net/weixin_47084532/article/details/126856418

版权

@Select({"<script>",
        "sql语句"+
        "</script> "})回车会自动拼接

代码⬇️

 @Select({"<script>",
            "SELECT id,username,client_id,password,mobile,email,account_non_locked from bhcz_user" +
                    "<where>\n" +
            "            <if test=\"bhczUser.username!='' and bhczUser.username!=null\">\n" +
            "               AND username LIKE CONCAT('%',#{bhczUser.username},'%')\n" +
            "            </if>\n" +
            "            <if test=\"bhczUser.mobile!='' and bhczUser.mobile!=null\">\n" +
            "               AND mobile LIKE CONCAT('%',#{bhczUser.mobile},'%')\n" +
            "            </if>\n" +
            "        </where>"+
            " </script> "})