java 批量插入資料 到資料庫，java資料庫

java 批量插入資料 到資料庫，java資料庫

//大資料插入方式String sql = "insert into T_DR_RF(CUSTOMER_CODE,RFID_TAG) values(?,?)";Connection connection =db.getConnection();connection.setAutoCommit(false);PreparedStatement ps = connection.prepareStatement(sql);for (Map<String, Object> map : coll) {String p1 = Tools.toString(map.get("customerCode"));String p2 = Tools.toString(map.get("rfidTag"));ps.setString(1, p1);ps.setString(2, p2);ps.addBatch();}ps.executeBatch();connection.commit();System.out.println("匯入完成");