开发-数据库-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) https://docs.mongodb.org/getting-started/java/aggregation/ * 2) http://api.mongodb.org/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("2014-10-01T00:00:00Z"))                                .append("grade", "A")                                .append("score", 11),                        new Document()                                .append("date", format.parse("2014-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();}}}