博主作为一个常常记不住语法的人……给操作数据库中常常要用到的便签语法总结一下
便签语言与注释结合的时候,必须用
<script>
</script>
给包住
1、最基本的if语法
@Select("<script>" +
" select name from test_table " +
" <if test='name != null'> \n" +
" where name=#{name} " +
" </if>\n" +
" </sript>")
2、foreach语法
用在 where names in (name1,name2,name3)的场合
@Select("<script>"
" select name from test_table where name in"
" <foreach collection='names' item='name' index='index' open='(' separator=',' close=')'> \n" +
"#{name}" +
"</foreach>\n" +
" </sript>")
用于insert 场合
@INSERT("<script>" +
"INSERT INTO `test_table` (`name`, `sex`)\n" +
"VALUES\n" +
"<foreach collection='names' item='name' index='index' separator=','> " +
"(#{name}, #{sex})\n" +
"</foreach>\n" +
"</script>")
后续再补充