Mongodb spring boot aggregate 示例,原生shell查询,查询对照表

MongoDB spring boot aggregate 示例,原生shell查询,查询对照表

环境

• MongoDB版本 4.0.10
• Spring boot版本 2.1.6.RELEASE

maven依赖

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-mongodb</artifactId>
        </dependency>

spring boot 配置文件 application.properties

#数据库名
spring.data.mongodb.database=mycol
#ip
spring.data.mongodb.host=127.0.0.1
#端口
spring.data.mongodb.port=27017

java代码

import com.mongodb.BasicDBObject;
import org.bson.Document;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.data.mongodb.core.MongoTemplate;
import org.springframework.test.context.junit4.SpringRunner;

/**

• @ClassName MongoDBJDBC
• @Description TODO
• @Author 养仓鼠的程序员
• @Date 2019/6/28 0028 下午 15:10
• @Version 1.0
  **/

@RunWith(SpringRunner.class)
@SpringBootTest
public class MongoDBJDBC {
@Autowired
MongoTemplate mongoTemplate;

@Test
public void aggregate(){
    try{
        BasicDBObject bson = new BasicDBObject();
        bson.put ("$eval", "db.version()");
        Document object = mongoTemplate.getDb().runCommand(bson);
        System.out.println (object.toJson ());
    } catch (Exception e){
        e.printStackTrace();
    }
}

}

aggregate 和sql对照表

数据结构

{
    "dataTime" : ISODate("2019-08-26 17:00:00"),