The role of MyBatis I don't want to say more, today talk about the bulk deletion operation in MyBatis. Nonsense not to say, first give you a piece of code snippets!
<delete id= "Deletebystandardids" >
delete from T_standard_catalog where standard_id in
<foreach collection= "Array" item= "Standardid" open= "(" close= ")" separator= "," >
#{standardid,jdbctype=integer}
" </foreach></delete> or <delete id= "Deletebystandardids" parametertype= "java.util.List" >
Delete from T_standard_catalog where standard_id in
<foreach collection= "list" item= "Standardid" open= "(" close= ")" separator= "," >
#{standardid,jdbctype=integer}
</foreach>
The properties of a foreach element are mainly item,index,collection,open,separator,close.
Item represents the alias of each element in the collection when it is iterated. (Find all the elements in the corresponding Dellist collection directly, item= the item in "Item" (the latter) must match the item in #{item})
index specifies a name that represents the location of each iteration during the iteration.
Open indicates what the statement starts with, and separator represents what symbols are used as delimiters between iterations each time.
Close indicates what ends with.
The above is a small series to introduce the MyBatis bulk Delete data operation method, I hope to help you, if you have any questions please give me a message, small series will promptly reply to everyone. Here also thank you very much for the cloud Habitat Community website support!