java mysql 批量更新_Java程序向数据库批量更新

JSONArray list = json.getJSONArray("data_list");

conn.setAutoCommit(false);

PreparedStatement pstmt = conn.prepareStatement("insert into db_order values(?,?,?,?)");

PreparedStatement stat = conn.prepareStatement("insert into db_order_rcv(sequenceid, mobile, price) values(?,?,?)");

for(int n = 0;n

JSONObject json = list.getJSONObject(n);

pstmt.setInt(1, json.getInt("sid"));

pstmt.setString(2, json.getString("mobile"));

pstmt.setFloat(3, 49.99);

pstmt.setBoolean(4, true);

pstmt.addBatch();

stat.setString(1, json.getInt("sid"));

stat.setString(2, json.getString("mobile"));

stat.setFloat(3, 49.99);

stat.addBatch();

}

int[] updateCount = pstmt.executeBatch();

int[] counts = stat.executeBatch();

conn.commit();