一、使用springcloud连接mongodb数据库
##1、pom.xml
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-mongodb</artifactId>
</dependency>
##2、mongoConfig配置类
import com.mongodb.MongoClient;
import com.mongodb.client.MongoDatabase;
import com.mongodb.client.gridfs.GridFSBucket;
import com.mongodb.client.gridfs.GridFSBuckets;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
@Configuration//在config包中定义Mongodb的配置类
public class MongoConfig {
@Value("${spring.data.mongodb.database}")
String db;
@Bean
public GridFSBucket getGridFSBucket(MongoClient mongoClient){
MongoDatabase database = mongoClient.getDatabase(db);
GridFSBucket gridFSBucket = GridFSBuckets.create(database);
return gridFSBucket;
}
}
##3、application.yml配置
server:
port: 8082
spring:
application:
name: hyb-test
#mongodb数据库
data:
mongodb:
username: 用户名
password: 密码
host: ip
port: 端口
database: 数据库名
##4、继承spring-data-mongo的接口
public interface ChatRoomRepository extends MongoRepository<Chatroom,String> {
}
##5、启动类
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.boot.autoconfigure.domain.EntityScan;
import org.springframework.context.annotation.ComponentScan;
@SpringBootApplication
public class HybTestApplication {
public static void main(String[] args) {
SpringApplication.run(HybTestApplication.class,args);
}
}
##6、单元测试类
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.autoconfigure.domain.EntityScan;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.data.mongodb.core.MongoOperations;
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.test.context.junit4.SpringRunner;
import javax.annotation.Resource;
@SpringBootTest
@RunWith(SpringRunner.class)
public class TestMongo {
@Autowired
ChatRoomRepository chatRoomRepository;
@Test
public void test(){
Chatroom chatroom1 = chatRoomRepository.findOne("要测试某个表的id");
System.out.println(chatroom1);
}
}
**二、使用自定义的配置类连接多个mongodb数据库
##1、pom.xml
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<parent>
<artifactId>HYBCloud</artifactId>
<groupId>cn.haoyunbang</groupId>
<version>1.5.9.RELEASE</version>
</parent>
<modelVersion>4.0.0</modelVersion>
<artifactId>hyb-test</artifactId>
<dependencies>
<dependency>
<groupId>cn.haoyunbang.cloud</groupId>
<artifactId>hyb-common</artifactId>
<version>${hyb-cloud.version}</version>
</dependency>
<dependency>
<groupId>cn.haoyunbang.cloud</groupId>
<artifactId>hyb-entity</artifactId>
<version>${hyb-cloud.version}</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-mongodb</artifactId>
</dependency>
<dependency>
<groupId>net.minidev</groupId>
<artifactId>asm</artifactId>
<version>1.0.2</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>net.minidev</groupId>
<artifactId>json-smart</artifactId>
<version>2.2.1</version>
<scope>test</scope>
</dependency>
</dependencies>
</project>
##2、配置类
import com.mongodb.MongoClient;
import com.mongodb.client.MongoDatabase;
import com.mongodb.client.gridfs.GridFSBucket;
import com.mongodb.client.gridfs.GridFSBuckets;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.Configuration;
import com.mongodb.MongoClientURI;
import org.springframework.boot.autoconfigure.mongo.MongoProperties;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.data.mongodb.MongoDbFactory;
import org.springframework.data.mongodb.core.MongoTemplate;
import org.springframework.data.mongodb.core.SimpleMongoDbFactory;
import org.springframework.data.mongodb.core.convert.DefaultDbRefResolver;
import org.springframework.data.mongodb.core.convert.DefaultMongoTypeMapper;
import org.springframework.data.mongodb.core.convert.MappingMongoConverter;
import org.springframework.data.mongodb.core.mapping.MongoMappingContext;
/**
* Created by nbfujx on 2017-12-13.
*/
@Configuration
public class MongoConfig {
@Primary
@Bean
@ConfigurationProperties(prefix="application.yml中指定的数据库")
public MongoProperties primaryMongoProperties() {
return new MongoProperties();
}
@Primary
@Bean(name="nodeCludDevTemplate")
public MongoTemplate primaryMongoTemplate() throws Exception {
//remove _class
MappingMongoConverter converter =
new MappingMongoConverter(new DefaultDbRefResolver(primaryFactory()), new MongoMappingContext());
converter.setTypeMapper(new DefaultMongoTypeMapper(null));
return new MongoTemplate(primaryFactory(),converter);
}
@Primary
@Bean
public MongoDbFactory primaryFactory() throws Exception {
return new SimpleMongoDbFactory(new MongoClientURI(primaryMongoProperties().getUri()));
}
@Bean
@ConfigurationProperties(prefix="application.yml中指定的数据库")
public MongoProperties nodeClubDoctorMongoProperties() {
return new MongoProperties();
}
@Bean(name="nodeClubDoctorTemplate")
public MongoTemplate nodeClubDoctorMongoTemplate() throws Exception {
//remove _class
MappingMongoConverter converter =
new MappingMongoConverter(new DefaultDbRefResolver(nodeClubDoctorFactory()), new MongoMappingContext());
converter.setTypeMapper(new DefaultMongoTypeMapper(null));
return new MongoTemplate(nodeClubDoctorFactory(),converter);
}
@Bean
public MongoDbFactory nodeClubDoctorFactory() throws Exception {
return new SimpleMongoDbFactory(new MongoClientURI(nodeClubDoctorMongoProperties().getUri()));
}
.....
***注:application.yml中有多少个数据库可以指定多少个***
}
##3、Repository类
import org.springframework.data.mongodb.core.MongoOperations;
import org.springframework.data.mongodb.core.query.Query;
import org.springframework.data.mongodb.repository.MongoRepository;
import org.springframework.stereotype.Repository;
import javax.annotation.Resource;
import java.util.List;
@Repository
public class ChatRoomRepository{
@Resource(name="nodeCludDevTemplate")
private MongoOperations nodeClubDevMongoTemplate;
**//引入自定义配置类中指定的操作数据库的工具类**
//查询符合条件的所有
public <T> List<T> findList(Query query, Class<T> cls) {
return this.nodeClubDevMongoTemplate.find(query, cls);
}
//查询符合条件的某个
public <T> T findOne(Query query, Class<T> cls){
return this.nodeClubDevMongoTemplate.findOne(query, cls);
}
}
##4、application.yml
server:
port: 8082
#设置连接池
spring:
application:
name: hyb-doctor
# 数据库名----数据库
数据库名:
data:
mongodb:
uri: mongodb://用户名:密码@ip:端口/数据库名
.......
##5、单元测试类
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.autoconfigure.domain.EntityScan;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.data.mongodb.core.MongoOperations;
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.test.context.junit4.SpringRunner;
import javax.annotation.Resource;
@SpringBootTest
@RunWith(SpringRunner.class)
public class TestMongo {
@Autowired
ChatRoomRepository chatRoomRepository;
@Test
public void test(){
Query query = new Query();
query.addCriteria(new Criteria("_id").is("要测试的id"));
实体类 chatroom1 = chatRoomRepository.findOne(query,实体类.class);
System.out.println(chatroom1);
}
}