java mongodb 关闭连接_Java中获取MongoDB连接的方法

news/2024/7/8 9:45:37

首先是所需jar包,Maven中的配置如下:

org.mongodb

mongodb-driver

3.4.1

org.mongodb

bson

3.4.1

org.springframework.data

spring-data-mongodb

1.7.0.RELEASE

org.mongodb

mongo-java-driver

3.9.1

获取连接的代码如下(本中用的是模板类):

List addrs = new ArrayList();

addrs.add(new ServerAddress(dataSource.getSourceIp(), Integer.valueOf(dataSource.getSourcePort())));

List credentials = new ArrayList();

credentials.add(MongoCredential.createScramSha1Credential(dataSource.getUsername(), dataSource.getSourceName(), dataSource.getPassword().toCharArray()));

MongoClient mongoClient = new MongoClient(addrs, credentials);

MongoDbFactory mongoDbFactory = new SimpleMongoDbFactory(mongoClient, dataSource.getSourceName());

MongoTemplate mongoTemplate = new MongoTemplate(mongoDbFactory);

mongoTemplate.getCollectionNames();

或者用如下方式获取:

ServerAddress serverAddress = new ServerAddress("192.168.16.121",27017);

List addrs = new ArrayList();

addrs.add(serverAddress);

//MongoCredential.createScramSha1Credential()三个参数分别为 用户名 数据库名称 密码

MongoCredential credential = MongoCredential.createScramSha1Credential("root", "admin", "123456Ab".toCharArray());

List credentials = new ArrayList();

credentials.add(credential);

//通过连接认证获取MongoDB连接

MongoClient mongoClient = new MongoClient(addrs,credentials);

//连接到数据库

MongoDatabase mongoDatabase = mongoClient.getDatabase("admin");

mongoDatabase.getCollection("test").find().iterator();

// 关闭数据库连接

mongoClient.close();

附带简单增删改查的例子:

package test;

import java.util.ArrayList;

import java.util.HashMap;

import java.util.List;

import org.junit.Test;

import org.springframework.data.domain.Sort;

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.query.Criteria;

import org.springframework.data.mongodb.core.query.Query;

import org.springframework.data.mongodb.core.query.Update;

import com.mongodb.MongoClient;

import com.mongodb.MongoCredential;

import com.mongodb.ServerAddress;

import com.mongodb.WriteResult;

import bean.Book;

import bean.Good;

import bean.ShopDO;

import net.sf.json.JSONObject;

public class MongoTemplateTest {

public static MongoTemplate mongoTemplate = getMongoTemplate();

public static void main(String[] args) {

System.out.println(mongoTemplate.getCollectionNames());

}

public static MongoTemplate getMongoTemplate(){

String host = "192.168.16.121";

int port = 27017;

String databaseName = "test";

String username = "root";

String password = "123456Ab";

//ServerAddress(host,port)两个参数分别为 IP地址 端口号

ServerAddress serverAddress = new ServerAddress(host,port);

List addrs = new ArrayList();

addrs.add(serverAddress);

//MongoCredential.createScramSha1Credential(username,source,password)三个参数分别为 用户名 数据库名称 密码

MongoCredential credential = MongoCredential.createScramSha1Credential(username, databaseName, password.toCharArray());

List credentials = new ArrayList();

credentials.add(credential);

//通过连接认证获取MongoDB连接

MongoClient mongoClient = new MongoClient(addrs,credentials);

MongoDbFactory mongoDbFactory = new SimpleMongoDbFactory(mongoClient, databaseName);

MongoTemplate mongoTemplate = new MongoTemplate(mongoDbFactory);

return mongoTemplate;

}

/**

* 插入数据

*/

@Test

public void save(){

ShopDO shop1 = new ShopDO(100L,"菜鸟教程");

ShopDO shop2 = new ShopDO(101L,"有道笔记");

mongoTemplate.save(shop1,"col");

mongoTemplate.save(shop2,"col");

System.out.println("mongoDB插入数据成功,集合为col,文档为:"+mongoTemplate.getCollection("col"));

}

@Test

public void save1(){

Book book = new Book(22L,"英语","32.5");

mongoTemplate.save(book,"col");

}

@Test

public void save2(){

Good good = new Good(new HashMap(){{put("id","1");put("name","动物");}});

mongoTemplate.save(good,"col");

}

@Test

public void save3(){

mongoTemplate.save(JSONObject.fromObject("{\"这样\":\"we\",\"好吧\":\"hai\"}"),"col");

System.out.println("mongoDB插入数据成功,集合为col,文档为:"+mongoTemplate.getCollection("col"));

}

/**

* 查询所有

*/

@Test

public void findAll(){

List list = mongoTemplate.findAll(ShopDO.class,"col");

System.out.println("mongoDB查询数据成功,集合为col,文档为:");

for (ShopDO shopDO:list){

System.out.println(shopDO.getNo()+"/"+shopDO.getName());

}

}

/**

* 单条件查询

*/

@Test

public void simpleQuery(){

Query query = Query.query(Criteria.where("no").is(100L));

List list = mongoTemplate.find(query,ShopDO.class,"col");

System.out.println("mongoDB按条件ID查询数据成功,集合为col,文档为:");

for (ShopDO shopDO:list){

System.out.println(shopDO.getNo()+"/"+shopDO.getName());

}

}

/**

* 多条件查询

*/

@Test

public void muchQuery(){

Criteria criteria = new Criteria();

//or是条件或查询,and是条件与查询

criteria.orOperator(

Criteria.where("no").is(100),

Criteria.where("name").is("菜鸟教程"));

Query query = new Query(criteria); //组合查询放入query

Sort sort = new Sort(new Sort.Order(Sort.Direction.DESC,"no")); //结果集进行排序

query.with(sort);

List list = mongoTemplate.find(query,ShopDO.class,"col");

System.out.println("mongoDB组合查询数据成功,集合为col,文档为:");

for (ShopDO shopDO:list){

System.out.println(shopDO.getNo()+"/"+shopDO.getName());

}

}

/**

* 分页查询

*/

@Test

public void LimitQuery(){

Query query = new Query();

query.skip(1).limit(3);

List list = mongoTemplate.find(query,ShopDO.class,"col");

System.out.println("mongoDB分页查询下标为1开始总共3行数据,集合为col,文档为:");

for (ShopDO shopDO:list){

System.out.println(shopDO.getNo()+"/"+shopDO.getName());

}

}

/**

* 模糊查询

*/

@Test

public void LikeQuery(){

Query query = new Query(Criteria.where("name").regex("菜鸟"));

List list = mongoTemplate.find(query,ShopDO.class,"col");

System.out.println("mongoDB查询名称叫菜鸟的数据成功,集合为col,文档为:");

for (ShopDO shopDO:list){

System.out.println(shopDO.getNo()+"/"+shopDO.getName());

}

Update update = new Update();

update.set("name","菜鸟教程old");

WriteResult wr = mongoTemplate.updateMulti(query,update,"col");

System.out.println("mongoDB更新数据成功,集合为col,行数为:" + wr.getN());

}

/**

* 更新

*/

@Test

public void update(){

Query query = new Query(Criteria.where("no").is(100));

List list = mongoTemplate.find(query,ShopDO.class,"col");

System.out.println("mongoDB查询no为100的数据成功,集合为col,文档为:");

for (ShopDO shopDO:list){

System.out.println(shopDO.getNo()+"/"+shopDO.getName());

}

Update update = new Update();

update.set("name","菜鸟教程new");

WriteResult wr = mongoTemplate.updateFirst(query,update,"col");

System.out.println("mongoDB更新数据成功,集合为col,行数为:" + wr.getN());

}

/**

* 删除

*/

@Test

public void delete(){

Query query = new Query(Criteria.where("no").is(1));

WriteResult result = mongoTemplate.remove(query, "col");

System.out.println("mongoDB删除数据成功,集合为col,行数为:" + result.getN() + "删除的ID为"+result.getUpsertedId());

}

}


