批量插入代码 唯一索引 跟新
SELECT LAST_INSERT_ID() insert into h_employee (companyId, name, phone, sex) values(#{item.companyId,jdbcType=BIGINT},#{item.name,jdbcType=VARCHAR},#{item.phone,jdbcType=VARCHAR},#{item.sex,jdbcType=INTEGER}) ON DUPLICATE KEY UPDATE name=VALUES(name),sex=VALUES(sex)