<update id="updateStatusByIds" parameterType="java.lang.Long">
update TNo set Status='1',ReadTime=getdate() where Id
in
<foreach collection="Ids" item="id" open="("separator="," close=")">
#{id}
</foreach>
</update>
Mybatis——传入参数为集合的sql
最新推荐文章于 2024-04-28 22:19:25 发布