# jdbc-mongodb-driver

**Repository Path**: bqml/jdbc-mongodb-driver

## Basic Information

- **Project Name**: jdbc-mongodb-driver
- **Description**: 基于JAVA的开源的 mongodb JDBC 驱动
- **Primary Language**: Java
- **License**: Apache-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 1
- **Created**: 2024-07-10
- **Last Updated**: 2024-07-10

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# jdbc-mongodb-driver

# 介绍

一款开源的基于java的mongodb  JDBC  驱动

# 功能价值

1. 与mybaits融合：复用mybatis的功能特性，如:缓存,if动态判断标签等特性
2. 开发更加便捷: 统一dao层,使代码更具维护性，同时操作mongodb 便捷
3. 产品融合能力: 作为底层组件,可以与BI、低代码平台等需要JDBC特性产品融合能力



## 使用教程博文

```
《基于开源的JAVA mongodb jdbc 驱动 使用教程》:https://blog.csdn.net/gongbing798930123/article/details/135002530

《【开源Mongdb驱动】SpringBoot+Mybatis+Mongdb融合使用教程》:https://blog.csdn.net/gongbing798930123/article/details/135003268
```



#### 使用说明

## meavn pom文件依赖



	 <dependency>
	        <groupId>org.mongodb</groupId>
	        <artifactId>mongodb-driver</artifactId>
	        <version>3.11.2</version>
	  </dependency>
	
	<dependency>
	    <groupId>org.mongodb</groupId>
	    <artifactId>bson</artifactId>
	    <version>3.11.2</version>
	</dependency>


​	
	<dependency>
		<groupId>com.google.code.gson</groupId>
		<artifactId>gson</artifactId>
		<version>2.8.2</version>
	</dependency>
	<dependency>
	
	     <groupId>com.mongo.jdbc</groupId>
	  <artifactId>jdbc-mongodb-driver</artifactId>
	  <version>1.0.0</version>
	      <scope>system</scope>
	       <systemPath>${project.basedir}/src/main/resources/libs/mongo-connector-java-1.0.0.jar</systemPath>
	</dependency>




```
POM文件说明
mongo-connector-java-1.0.0.jar 因为没有放到meavn的公共库里面去，所以需要在开源地址下载里面对应的驱动包放在项目里面或者本地meavn仓库中。

```

## 操作代码

```
package com.mongo.jdbc.example;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

/**
 * 
 * @author:binggong
 * @createtime: 2023年12月10日 下午2:35:47 
 * @version:V.0.1
 * @tag:  mongodb jdbc 操作
 *
 */
public class JdbcMongoCommandExample {

	public static void main(String[] args) {
		// TODO Auto-generated method stub
		try {
			
			Class.forName("com.mongo.jdbc.Driver");
			
			/**
			 *  连接方案1
			 */
//			Properties properties = new Properties();
//			properties.put("user", "");
//			properties.put("password", "");
//			properties.put("address", "localhost:27017");
//			properties.put("dbname","demo_db");
//			properties.put("isSSL","false");
//			Connection conn = DriverManager.getConnection("", properties);
			
			
			/**
			 *  连接方案2
			 *  jdbc:mongo://localhost:27017/db_name?isSSL=false
			 */
			String jdbcUrl ="jdbc:mongo://localhost:27017/demo_db?isSSL=false";
			
			Connection conn = DriverManager.getConnection(jdbcUrl, null, null);
			 
			//写入操作
			String insertScript= "db.tb_user.insert({\"deptno\":?,\"dname\":?,\"loc\":?});";	
			PreparedStatement ps = conn.prepareStatement(insertScript);
			ps.setInt(1, 1);
			ps.setString(2, "数据中台部");
			ps.setString(3, "湖北武汉");
			
			ps.execute();
			
			
			//查询数据
			String queryScript = "db.tb_user.find()";
			
			 ps = conn.prepareStatement(queryScript);

			 ResultSet rs = ps.executeQuery();
			 
			 while(rs.next()) {
				String _id = rs.getString("_id");
				String deptno = rs.getString("deptno");
				String dname = rs.getString("dname");
				String loc = rs.getString("dname");
				
				System.out.println("_id:"+_id+"|deptno:"+deptno+"|dname:"+dname+"|loc:"+loc);

			 }
			 
			 //删除数据
			 String deleteScript = "db.tb_user.deleteMany({'loc':?})";
				
			 ps = conn.prepareStatement(deleteScript);
			 ps.setString(1, "湖北武汉");
				
			ps.execute();
			
			ps.close();
			
			
			
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		

	}

}
```



## 案例代码下载

![1702473495560](C:\Users\ADMINI~1\AppData\Local\Temp\1702473495560.png)