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) 个答案