Mybatis使用@Select注解方式判断变量方法

@Select({"<script>",
            "SELECT * FROM oauth_organization" +
            " WHERE 1 = 1" +
            "<when test='m.id!=null'>"+
            "<![CDATA[ and id < #{m.id}]]>" +
            "</when>" +
            " ORDER BY `id` DESC",
            "</script>"})

    List<OauthOrganization> selectpage(@Param("m") Map<String,Object> m, Page<OauthOrganization> page);

前后需要增加<script>和</script>，如果使用大于或小于的条件时，要把查询条件用<![CDATA[ ]]>包裹或将大于和小于号改成<和>