java实现批量更新数据库数据_JAVA脚本批量更新oracle数据库(三)

package com;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.ArrayList;

import java.util.List;

public class CartonBox {

public static void cb() throws Exception {

getConnection();

conn.setAutoCommit(false);

List<String> boxList = new ArrayList<String>();

List<String> cartonList = new ArrayList<String>();

List<String> packageList = new ArrayList<String>();

String sql = "select serial from qrcode where