JAVA将list集合的数据一次性插入到指定的数据表中

//dt_Sales代表一个List集合

Object[][] params_ZXHJ = new Object[dt_Sales.size()][];

for (int i = 0; i < dt_Sales.size(); i++) {
    String str1 = ((HashMap) dt_Sales.get(i)).get("主订单ID").toString();
    String str2 = ((HashMap) dt_Sales.get(i)).get("子订单ID").toString();
    String str3 = ((HashMap) dt_Sales.get(i)).get("订单来源").toString();
    String str4 = ((HashMap) dt_Sales.get(i)).get("来源类型").toString();
    String str5 = ((HashMap) dt_Sales.get(i)).get("用户姓名").toString();
    String str6 = ((HashMap) dt_Sales.get(i)).get("电话号码").toString();
    String str7 = ((HashMap) dt_Sales.get(i)).get("性别").toString();
    String str8 = ((HashMap) dt_Sales.get(i)).get("产品ID").toString();
    String str9 = ((HashMap) dt_Sales.get(i)).get("产品名称").toString();
    String str10 = ((HashMap) dt_Sales.get(i)).get("产品分类ID").toString();
    String str11 = ((HashMap) dt_Sales.get(i)).get("分类名称").toString();
    String str12 = ((HashMap) dt_Sales.get(i)).get("品牌ID").toString();
    String str13 = ((HashMap) dt_Sales.get(i)).get("产品数量").toString();
    String str14 = ((HashMap) dt_Sales.get(i)).get("用户优惠券ID").toString();
    String str15 = ((HashMap) dt_Sales.get(i)).get("优惠卷名称").toString();
    String str16 = ((HashMap) dt_Sales.get(i)).get("现金单价").toString();
    String str17 = ((HashMap) dt_Sales.get(i)).get("原价").toString();
    String str18 = ((HashMap) dt_Sales.get(i)).get("实付款").toString();
    String str19 = ((HashMap) dt_Sales.get(i)).get("积分单价").toString();
    String str20 = ((HashMap) dt_Sales.get(i)).get("总积分").toString();
    String str21 = ((HashMap) dt_Sales.get(i)).get("分期数").toString();
    String str22 = ((HashMap) dt_Sales.get(i)).get("订单状态").toString();
    String str23 = ((HashMap) dt_Sales.get(i)).get("资金交易状态").toString();
    String str24 = ((HashMap) dt_Sales.get(i)).get("售后服务状态").toString();
    String str25 = ((HashMap) dt_Sales.get(i)).get("发票抬头").toString();
    String str26 = ((HashMap) dt_Sales.get(i)).get("下单工号").toString();
    String str27 = ((HashMap) dt_Sales.get(i)).get("扩展字段2").toString();
    String str28 = ((HashMap) dt_Sales.get(i)).get("渠道来源").toString();
    String str29 = ((HashMap) dt_Sales.get(i)).get("产品属性描述").toString();
    String str30 = ((HashMap) dt_Sales.get(i)).get("订单备注").toString();
    String str31 = ((HashMap) dt_Sales.get(i)).get("权益Code").toString();
    String str32 = ((HashMap) dt_Sales.get(i)).get("权益名称").toString();
    String str33 = ((HashMap) dt_Sales.get(i)).get("实付总权益数量").toString();
    String str34 = ((HashMap) dt_Sales.get(i)).get("签收时间/核销时间").toString();
    String str35 = ((HashMap) dt_Sales.get(i)).get("订单类型").toString();
    String str36 = ((HashMap) dt_Sales.get(i)).get("订单状态锁").toString();
    String str37 = ((HashMap) dt_Sales.get(i)).get("审核描述").toString();
    String str38 = ((HashMap) dt_Sales.get(i)).get("支付时间").toString();
    String str39 = ((HashMap) dt_Sales.get(i)).get("退货时间").toString();
    String str40 = ((HashMap) dt_Sales.get(i)).get("退货数量").toString();
    String str41 = ((HashMap) dt_Sales.get(i)).get("使用数量").toString();
    String str42 = ((HashMap) dt_Sales.get(i)).get("创建人").toString();
    String str43 = ((HashMap) dt_Sales.get(i)).get("创建时间").toString();
    String str44 = ((HashMap) dt_Sales.get(i)).get("修改人").toString();
    String str45 = ((HashMap) dt_Sales.get(i)).get("修改时间").toString();
    String str46 = ((HashMap) dt_Sales.get(i)).get("开始时间").toString();
    String str47 = ((HashMap) dt_Sales.get(i)).get("结束时间").toString();
    String str48 = ((HashMap) dt_Sales.get(i)).get("佣金金额").toString();
    String str49 = ((HashMap) dt_Sales.get(i)).get("请款时间").toString();
    String str50 = ((HashMap) dt_Sales.get(i)).get("订单请款锁定").toString();
    String str51 = ((HashMap) dt_Sales.get(i)).get("收货地址").toString();
    String str52 = ((HashMap) dt_Sales.get(i)).get("收货人姓名").toString();
    String str53 = ((HashMap) dt_Sales.get(i)).get("收货人电话1").toString();
    String str54 = ((HashMap) dt_Sales.get(i)).get("收货人电话2").toString();
    String str55 = dfDate.format(new Date());
    String str56 = UserName;
    params_ZXHJ[i] = new Object[]{str1, str2, str3, str4, str5, str6, str7, str8, str9, str10, str11, str12, str13, str14
            , str15, str16, str17, str18, str19, str20, str21, str22, str23, str24, str25, str26, str27, str28
            , str29, str30, str31, str32, str33, str34, str35, str36, str37, str38, str39, str40, str41, str42
            , str43, str44, str45, str46, str47, str48, str49, str50, str51, str52, str53, str54, str55, str56};
}
conn.setAutoCommit(false);//开启一个事务并将自动提交设置为false
sql = "INSERT INTO " + TableName + " VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?"
        + ",?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
batch(params_ZXHJ, sql);

public void batch(Object[][] params, String sql) {
    QueryRunner queryRunner = new QueryRunner(true);
    try {
        //能将list集合的数据一次性插入到指定的数据表中
        queryRunner.batch(getConnection(), sql, params);
    } catch (SQLException e) {
        e.printStackTrace();
    }
}