Java读取多个cvs表数据_java-如何从CSV读取行以在多个线程中使用

如果要同时执行5个(或更多)线程,则需要启动5个WebDriver实例,因为它不是线程安全的.至于更新CSV,您需要将每个线程的写入同步化,以防止损坏文件本身,或者您可以按一定阈值批量更新,并一次写入多行.

更新：

这个怎么样？这样可以确保在线程之间不重复使用Web驱动程序.

CSVReader reader = new CSVReader(new FileReader(FILE_PATH));

// number to do at same time

int concurrencyCount = 5;

ExecutorService executorService = Executors.newFixedThreadPool(concurrencyCount);

CompletionService completionService = new ExecutorCompletionService(executorService);

String[] nextLine;

// ensure we use a distinct WebDriver instance per thread

final LinkedBlockingQueue webDrivers = new LinkedBlockingQueue();

for (int i=0; i

webDrivers.offer(new ChromeDriver());

}

int count = 0;

while ((nextLine = reader.readNext()) != null) {

final String [] line = nextLine;

completionService.submit(new Callable() {

public Boolean call() {

try {

// take a webdriver from the queue to use

final WebDriver driver = webDrivers.take();

driver.get("http://google.com/");

driver.findElement(By.name("q")).click();

driver.findElement(By.name("q")).clear();

driver.findElement(By.name("q")).sendKeys(line[0] + " " + line[1]);

System.out.println(line[1]);

line[2] = driver.findElement(By.xpath(XPATH_TO_1ST)).getText();

// put webdriver back on the queue

webDrivers.offer(driver);

return true;

} catch (InterruptedException e) {

e.printStackTrace();

return false;

}

}

});

count++;

}

boolean errors = false;

while(count-- > 0) {

Future resultFuture = completionService.take();

try {

Boolean result = resultFuture.get();

} catch(Exception e) {

e.printStackTrace();

errors = true;

}

}

System.out.println("done, errors=" + errors);

for (WebDriver webDriver : webDrivers) {

webDriver.close();

}

executorService.shutdown();