700字范文,内容丰富有趣,生活中的好帮手!
700字范文 > 开发-数据库-MongoDB初探

开发-数据库-MongoDB初探

时间:2018-06-01 15:26:19

相关推荐

开发-数据库-MongoDB初探

MangoDB(3.03)基本操作,增删改查。

package test;import java.text.DateFormat;import java.text.SimpleDateFormat;import java.util.Arrays;import java.util.Locale;import org.bson.Document;import com.mongodb.Block;import com.mongodb.MongoClient;import com.mongodb.client.AggregateIterable;import com.mongodb.client.FindIterable;import com.mongodb.client.MongoDatabase;import com.mongodb.client.model.Filters;import com.mongodb.client.model.Sorts;import com.mongodb.client.result.UpdateResult;/** you can find anything you need at * 1) /getting-started/java/aggregation/* 2) /java/3.0/overview-summary.html*/public class Demo_MangoDB {public static void main(String[] args) {try {MongoClient mongoClient = new MongoClient("localhost", 27017);MongoDatabase db = mongoClient.getDatabase("test");DateFormat format = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss'Z'", Locale.ENGLISH);// If you attempt to add documents to a collection that does not exist, MongoDB will create the collection for you.db.getCollection("restaurants").insertOne(new Document("address",new Document().append("street", "2 Avenue").append("zipcode", "10075").append("building", "1480").append("coord", Arrays.asList(-73.9557413, 40.7720266))).append("borough", "Manhattan").append("cuisine", "Italian").append("grades", Arrays.asList(new Document().append("date", format.parse("-10-01T00:00:00Z")).append("grade", "A").append("score", 11),new Document().append("date", format.parse("-01-16T00:00:00Z")).append("grade", "B").append("score", 17))).append("name", "Vella").append("restaurant_id", "41704620"));FindIterable<Document> iterable = db.getCollection("restaurants").find();iterable.forEach(new Block<Document>() {@Overridepublic void apply(Document document) {System.out.println(document);}});//Find or Query Dataiterable = db.getCollection("restaurants").find(new Document("borough", "Manhattan"));//iterable = db.getCollection("restaurants").find(Filters.eq("borough", "Manhattan"));iterable = db.getCollection("restaurants").find(new Document("address.zipcode", "10075"));iterable = db.getCollection("restaurants").find(Filters.eq("address.zipcode", "10075"));iterable = db.getCollection("restaurants").find(Filters.eq("grades.grade", "B"));iterable = db.getCollection("restaurants").find(new Document("grades.score", new Document("$gt", 30)));iterable = db.getCollection("restaurants").find(Filters.gt("grades.score", 30));iterable = db.getCollection("restaurants").find(new Document("cuisine", "Italian").append("address.zipcode", "10075"));iterable = db.getCollection("restaurants").find(Filters.and(Filters.eq("cuisine", "Italian"), Filters.eq("address.zipcode", "10075")));iterable = db.getCollection("restaurants").find(new Document("$or", Arrays.asList(new Document("cuisine", "Italian"),new Document("address.zipcode", "10075"))));iterable = db.getCollection("restaurants").find(Filters.or(Filters.eq("cuisine", "Italian"), Filters.eq("address.zipcode", "10075")));iterable = db.getCollection("restaurants").find().sort(new Document("borough", 1).append("address.zipcode", 1)); //1 for ascending and -1 for descending.db.getCollection("restaurants").find().sort(Sorts.ascending("borough", "address.zipcode"));//Update DataUpdateResult ur = db.getCollection("restaurants").updateOne(new Document("name", "Juni"), new Document("$set", new Document("cuisine", "American (New)")).append("$currentDate", new Document("lastModified", true)));System.out.println(ur.getModifiedCount());db.getCollection("restaurants").updateOne(new Document("restaurant_id", "41156888"),new Document("$set", new Document("address.street", "East 31st Street")));db.getCollection("restaurants").updateMany(new Document("address.zipcode", "10016").append("cuisine", "other"),new Document("$set", new Document("cuisine", "Category To Be Determined")).append("$currentDate", new Document("lastModified", true)));db.getCollection("restaurants").replaceOne(new Document("restaurant_id", "41704620"),new Document("address",new Document().append("street", "2 Avenue").append("zipcode", "10075").append("building", "1480").append("coord", Arrays.asList(-73.9557413, 40.7720266))).append("name", "Vella 2"));//Remove Datadb.getCollection("restaurants").deleteMany(new Document("borough", "Manhattan")); //Remove All Documents That Match a Condition//db.getCollection("restaurants").deleteMany(new Document()); //Remove All Documents//db.getCollection("restaurants").drop(); //Drop a Collection//Data AggregationAggregateIterable<Document> aggIterable = db.getCollection("restaurants").aggregate(Arrays.asList(new Document("$group", new Document("_id", "$building").append("count", new Document("$sum", 1)))));aggIterable = db.getCollection("restaurants").aggregate(Arrays.asList(new Document("$match", new Document("address.street", "2 Avenue").append("address.building", "1480")),new Document("$group", new Document("_id", "$address.zipcode").append("count", new Document("$sum", 1)))));aggIterable.forEach(new Block<Document>() {@Overridepublic void apply(Document document) {// TODO Auto-generated method stubSystem.out.println(document.toJson());}});//db.drop(); //Drop the current Database//mongoClient.dropDatabase("test");mongoClient.close();} catch (Exception e) {e.printStackTrace();}}}

本内容不代表本网观点和政治立场,如有侵犯你的权益请联系我们处理。
网友评论
网友评论仅供其表达个人看法,并不表明网站立场。