批量修改:
1.Mapper.java
@Mapper
public interface DeviceMapper {
void updateDevNotList(List
}
2.Mapper.xml
说明:根据list中每条数据的id修改对应的install_address、product_name WHEN是条件,THEN是赋值
UPDATE
dev_device_instance
SET
install_address =
WHEN #{item.id} THEN #{item.installAddress}
,product_name =
WHEN #{item.id} THEN #{item.productName}
WHERE id IN
#{item.id,jdbcType=INTEGER}
批量新增
1.Mapper.java
@Mapper
public interface DeviceMapper {
void importDevice(List
}
2.Mapper.xml
说明:前提是字段都有传过来,如果是新增哪个传哪个,就要加
INSERT INTO dev_device_instance( id, product_id, product_name, name, creator_name, create_time)
VALUES
(#{item.deviceId}, #{item.productId}, #{item.productName}, #{item.deviceName}, #{item.createBy}, #{item.createTime})
即使人生大写着失败,也不妨碍我继续向前!
相关文章
发表评论