MyBatis-数据操作

MyBatis 基于注解的批量插入数据

    @Insert({"<script>",
            "insert into tmc_constract_detail",
            "<foreach collection='list'item='record'index ='index'separator=','>",
            "values(",
            "#{record.constractId,jdbcType=VARCHAR}, #{record.modifyCode,jdbcType=VARCHAR}," +
                    "#{record.constractStatus,jdbcType=VARCHAR}, #{record.updateDate,jdbcType=DATE}," +
                    "#{record.userId,jdbcType=VARCHAR}, #{record.description,jdbcType=VARCHAR}",
            "</foreach>",
            ")</script>"})
    void updatesStatus(List<TmcConstractDetail> records);