mybatis
weixin_43881073
这个作者很懒,什么都没留下…
展开
-
mybatis批量更新update
<udpate id = "方法名" parameter = "java.util.List"> update `表名` <trim prefix = "set" suffixOverrides = ','> <trim prefix = "字段1 = case" suffix= "end,"> <foreach collection ="list" item = "item" index ="index"> when ID = #{it原创 2020-10-20 10:56:47 · 217 阅读 · 0 评论 -
Mybatis批量新增
//对于支持主键自增的,如Mysql,设置useGeneratedKeys为true可自增。 flushCache = "flase"表示任何时候语句被调用,都不会去清空本地缓存和二级缓存 <insert id= "方法名" parameterType = "java.util.List" useGeneratedKeys = "false" flushCache = "false"> insert into `表名`( ID, 字段1, 字段2, 字段3 ) SELECT原创 2020-10-20 10:44:41 · 75 阅读 · 0 评论