批量添加：

    
          insert into finance_loan_info_share_balances_detail     (     contnum,     period_name,     before_amount,     done_fen_qi_amount,     remained_fen_qi_amount,     period_fen_qi_amount,     period_fen_qi_shu,     attribute1,     attribute2,     attribute3,     attribute4,     attribute5,     attribute6,     attribute7,     create_date,     last_update_date     )     values     
     
               (#{temp.contnum},#{temp.period_name},#{temp.before_amount},#{temp.done_fen_qi_amount},         #{temp.remained_fen_qi_amount},#{temp.period_fen_qi_amount},#{temp.period_fen_qi_shu},          #{temp.attribute1},#{temp.attribute2},#{temp.attribute3},#{temp.attribute4},#{temp.attribute5},           #{temp.attribute6},#{temp.attribute7},#{temp.create_date},NOW())     
      
     批量修改： 
    
          insert into     finance_loan_info_share_balances(id,contnum,done_fen_qi_amount,remained_fen_qi_shu,remained_fen_qi_amount,period_name,     contract_status,last_update_date,fen_qi_amount)     values     
     
               (#{temp.id},#{temp.contnum},#{temp.done_fen_qi_amount},#{temp.remained_fen_qi_shu},          #{temp.remained_fen_qi_amount},#{temp.period_name},#{temp.contract_status},NOW(),#{temp.fen_qi_amount})     
          on duplicate key update     done_fen_qi_amount=values(done_fen_qi_amount),     remained_fen_qi_shu = values(remained_fen_qi_shu),     remained_fen_qi_amount = values(remained_fen_qi_amount),     period_name = values(period_name),     fen_qi_amount= values(fen_qi_amount),     contract_status = values(contract_status),     last_update_date = values(last_update_date)