看似简单的增删改查你到底对其了解有多少?
增:
- 单个增加
Integer addRewNotShare(RewNotShare infoList);
<insert id="addRewNotShare" parameterType="com.cntaiping.tpi.rew.tasktrace.model.RewNotShare">
insert into REW_NOT_SHARE
(ID, CHANNELTIP, ATTACHEID, UPDATETIME,VALIDIND) values
(#{id}, #{channeltip},#{attacheid},sysdate,'1')
</insert>
- 多个增加
Integer addRewNotShare(@Param("infoList")List<RewNotShare> infoList);
<insert id="addRewNotShare" parameterType="com.cntaiping.tpi.rew.tasktrace.model.RewNotShare">
insert into REW_NOT_SHARE
(ID, CHANNELTIP, ATTACHEID, UPDATETIME,VALIDIND) values
<trim collecction="infoList" item="item" prefix="values (" suffix=")" suffixOverrides="," >
#{item.id}, #{item.channeltip},#{item.attacheid},sysdate,'1'
</trim>
</insert>
建议在事务中批量插入 插入优化
删:
- 逻辑删除
方法: 重写为 JOIN
UPDATE operation o
JOIN (SELECT o.id,
o.status
FROM operation o
WHERE o.group = 123
AND o.status NOT IN ( 'done' )
ORDER BY o.parent,
o.id
LIMIT 1) t
ON o.id = t.id
SET status = '1'
- 物理删除
- 批量删除