import com.mongodb.BasicDBObject;
import com.mongodb.MongoClient;
import com.mongodb.MongoCredential;
import com.mongodb.ServerAddress;
import com.mongodb.client.FindIterable;
import com.mongodb.client.MongoCollection;
import com.mongodb.client.MongoDatabase;
import org.bson.Document;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.util.HSSFColor;
import org.apache.poi.ss.usermodel.BorderStyle;
import org.apache.poi.ss.usermodel.FillPatternType;
import org.apache.poi.ss.usermodel.HorizontalAlignment;
import org.apache.poi.ss.usermodel.VerticalAlignment;
try{
//startTime、endTime、testId为自定义参数,根据实际情况自行调整
Date startDate = parseStringToDate(startTime);
if(startDate == null)
return false;
println "查询开始时间: "+startDate;
Date endDate = parseStringToDate(endTime);
if(endDate == null)
return false;
println "查询结束时间: " +endDate;
println "开始连接mongodb数据库...";
MongoClient mongoClient = connectMongoDB();
if(mongoClient == null){
println "mongodb数据库连接失败!";
return false;
}
println "mongodb数据库连接成功!";
MongoDatabase mongoDa
groovy脚本连接mongodb导出数据到excel
最新推荐文章于 2023-07-25 15:53:24 发布