mybatis insert or update

记录下mybatis批量插入或者更新sql:

@Insert("<script>" +
            "insert into user_fund_report(base_currency,report_month,created_at,updated_at,user_id,account_type,account,name) " +
            "values " +
            "<foreach collection='userFundReportList' item='amount' index='index' separator=','>" +
            "(#{amount.baseCurrency},#{amount.reportMonth},#{amount.createdAt},#{amount.updatedAt},#{amount.userId}," +
            "#{amount.accountType},#{amount.account},#{amount.name})" +
            "</foreach>" +
            " ON DUPLICATE KEY UPDATE " +
            " base_currency =values(base_currency),report_month=values(report_month),updated_at = values(updated_at)," +
            "user_id=values(user_id),account_type=values(account_type),account=values(account),name=values(name)" +
            "</script>")
    void batchInsertOrUpdate(@Param("userFundReportList") List<UserFundReport> userFundReportList);