http://www.niftyadmin.cn/n/4747375.html

相关文章

用思维导图学习java_用思维导图纪录Java学习过程

之前小编我给大家分享过一些Java学习相关的图片,比如 Java入门三张图够吗 ,这种图正是大名鼎鼎的思维导图。思维导图又叫心智导图是表达发散性思维的有效的图形思维工具 ,它简单却又极其有效,是一种革命性的思维工具。思维导图运用…

apparmor mysql_apparmor 引起自定义mysql 日志问题

今天手贱,看到mysql 的日志在/var/log/mysql下面。总是觉得别扭,于是就想改变日志的位置,本人开发环境 vagrant ubuntu12.04 ,在/etc/mysql/mysql中修改了general_log的位置,放在/data/logs/mysql下面然后重启服务,s…

java extjs4 分页_ExtJs4 SpringMvc3 实现Grid 分页

新建一个Maven webapp项目,webxml以及spring配置没什么需要注意的,不再赘述。Maven依赖:(个人习惯,有用没用的都加上。。。)4.0.0zp.testextjswar0.0.1-SNAPSHOTextjs Maven Webapphttp://maven.apache.orgjunitjunit4.7testjstlj…

正则表达式判断是否mac地址 java_使用正则表达式判断字符串是否为MAC地址

今天Boss给了一个小任务,要求给定一个字符串,判断该字符串是否是MAC地址,并用Java和正则表达式实现。于是我顺便百度了下MAC地址,并在cmd下使用getmac获取本机的MAC地址,了解了一点后,就用Java实现了。为了…

java语言学习要点_菜鸟入门:Java语言学习六大要点

原标题:菜鸟入门:Java语言学习六大要点Java的学习是比较复杂的,主要表现在相关的一系列平台、规范和协议上。有经验的Java程序员都知道,只掌握了Java语言本身很难开发应用程序。不讨论这些复杂的概念,而是我是参加的培…

java终止正在运行的线程_Java再学习——停止一个正在运行的线程

关于这个问题,先了解一下Thread类方法中被废弃的那些方法。suspend(), resume(),stop()/stop(Throwable obj),destroy()首先,stop(Throwable obj)和destroy()方法在最新的Java中直接就不支持了,没必要去看了。我们只需瞧瞧suspend(), resume(…

mysql 5.7 jdbc 8.0_mysql8.0 jdbc连接注意事项

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼url增加参数useSSL 和时区 : jdbc:mysql://localhost:3306/mydb?useSSLfalse&serverTimezoneUTCdriver变化: com.mysql.jdbc.Driver > com.mysql.cj.jdbc.Driver常见错误提示1:如果driver没有添加cj&#xff0c…

java xml路径_java读取xml路径

*内容如下: java 使用相对路径读取 xml 文件: 一、xml 文件一般的存放位置有三个: 1.放在 WEB-INF 下; 2.xml 文件放在/WEB-INF/classes 目录下或 class......JAVA读取xml文件中节点值_计算机软件及应用_IT/计算机_专业资料。pub...使用Java读写XML文档_计算机软件及应用_IT/计…