表 create table sun_active_mobile(
mobile varchar2(30),
create_time date,
count_status varchar2(10),
check_status varchar2(10),
sync_status number
)
实体类
private String mobile;
private String createTime;
private String countStatus;
private String checkStatus;
private int activeStatus;
根据手机号 修改count_status,check_status,active_status 且创建时候为2天内的
<update id="UpdateSunActive"
parameterType="com.tec.entity.SunActiveMobile">
update sun_active_mobile
<trim prefix="set" suffixOverrides=",">
<trim prefix="active_status =case" suffix="end,">
<foreach collection="list" item="item" index="index">
when
(mobile=#{item.mobile}) then #{item.activeStatus}
</foreach>
</trim>
<trim prefix="count_status =case" suffix="end,">
<foreach collection="list" item="item" index="index">
when
(mobile=#{item.mobile}) then #{item.countStatus}
</foreach>
</trim>
<trim prefix="check_status =case" suffix="end,">
<foreach collection="list" item="item" index="index">
when
(mobile=#{item.mobile}) then #{item.checkStatus}
</foreach>
</trim>
</trim>
where
<foreach collection="list" separator="or" item="item"
index="index">
(mobile=#{item.mobile})
</foreach>
and create_time>sysdate-2
</update>
如果大家有更好的想法和建议欢迎大家留言指导,谢谢大家~ 喵~~