Java中获取MongoDB连接的方法详解

所属分类: 软件编程 / java 阅读数: 36
收藏 0 赞 0 分享

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

<dependency>
  <groupId>org.mongodb</groupId>
  <artifactId>mongodb-driver</artifactId>
  <version>3.4.1</version>
</dependency>
<dependency>
  <groupId>org.mongodb</groupId>
  <artifactId>bson</artifactId>
  <version>3.4.1</version>
</dependency>
<dependency>
  <groupId>org.springframework.data</groupId>
  <artifactId>spring-data-mongodb</artifactId>
  <version>1.7.0.RELEASE</version>
</dependency>  
<dependency>
  <groupId>org.mongodb</groupId>
  <artifactId>mongo-java-driver</artifactId>
  <version>3.9.1</version>
</dependency>

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

List<ServerAddress> addrs = new ArrayList<ServerAddress>();
addrs.add(new ServerAddress(dataSource.getSourceIp(), Integer.valueOf(dataSource.getSourcePort())));
List<MongoCredential> credentials = new ArrayList<MongoCredential>();
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<ServerAddress> addrs = new ArrayList<ServerAddress>(); 
addrs.add(serverAddress); 
//MongoCredential.createScramSha1Credential()三个参数分别为 用户名 数据库名称 密码 
MongoCredential credential = MongoCredential.createScramSha1Credential("root", "admin", "123456Ab".toCharArray()); 
List<MongoCredential> credentials = new ArrayList<MongoCredential>(); 
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<ServerAddress> addrs = new ArrayList<ServerAddress>(); 
    addrs.add(serverAddress);
      
    //MongoCredential.createScramSha1Credential(username,source,password)三个参数分别为 用户名 数据库名称 密码 
    MongoCredential credential = MongoCredential.createScramSha1Credential(username, databaseName, password.toCharArray()); 
    List<MongoCredential> credentials = new ArrayList<MongoCredential>(); 
    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<String,String>(){{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<ShopDO> 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<ShopDO> 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<ShopDO> 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<ShopDO> 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<ShopDO> 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<ShopDO> 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());
  }
}

以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持脚本之家。

更多精彩内容其他人还在看

Springmvc restful配置遇到的小坑

本文是小编给大家带了的Springmvc restful配置遇到的小小坑,小编给大家带来了问题原因及解决办法,非常不错,具有参考借鉴价值,感兴趣的朋友一起看下吧
收藏 0 赞 0 分享

Java中的匿名内部类小结

java内部类分为: 成员内部类、静态嵌套类、方法内部类、匿名内部类。这篇文章主要介绍了Java中的匿名内部类的相关资料,需要的朋友可以参考下
收藏 0 赞 0 分享

Java的云打印Lodop

这篇文章主要介绍了Java的云打印Lodop 的相关资料,非常不错,具有参考借鉴价值,需要的朋友可以参考下
收藏 0 赞 0 分享

Java线程池框架核心代码解析

这篇文章主要针对Java线程池框架核心代码进行详细解析,分析Java线程池框架的实现ThreadPoolExecutor,感兴趣的小伙伴们可以参考一下
收藏 0 赞 0 分享

Java 交换两个变量的数值实现方法

下面小编就为大家带来一篇Java 交换两个变量的数值实现方法。小编觉得挺不错的,现在就分享给大家,也给大家做个参考。一起跟随小编过来看看吧
收藏 0 赞 0 分享

全面了解JAVA_BaseDAO数据处理类

下面小编就为大家带来一篇全面了解JAVA_BaseDAO数据处理类。小编觉得挺不错的,现在就分享给大家,也给大家做个参考。一起跟随小编过来看看吧
收藏 0 赞 0 分享

java、python、JavaScript以及jquery循环语句的区别

本篇文章主要介绍java、python、JavaScript以及jquery的循环语句的区别,这里整理了它们循环语句语法跟示例,以便大家阅读,更好的区分它们的不同
收藏 0 赞 0 分享

基于JDBC封装的BaseDao(实例代码)

下面小编就为大家带来一篇基于JDBC封装的BaseDao(实例代码)。小编觉得挺不错的,现在就分享给大家,也给大家做个参考。一起跟随小编过来看看吧
收藏 0 赞 0 分享

简单通用JDBC辅助类封装(实例)

下面小编就为大家带来一篇简单通用JDBC辅助类封装(实例)。小编觉得挺不错的,现在就分享给大家,也给大家做个参考。一起跟随小编过来看看吧
收藏 0 赞 0 分享

浅谈java线程中生产者与消费者的问题

下面小编就为大家带来一篇浅谈java线程中生产者与消费者的问题。小编觉得挺不错的,现在就分享给大家,也给大家做个参考。一起跟随小编过来看看吧
收藏 0 赞 0 分享
查看更多