mybatis 批量新增跟修改

最新推荐文章于 2024-07-24 14:08:06 发布

一叶飘零_sweeeet

最新推荐文章于 2024-07-24 14:08:06 发布

阅读量1.2k

点赞数 3

分类专栏： mybatis

本文链接：https://blog.csdn.net/jam_yin/article/details/84760626

版权

mybatis 专栏收录该内容

11 篇文章 1 订阅

订阅专栏

<update id="delStudentAttendanceBatch" parameterType="java.util.List">
   <foreach collection="studentAttendanceList" item="item" index="index" open="" close="" separator=";">
   UPDATE emp_student_attendance
   <set>
   stat = 0
   </set>
   WHERE stat = 1
   AND student_id = #{item.studentId}
   AND class_id = #{item.classId}
   </foreach>
   </update>

<insert id="addStudentAttendanceBatch" parameterType="java.util.List">
       INSERT INTO emp_student_attendance
       (id, student_id,
       class_id,class_course_arrange_id,employee_id,school_id,attendance_status,attendence_time,
       consume_hour_counts,remark,create_time,last_update_time,stat)
       values
       <foreach collection="studentAttendanceList" item="studentAttendance"
           index="index" separator=",">
           (
           #{studentAttendance.id,jdbcType=VARCHAR},
           #{studentAttendance.studentId,jdbcType=VARCHAR},
           #{studentAttendance.classId,jdbcType=VARCHAR},
           #{studentAttendance.classCourseArrangeId,jdbcType=VARCHAR},
           #{studentAttendance.employeeId,jdbcType=VARCHAR},
           #{studentAttendance.schoolId,jdbcType=VARCHAR},
           #{studentAttendance.attendanceStatus,jdbcType=INTEGER},
           #{studentAttendance.attendenceTime,jdbcType=TIMESTAMP},
           #{studentAttendance.consumeHourCounts,jdbcType=DOUBLE},
           #{studentAttendance.remark,jdbcType=VARCHAR},
           #{studentAttendance.createTime,jdbcType=TIMESTAMP},
           #{studentAttendance.lastUpdateTime,jdbcType=TIMESTAMP},
           #{studentAttendance.stat,jdbcType=INTEGER}
           )
       </foreach>
   </insert>

   <select id="findListCount" resultType="java.lang.Integer">
       SELECT
       count(1)

       FROM
       app_class a
       LEFT JOIN app_lesson_school b ON a.school_id = b.school_id
       AND a.lession_id = b.lesson_id
       LEFT JOIN app_school c ON a.school_id=c.id
       LEFT JOIN common_employee d ON a.teacher_emoloyee_id =d.id
       LEFT JOIN (SELECT * FROM app_dictionary e WHERE e.parent_id IN (SELECT
       f.id FROM app_dictionary f WHERE f.param_name='attend_class_times' ))
       g ON g.param_value=a.attend_class_times
       WHERE a.stat=1 AND b.stat=1 AND c.stat=1 AND d.stat=1
       <include refid="where_conditions"></include>
   </select>

   <sql id="where_conditions">
       <if test="cla.schoolId == null and cla.schoolIdList !=null" >
       AND a.school_id in

       <foreach collection="cla.schoolIdList" item="item" open="(" close=")" separator="," >
#{item}
</foreach>
       </if>
           <if test="cla.schoolId != null and cla.schoolIdList ==null" >
       AND a.school_id =#{cla.schoolId}
       </if>
       <if test="cla.gradeId != '' and cla.gradeId != null">
           AND a.grade_id = #{cla.gradeId}
       </if>
       <if test="cla.season != '' and cla.season != null">
           AND a.season = #{cla.season}
       </if>
   </sql>