DBUtils批量处理操作

Connection conn;

List<E> objects;

String sql = "update XXX set XXX=? where XXX=?";
             Object[][] params = new Object[objects.length][2];  //对应数据集的长度，和每个数据项具有的属性个数
                    for (int i = 0, listSize =objects.length(); i < listSize ; i++) {
                        params[i][0] = XXX;

params[i][1] = XXX;

                    }

            QueryRunner query = new QueryRunner();
            query.batch(conn,sql,params);