1 。不能通过直连,需要通过ssh进行访问
package appapi.config.mongo;
import com.jcraft.jsch.JSch;
import com.jcraft.jsch.JSchException;
import com.jcraft.jsch.Session;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.data.mongodb.MongoDatabaseFactory;
import org.springframework.data.mongodb.core.MongoTemplate;
import org.springframework.data.mongodb.core.SimpleMongoClientDatabaseFactory;
@Configuration
public class MongoDBConfig {
@Value(“
s
p
r
i
n
g
.
d
a
t
a
.
m
o
n
g
o
d
b
.
u
r
i
"
)
p
r
i
v
a
t
e
S
t
r
i
n
g
m
o
n
g
o
U
r
i
;
@
V
a
l
u
e
(
"
{spring.data.mongodb.uri}") private String mongoUri; @Value("
spring.data.mongodb.uri")privateStringmongoUri;@Value("{ssh.host}”)
private String sshHost;
@Value(“
s
s
h
.
p
o
r
t
"
)
p
r
i
v
a
t
e
i
n
t
s
s
h
P
o
r
t
;
@
V
a
l
u
e
(
"
{ssh.port}") private int sshPort; @Value("
ssh.port")privateintsshPort;@Value("{ssh.username}”)
private String sshUsername;
@Value(“${ssh.password}”)
private String sshPassword;
@Bean
public MongoDatabaseFactory mongoDatabaseFactory() throws JSchException {
JSch jsch = new JSch();
Session session = jsch.getSession(sshUsername, sshHost, sshPort);
session.setPassword(sshPassword);
session.setConfig(“StrictHostKeyChecking”, “no”);
session.connect();
int assignedPort = session.setPortForwardingL(0, “localhost”, 27017);
String updatedUri = mongoUri.replace(“localhost:27017”, “localhost:” + assignedPort);
return new SimpleMongoClientDatabaseFactory(updatedUri);
}
@Bean
public MongoTemplate mongoTemplate(MongoDatabaseFactory mongoDatabaseFactory) {
return new MongoTemplate(mongoDatabaseFactory);
}
}
2.直连访问
String user = "kedadmin";
//数据库名
String database = "admin";
//密码
char[] password = "kdaEwzWrLGAmNp6n".toCharArray();
MongoCredential credential = MongoCredential.createCredential(user, database, password);
MongoClient mongoClient = MongoClients.create(
MongoClientSettings.builder()
.applyToClusterSettings(builder ->
builder.hosts(Collections.singletonList(new ServerAddress("10.0.0.143", 27017))))
.credential(credential)
.build());
//连接database
MongoDatabase databases = mongoClient.getDatabase("cmcis");
//创建一个collection
//连接collection
MongoCollection<Document> collection = databases.getCollection("users");