2023年8月3日发(作者：)

pgsql--批量修改⼯具：mybatis+pgsql详见案例1 – Listdao层void update(List userList);sql update user

set username = #{me}, address = #{s} where id = #{} 案例2-- Listdao层void update(@Param("depIdList") List depIdList, @Param("operator") String operator);sql update user

set status = 1, update_date = now(), update_by = #{operator} where id = #{depId} 案例3-- Listdao层void update(@Param("depIdList") List depIdList);sql update user

set status = 1, update_date = now() where id = #{depId}

2023年8月3日发(作者：)

pgsql--批量修改⼯具：mybatis+pgsql详见案例1 – Listdao层void update(List userList);sql update user

set username = #{me}, address = #{s} where id = #{} 案例2-- Listdao层void update(@Param("depIdList") List depIdList, @Param("operator") String operator);sql update user

set status = 1, update_date = now(), update_by = #{operator} where id = #{depId} 案例3-- Listdao层void update(@Param("depIdList") List depIdList);sql update user

set status = 1, update_date = now() where id = #{depId}