第一个:
<update id="updateBatch" parameterType="java.util.List">
<foreach collection="list" item="att" separator=";" close="" open="" >
update sys_attendance
set
ATTENDANCE_NO = #{att.attendanceNo,jdbcType=INTEGER},
ATTENDANCE_DATE = #{att.attendanceDate,jdbcType=DATE},
ATTENDANCE_TIME = #{att.attendanceTime,jdbcType=TIME},
ATTENDANCE_STATE = #{att.attendanceState,jdbcType=VARCHAR}
where ATTENDANCE_DATE = #{att.attendanceDate,jdbcType=DATE} AND
ATTENDANCE_NO = #{att.attendanceNo,jdbcType=INTEGER}
</foreach>
</update>
Query was empty表示没有可执行的语句
是因为批量修改直接写了循环,当list为null时进不去循环导致mybatis执行后没发现语句报的错
第二个是因为在jdbc链接数据库是没有加allowMultiQueries=true:允许批量更新操作的参数
jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true