动态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} " +
"