java操做MongoDB把A库某字段复制到B库

最新推荐文章于 2025-03-20 18:28:59 发布

原创最新推荐文章于 2025-03-20 18:28:59 发布 · 276 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mongodb #java

MongoDB 专栏收录该内容

5 篇文章

订阅专栏

该博客主要展示了如何使用MongoDB客户端进行数据操作。通过连接MongoDB数据库，遍历`miniprogram_users`集合，获取用户信息，并结合`phone_info`字段中的电话号码，查找`innovator_data`数据库中`phone`集合的相关记录。如果找到匹配项，则更新源用户文档中的`khwx_code`和`khwx_value`字段。整个过程涉及到了数据的查询、过滤、更新和数据库间的数据同步。

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();
	}
}