Mybatis操作数据库

增删改的ServiceImpl要加事务的注解

@Transactional(rollbackFor = RuntimeException.class,propagation = Propagation.REQUIRED)

catch里面加回滚操作

TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();

批量插入

<insert id="addSurEarnedCourse" parameterType="java.util.List">
  INSERT INTO  `${schoolNum}`.t_platform_sur_earned (task_id,earn_dm,earn_mc,earn_type,dwdm,dwmc,user_num)
  VALUES
  <foreach item="item" collection="listSurEarnedCourse" separator=",">
    (#{item.taskId},#{item.earnDm},#{item.earnMc},#{item.earnType},#{item.dwdm},#{item.dwmc},#{item.userNum})
  </foreach>
<insert>

批量更新

<update id="deleteSurEarnedByIds" >
  UPDATE `${schoolNum}`.t_platform_sur_earned
  SET delete_flag = 1
  where id IN
  <foreach collection="ids" open="(" close=")" separator="," item="item">
    ${item}
  </foreach>
</update>