测试mybatis-mysql无则插入，有则更新（依赖于数据库的主键、唯一索引）

---

测试

LocalDateTime now = LocalDateTime.now();
// Date createTime = Date.from(now.atZone(ZoneId.systemDefault()).toInstant());
// System.out.println(createTime);
String updateTime = now.format(DateTimeFormatter.ofPattern("yyyy-MM"));
System.out.println(updateTime);


void insertList(@Param("uList") List<User> uList);


<insert id="insertList" parameterType="java.util.List">
	insert into user2(id,
		name,
		age,
		birth,
		create_date,
		height,
		weight,
		gender,
		org_code1,
		org_code2,
		status,
		update_date ) values
		<foreach collection="uList" item="user" index="index" separator=",">
			(
			#{user.id},
			#{user.name},
			#{user.age},
			#{user.birth},
			#{user.createDate},
			#{user.height},
			#{user.weight},
			#{user.gender},
			#{user.orgCode1},
			#{user.orgCode2},
			#{user.status},
			#{user.updateDate}
			)
		</foreach>
	ON DUPLICATE KEY UPDATE
	name = values(name),
	age=values(age),
	birth=values(birth),
	create_date=values(create_date),
	height=values(height),
	weight=values(weight),
	gender=values(gender),
	org_code1=values(org_code1),
	org_code2=values(org_code2),
	status=values(status),
	update_date=values(update_date)

</insert>

---