有 Java 编程相关的问题?

你可以在下面搜索框中键入要查询的问题!

mongodb如何在java中将数据从Mongo DB导出为excel格式

MongoDB中的模式: {
“姓名”:“卡马拉”, “流量”:[

    {
        "Date" : "2018-08-03",
        "New" : "set",
        "Form" : {
            "y" : "1",
            "d" : "3",
            "p" : "3"
        }
    }
]

}

我的java代码: 公共静态void main(字符串[]args){

     String db = "Database";
     String col = "col";
     String Host="localhost";
     String Port="27017";
     String fileName = "D:/File/sample.xls";

     String Query = "C:\\Program Files\\MongoDB\\Server\\3.4\\bin\\mongoexport.exe --host " + Host + " --port " + Port + " --db " + db + " --collection " + col + " --type=xls--fields Name,Flows, --out " + fileName + "";

     try {
         System.out.println(Query);

         StringTokenizer st = new StringTokenizer(Query);
         String[] Queryarray = new String[st.countTokens()];
         for (int i = 0; st.hasMoreTokens(); i++)
             Queryarray[i] = st.nextToken();

         ProcessBuilder processBuilder = new ProcessBuilder(Queryarray);
         processBuilder.redirectErrorStream(true);

         Process process = processBuilder.start();
         BufferedReader processOutput = new BufferedReader(new InputStreamReader(process.getInputStream()));

         String data = "";
         while ((data = processOutput.readLine()) != null) {
             System.out.println(data);
         }


     } catch (Exception e) {
         e.printStackTrace();
     }
 }

我试图在Flows数组中检索date、new和Form值


共 (0) 个答案