mybatis的动态sql写到java文件中

动态sql结构

import org.apache.ibatis.annotations.Select;

//查询
@Select({"<script>",
            SQL字符串,
            "</script>"
    })
List<Article> getArticlePaged(ReqPara reqPara);




import org.apache.ibatis.annotations.Update;

//修改、删除(逻辑删也是编辑)
@Update({"<script>",
            SQL字符串,
            "</script>"
    })
int editArticle(Article article);

SQL字符串内可以拼接动态sql

举例

 String QUERY_SQL = "select   " +
            "  t.id  AS  id  ,  " +
            "  t.title  AS  title , " +
            "  t.date  AS  date "  ;

    String TABLE_JOIN_SQL = " from article t ";

    String QUERY_WHERE_SQL = " where 1=1  " +
            "<if test='title!=null and title!=\"\"'>" +
            " AND t.title= #{title} " +
            "