UPDATE device
SET
name = #{item.name},
no = #{item.no}
WHERE
id = #{item.id}
UPDATE device
SET
del_flag = 1
WHERE 1=1
AND id IN
#{item}
update ${tableName} set DEL_FLAG = 1, deleteor = #{deleteor} where id in
#{id}
3.批量插入的时候
INSERT INTO
device
(id,name,no)
VALUES
( #{item.id}, #{item.name}, #{item.no} )
INSERT INTO
device
(id,name,no)
VALUES
( #{item.id}, #{item.name},#{item.no} )
insert ignore into ${tableName} (AIP_ID, BOX_ID) values
(#{id}, #{boxId})