MyBatis在注解上使用动态SQL（@select使用if）

Question

@Select({
            "<script>",
            "select * from user_info where 1=1",
            "<when test='name!=null and name!='' '>",
            "and name = #{name}",
            "</when>",
            "</script>"})

判断条件是name不为空并且不等于''(空字符串)
这该怎么写呢?上面这个写法是错的

Answer 1

Answer 2

这样试试

@Select("<script>" +
    "select * from user_info where 1=1" +
        "<where>" +
            "<if test=test='name!=null and name!=''>" +
                "and name = #{name}"+
            "</if>" +
        "</script>")