mybatis 注解批量添加/修改

最开始的代码

@Insert({
            "<script>",
            "INSERT",
            "INTO",
            "t_company",
            "(id,create_time,update_time,key_no,company_name,oper_name,establishment_date,status,status_desc,no,credit_code,delete_status)",
            "VALUES",
            "<foreach collection='companies' item='company'>",
            "(#{company.id},#{company.createTime},#{company.updateTime},#{company.keyNo},#{company.companyName},#{company.operName},#{company.establishmentDate},#{company.status},#{company.statusDesc},#{company.no},#{company.creditCode},#{company.deleteStatus})",
            "</foreach>",
            "</script>"
    })
    void insertBatch(@Param("companies") List<Company> newCompanies);

然后一直sql报错，死活没找到问题，后来发现是少了一个逗号(,)

还是不细心唉,做个记录

批量修改

@Update({
            "<script>",
            "<foreach collection='companies' item='item' index='index' separator=';'>",
            "UPDATE t_company SET ",
            "create_time=#{item.createTime},key_no=#{item.keyNo},",
            "company_name=#{item.companyName},oper_name=#{item.operName},",
            "establishment_date=#{item.establishmentDate},status=#{item.status},delete_status=#{item.deleteStatus},",
            " status_desc=#{item.statusDesc},no=#{item.no},credit_code=#{item.creditCode} ",
            "WHERE id=#{item.id}",
            "</foreach>",
            "</script>"
    })
    void updateBatch(@Param("companies")List<Company> updateCompanies);