SSM注解方式动态sql

Question

动态sql

     @Select({
         "<script>",
              " SELECT * FROM merchant",
               " <where>",
             "<if test='uname!= null '> AND uname =#{uname} </if> <if test='state!= null'> AND state  =#{state} </if> ",
         "</where>",         
     " </script>"
             })
    List<Merchant> SelectAll(Map map);

不知道这个错在哪里

Answer 1

你的html标签不对 少了“</”