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

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

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值