mqsql利用map的批量更新数据库数据

今天试了一下 

1、##mapper:
/**
 * 批量更新排序
 * @param sortMap
 * @return
 */
int updateSortMore(@Param("sortMap")Map<Integer, Short> sortMap);

2##sql

<update id="updateSortMore">
    <foreach collection="sortMap.entrySet()" index="id" item="sort" separator=";">
        <if test="id!=null and sort!=null">
            update media_module set sort=#{sort} where id=#{id}
        </if>
    </foreach>
</update>

 

3、返回来的是int=>  1

 

4、配置要加这个allowMultiQueries=true

spring.datasource.url=jdbc:mysql://172.16.20.71:3306/jdocloud_media-back?useUnicode=true&characterEncoding=utf-8&useSSL=false&allowMultiQueries=true&serverTimezone=GMT%2B8
#spring中入库时间时区设定
spring.jackson.time-zone = GMT+8
spring.datasource.username=root