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);