java连接Mongo Connector for BI使用sql查询mongodb

（1）maven-->pom.xml添加jar

	<!-- https://mvnrepository.com/artifact/org.mongodb/mongo-java-driver -->
		<dependency>
		    <groupId>org.mongodb</groupId>
		    <artifactId>mongo-java-driver</artifactId>
		    <version>3.12.5</version>
		</dependency>
		<dependency>
		    <groupId>org.mongodb</groupId>
		    <artifactId>mongosql-auth</artifactId>
		    <version>1.2.0</version>
		</dependency>
		<dependency>
		    <groupId>org.springframework.boot</groupId>
		    <artifactId>spring-boot-starter-jdbc</artifactId>
		</dependency>
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>5.1.47</version>  <!-- 8.0或更高版本mongodb for bi（mongosql-auth）不支持 -->
		</dependency>
		<dependency>

（2）application.properties添加url，没有账号和密码

spring.datasource.driverClassName=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3307/myDatabase?useSSL=false&authenticationPlugins=org.mongodb.mongosql.auth.plugin.MongoSqlAuthenticationPlugin
 

（3）查询数据

import java.util.Map;

import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.jdbc.core.JdbcTemplate;

@SpringBootTest
public class TestMongodbForBi {
 
	@Autowired
	JdbcTemplate jdbcTemplate;
	  @Test
	  void contextLoads() {
		  String sql="select count(*) from myCollection ";
		  Map<String, Object> map=  jdbcTemplate.queryForMap(sql);
         System.out.println(map);
         System.out.println(map.size());
	  }
}