mongodb bi-connector spring boot 集成试用

实际上没多少技术含量，就是spring data jdbc+mysql 数据访问而且，主要就是几个参数配置

spring boot 项目结构

使用官方的初始化器

• 代码结构

├── HELP.md

├── demo.iml

├── mvnw

├── mvnw.cmd

├── pom.xml

└── src

    ├── main

    │ ├── java

    │ │ └── com

    │ │ └── dalong

    │ │ └── mongobi

    │ │ └── demo

    │ │ ├── CntArticleDAO.java

    │ │ ├── DemoApplication.java

    │ │ └── RestApi.java

    │ └── resources

    │ ├── application.properties

    │ ├── static

    │ └── templates

    └── test

        └── java

            └── com

                └── dalong

                    └── mongobi

                        └── demo

                            └── DemoApplicationTests.java

• 代码说明
  RestApi.java 为简单查询，CntArticleDAO.java 为数据访问，application.properties 为jdbc 配置
  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 https://maven.apache.org/xsd/maven-4.0.0.xsd">

 <modelVersion>4.0.0</modelVersion>

 <parent>

  <groupId>org.springframework.boot</groupId>

  <artifactId>spring-boot-starter-parent</artifactId>

  <version>2.2.4.RELEASE</version>

  <relativePath/> <!-- lookup parent from repository -->

 </parent>

 <groupId>com.dalong.mongobi</groupId>

 <artifactId>demo</artifactId>

 <version>0.0.1-SNAPSHOT</version>

 <name>demo</name>

 <description>Demo project for Spring Boot</description>

​

 <properties>

  <java.version>1.8</java.version>

 </properties>

​

 <dependencies>

  <dependency>

   <groupId>org.springframework.boot</groupId>

   <artifactId>spring-boot-starter-data-jdbc</artifactId>

  </dependency>

  <dependency>

   <groupId>org.springframework.boot</groupId>

   <artifactId>spring-boot-starter-jdbc</artifactId>

  </dependency>

  <dependency>

   <groupId>org.springframework.boot</groupId>

   <artifactId>spring-boot-starter-web</artifactId>

  </dependency>

  <dependency>

   <groupId>mysql</groupId>

   <artifactId>mysql-connector-java</artifactId>

   <version>5.1.42</version>

  </dependency>

  <dependency>

   <groupId>org.springframework.boot</groupId>

   <artifactId>spring-boot-starter-test</artifactId>

   <scope>test</scope>

   <exclusions>

    <exclusion>

     <groupId>org.junit.vintage</groupId>

     <artifactId>junit-vintage-engine</artifactId>

    </exclusion>

   </exclusions>

  </dependency>

 </dependencies>

​

 <build>

  <plugins>

   <plugin>

    <groupId>org.springframework.boot</groupId>

    <artifactId>spring-boot-maven-plugin</artifactId>

   </plugin>

  </plugins>

 </build>

​

</project>

CntArticleDAO.java

package com.dalong.mongobi.demo;

​

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.jdbc.core.JdbcTemplate;

import org.springframework.stereotype.Repository;

​

import java.util.List;

import java.util.Map;

​

@Repository

public class CntArticleDAO {

​

    @Autowired

    JdbcTemplate jdbcTemplate;

    public List<Map<String, Object>> search() {

        String sql = "select * from cntArticle";

        return jdbcTemplate.queryForList(sql);

    }

}

 

RestApi.java

package com.dalong.mongobi.demo;

​

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.web.bind.annotation.RequestMapping;

import org.springframework.web.bind.annotation.RestController;

​

@RestController

public class RestApi {

    @Autowired

    CntArticleDAO cntArticleDAO;

    @RequestMapping("/cns")

    public Object users(){

       return cntArticleDAO.search();

    }

}

启动效果

mvn spring-boot:run

主要说明

jdbc 的版本以及ssl 配置参数，是最重要的，按照官方的介绍8以及最新的是不可以的（测试也是），支持ssl 的
jdbc 配置为jdbc:mysql://localhost:3307/appdemos?useSSL=true,同时官方也提供了一个auth 的扩展，可以参
考https://docs.mongodb.com/bi-connector/master/reference/auth-plugin-jdbc/

参考资料

https://docs.mongodb.com/bi-connector/master/reference/auth-plugin-jdbc/
https://github.com/rongfengliang/mongobi-java