Mybatis批量新增、修改和删除数据库数据

Mapper.java

/**
 * 批量新增学生列表信息
 *
 * @param studentInfo 学生信息
 * @return 结果
 */
public int batchInsertStudentInfo(@Param(value = "list") List<StudentInfo> studentInfo);

/**
 * 批量修改学生列表信息
 *
 * @param studentInfo 学生信息
 * @return 结果
 */
public int batchUpdateStudentInfo(@Param(value = "list") List<StudentInfo> studentInfo);

/**
 * 批量删除学生信息
 * 
 * @param ids 需要删除的数据Id
 * @return 结果
 */
public int batchDeleteStudentInfo(Long[] ids);

Mybatis.xml

<insert id="batchInsertStudentInfo" parameterType="java.util.List">
    insert into student_info(student_id, student_no, student_name)
    values
    <foreach item="item" collection="list" index="index" separator=",">
        (#{item.studentId}, #{item.studentNo}, #{item.studentName})
    </foreach>
</insert>

<update id="batchUpdateStudentInfo" parameterType="java.util.List">
    update student_info
    set student_id = #{studentId}, student_no = #{studentNo}, student_name = #{studentName}
    where id in
    <foreach item="id" collection="list" index="index" separator=",">
        #{id}
    </foreach>
</update>

<delete id="batchDeleteStudentInfo" parameterType="String">
    delete from student_info
    where id in 
    <foreach item="id" collection="array" open="(" separator="," close=")">
        #{id}
    </foreach>
</delete>