依赖
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-mongodb</artifactId>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
</dependency>
配置
spring:
data:
mongodb:
base_host: localhost1
base_port: 27017
base_database: database1
base_username: admin
base_password: 123456
openapi_host: localhost2
openapi_port: 27017
openapi_database: database2
openapi_username: admin
openapi_password: 123456
代码
package com.xxxx.config;
import lombok.Data;
import org.springframework.boot.context.properties.ConfigurationProperties;
@ConfigurationProperties(prefix = "spring.data.mongodb")
//注意:使用@Data需要idea安装lombok插件
@Data
class MongoConfig {
private String base_host;
private int base_port;
private String base_database;
private String base_username;
private String base_password;
private String openapi_host;
private int openapi_port;
private String openapi_database;
private String openapi_username;
private String openapi_password;
}
package com.xxxx.config;
import com.mongodb.MongoClient;
import com.mongodb.MongoCredential;
import com.mongodb.ServerAddress;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.context.properties.EnableConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.data.mongodb.core.MongoTemplate;
import java.util.ArrayList;
import java.util.List;
@Configuration
@EnableConfigurationProperties(value = MongoConfig.class)
public class MongodbClient {
@Autowired
MongoConfig mongoConfig;
private static final Logger log = LoggerFactory.getLogger(MongodbClient.class);
@Bean(name = "baseMongoTemplate")
@Primary
MongoTemplate baseMongoTemplate() {
//有密码登录用这个
List<ServerAddress> seeds = new ArrayList<>();
ServerAddress serverAddress = new ServerAddress(mongoConfig.getBase_host(), Integer.valueOf(mongoConfig.getBase_port()));
seeds.add(serverAddress);
List<MongoCredential> mongoCredentialList = new ArrayList<>();
mongoCredentialList.add(MongoCredential.createCredential(mongoConfig.getBase_username(), "admin", mongoConfig.getBase_password().toCharArray()));
MongoTemplate template = new MongoTemplate(new MongoClient(seeds, mongoCredentialList), mongoConfig.getBase_database());
log.info("baseMongoTemplate初始化完毕. host:" + mongoConfig.getBase_host() + " port: " + mongoConfig.getBase_port() + " database: " + mongoConfig.getBase_database());
//没有密码登录用这个
//MongoTemplate template = new MongoTemplate(new MongoClient(mongoConfig.getBase_host(), mongoConfig.getBase_port()), mongoConfig.getBase_database());
return template;
}
@Bean(name = "openapiMongoTemplate")
MongoTemplate openapiMongoTemplate() {
//有密码登录用这个
List<ServerAddress> seeds = new ArrayList<>();
ServerAddress serverAddress = new ServerAddress(mongoConfig.getOpenapi_host(), Integer.valueOf(mongoConfig.getOpenapi_port()));
seeds.add(serverAddress);
List<MongoCredential> mongoCredentialList = new ArrayList<>();
mongoCredentialList.add(MongoCredential.createCredential(mongoConfig.getOpenapi_username(), "admin", mongoConfig.getOpenapi_password().toCharArray()));
MongoTemplate template = new MongoTemplate(new MongoClient(seeds, mongoCredentialList), mongoConfig.getOpenapi_database());
log.info("openapiMongoTemplate初始化完毕. host:" + mongoConfig.getOpenapi_host() + " port: " + mongoConfig.getOpenapi_port() + " database: " + mongoConfig.getOpenapi_database());
//没有密码登录用这个
//MongoTemplate template = new MongoTemplate(new MongoClient(mongoConfig.getOpenapi_host(), mongoConfig.getOpenapi_port()), mongoConfig.getOpenapi_database());
return template;
}
}
调用
package com.xxxx.service.Impl;
import com.xxxx.config.Constants;
import com.xxxx.dao.AllDeviceLocation;
import com.xxxx.service.MongoService;
import com.mongodb.BasicDBObject;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.data.mongodb.core.BulkOperations;
import org.springframework.data.mongodb.core.MongoTemplate;
import org.springframework.data.mongodb.core.query.Criteria;
import org.springframework.data.mongodb.core.query.Query;
import org.springframework.data.mongodb.core.query.Update;
import org.springframework.data.util.Pair;
import org.springframework.stereotype.Service;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Map;
@Service
public class MongoServiceImpl implements MongoService {
@Autowired
@Qualifier("baseMongoTemplate")
private MongoTemplate baseMongoTemplate;
@Autowired
@Qualifier("openapiMongoTemplate")
private MongoTemplate openapiMongoTemplate;
private static final Logger log = LoggerFactory.getLogger(MongoServiceImpl.class);
/**
* 查询mongo中所有的数据
*
* @return
*/
@Override
public List<Map> findAll() {
List<Map> maps = baseMongoTemplate.findAll(Map.class, Constants.COLLECTION_NAME_DEVICE_LOCATION);
return maps;
}
/**
* 创建索引
*
* @param tableName
*/
@Override
public void createIndex(String tableName) {
try {
String index = openapiMongoTemplate.getCollection(tableName).createIndex(new BasicDBObject(Constants.FORMATED_KEY_NAME_DEVICEUUID, 1));
log.info(tableName + "创建索引成功。");
} catch (Exception e) {
log.error(tableName + "创建索引失败。", e);
}
}
}