package com.wxy.run;
import org.bson.Document;
import org.springframework.util.StringUtils;
import com.alibaba.fastjson.JSONObject;
import com.mongodb.BasicDBObject;
import com.mongodb.MongoClient;
import com.mongodb.client.MongoCollection;
import com.mongodb.client.MongoCursor;
import com.mongodb.client.MongoDatabase;
import com.mongodb.client.model.Filters;
import com.wxy.utils.ReadProperties;
public class MiniprogramUsers {
private static MongoDatabase db;
private static MongoDatabase db2;
private static MongoClient client;
private static String mongoUrl = ReadProperties.getValue("mongoUrl", "setting.properties");
private static Integer mongoPort = Integer.valueOf(ReadProperties.getValue("mongoPort", "setting.properties"));
public static void main(String[] args) {
client = new MongoClient(mongoUrl, mongoPort);
db = client.getDatabase("wechat");
MongoCollection<Document> usersCollection = db.getCollection("miniprogram_users");
db2 = client.getDatabase("innovator_data");
MongoCollection<Document> phoneCollection = db2.getCollection("phone");
MongoCursor<Document> iteratorDoc = usersCollection.find().iterator();
BasicDBObject basicDBObject = new BasicDBObject();
while(iteratorDoc.hasNext()) {
Document next = iteratorDoc.next();
JSONObject jsonObject = JSONObject.parseObject( next.toJson().toString());
JSONObject phone = jsonObject.getJSONObject("phone_info");
String string = phone.getString("phoneNumber");
String substring = string.substring(0, 7);
basicDBObject.put("phone", substring);
Document first = phoneCollection.find(basicDBObject).first();
String string2 = "";
String string3 ="";
if(first != null) {
JSONObject parseObject = JSONObject.parseObject(first.toJson().toString());
string2 = parseObject.getString("khwx_code");
string3 = parseObject.getString("khwx_value");
}
String string4 = jsonObject.getString("khwx_code");
String string5 = jsonObject.getString("khwx_value");
if(StringUtils.isEmpty(string4)) {
next.put("khwx_code", string2);
}
if(StringUtils.isEmpty(string5)) {
next.put("khwx_value", string3);
}
usersCollection.updateOne(Filters.eq("phone_info",phone), new Document("$set", next));
//System.err.println(substring + string2 + string3);
}
client.close();
}
}
java操做MongoDB把A库某字段复制到B库
最新推荐文章于 2022-10-28 11:25:17 发布