if (updateList.size() > 0) {
int listSize = updateList.size();
int toIndex = 100;
for (int i = 0; i < listSize; i += 100) {
if (i + 100 > updateList.size()) {
toIndex = listSize - i;
}
List<JFUserInfo> newList = updateList.subList(i, i + toIndex);
this.updateJFUserInfo(newList);
}
logger.info("用户信息更新完成,{}条", updateList.size());
} else {
logger.info("0条被更新");
}
<insert id="insertJFUserInfo" parameterType="com.jfdata.entity.JFUserInfo">
insert into JF_USER_INFO
(
ID,
LOGIN_NAME,
PROVINCE,
NAME,
PHONE,
CRE_DATE,
VIN,
LAST_DATA,
ONLINE_TIME,
INS_DATE
)
<foreach collection="list" item="item" index="index" open="(" close=")" separator="union all">
SELECT
#{item.id},
#{item.loginName},
#{item.province},
#{item.name},
#{item.phone},
to_date(#{item.createDate},'yyyy-mm-dd hh24:mi:ss'),
#{item.vin},
to_date(#{item.lastData},'yyyy-mm-dd hh24:mi:ss'),
#{item.onlineTime},
sysdate
FROM DUAL
</foreach>
</insert>
<!-- 更新用户信息 -->
<update id="updateJFUserInfo" parameterType="com.jfdata.entity.JFUserInfo">
<foreach collection="list" item="item" index="index" open="begin" close=";end;" separator=";">
update JF_USER_INFO
<set>
ID =#{item.id},
PROVINCE =#{item.province},
NAME =#{item.name},
PHONE =#{item.phone},
CRE_DATE =to_date(#{item.createDate},'yyyy-mm-dd hh24:mi:ss'),
VIN =#{item.vin},
LAST_DATA =to_date(#{item.lastData},'yyyy-mm-dd hh24:mi:ss'),
ONLINE_TIME =#{item.onlineTime},
UPD_DATE = sysdate
</set>
where LOGIN_NAME =#{item.loginName}
</foreach>
</update>