如何在Java中将csv文件导入mongodb [英] how to import csv file into mongodb in Java

问题描述

我正在将EclipseLink用作mongodb的API.我需要每次从给定的csv文件更新数据库. 有什么方法可以使用Java将CSV文件导入到MongoDB中吗? 还是可以在Java环境中执行像这样的原始mongo命令?

I'm using EclipseLink as API for mongodb. I need to update my database each time from given csv files. Is there any way to import a CSV file into MongoDB with java? or is it possible to execute a raw mongo command like this in java enviroment?

mongoimport --db users --collection contacts --type csv --file /opt/backups/contacts.csv

推荐答案

Java驱动程序中没有mongoimport的直接方法.

There is no direct way for mongoimport in Java Driver.

尝试Runtime.exec().示例代码:

  Runtime r = Runtime.getRuntime();
  Process p = null;
  String command = "mongoimport --db users --collection contacts --type csv --file /opt/backups/contacts.csv";
  try {
   p = r.exec(command);
   System.out.println("Reading csv into Database");

  } catch (Exception e){
   System.out.println("Error executing " + command + e.toString());
  }

查看此博客以获得更多详细信息.

Check out this blog for more details.

这篇关于如何在Java中将csv文件导入mongodb的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！