Java中获取MongoDB连接的方法

首先是所需jar包，Maven中的配置如下：

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

<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>

　　获取连接的代码如下（本中用的是模板类）：

?

1 2 3 4 5 6 7 8

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();

　　或者用如下方式获取：

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14

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();

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

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190

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());     } }