直接贴上MyBatis xml文件代码吧
<insert id="updateAccountList">
insert into bi_base.t_dw_account_list(
account_id,
is_remote_user,
is_connect_user,
is_cam_user,
is_mediaplayer_user,
is_only_sign
)
values
<foreach collection="list" item="item" separator=",">
(
#{item.accountId},
#{item.isRemoteUser},
#{item.isConnectUser},
#{item.isCamUser},
#{item.isMediaplayerUser},
#{item.isOnlySign}
)
</foreach>
on duplicate key update
is_remote_user = values(is_remote_user),
is_connect_user = values(is_connect_user),
is_cam_user = values(is_cam_user),
is_mediaplayer_user = values(is_mediaplayer_user),
is_only_sign = values(is_only_sign)
</insert>
最主要是这个函数
on duplicate key update
MySQL特有的
至于怎么用,懂的都懂,老懂王了