List of usage examples for com.mongodb DBCollection insert
public WriteResult insert(final List<? extends DBObject> documents)
From source file:tcc.emanuele.Principal.java
public static void main(String[] args) throws SQLException { String sql = ""; try {/* w w w .ja va 2 s . co m*/ //conexo com o postgreSQL ConexaoPostgres c = new ConexaoPostgres(); c.conectar(); sql = "select * from produtos"; ResultSet res = c.executaConsulta(sql); List<ClasseObjeto> lista = new ArrayList(); ClasseObjeto o = null; while (res.next()) { o = new ClasseObjeto(res.getString("nome"), res.getString("descricao"), res.getDouble("estoque"), res.getDouble("preco")); lista.add(o); } //conexo com o mongoDB ConexoMongo cm = new ConexoMongo(); cm.conectar(); DBCollection coll = cm.getColecao("produtos"); for (int i = 0; i <= lista.size(); i++) { BasicDBObject doc = new BasicDBObject(); doc.put("nome", lista.get(i).getNome()); doc.put("descricao", lista.get(i).getDescricao()); doc.put("estoque", lista.get(i).getEstoque()); doc.put("preco", lista.get(i).getPreco()); coll.insert(doc); } } catch (Exception e) { System.err.println(e.getClass().getName() + ": " + e.getMessage()); } }
From source file:test.mongodb.servlet.MongoDBServlet.java
License:Open Source License
protected void tutorial(PrintWriter pw) { try {//from w w w . j av a 2 s. co m mongoDB.requestStart(); pw.format("<h1>Tutorial Objects Added to DB</h1>\n"); DBCollection coll = mongoDB.getCollection("testCollection"); BasicDBObject doc = new BasicDBObject(); doc.put("name", "MongoDB"); doc.put("type", "database"); doc.put("count", 1); BasicDBObject info = new BasicDBObject(); info.put("x", 203); info.put("y", 102); doc.put("info", info); coll.insert(doc); DBObject myDoc = coll.findOne(); pw.format("<h2>testCollection</h2><pre>%s</pre>\n", myDoc.toString()); for (int i = 0; i < 100; i++) { coll.insert(new BasicDBObject().append("i", i)); } BasicDBObject query = new BasicDBObject(); query.put("i", 71); DBCursor cur = coll.find(query); pw.format("<h2>100 i objects, #71:</h2><pre>%s</pre>\n", cur.next()); coll.createIndex(new BasicDBObject("i", 1)); // create index on "i", ascending } finally { mongoDB.requestDone(); } }
From source file:teste.mongo.example.QuickTourAdmin.java
License:Apache License
public static void main(String[] args) throws Exception { // connect to the local database server MongoClient mongoClient = new MongoClient(); /*/* w w w .ja v a2 s .c o m*/ // Authenticate - optional MongoCredential credential = MongoCredential.createMongoCRCredential(userName, database, password); MongoClient mongoClient = new MongoClient(new ServerAddress(), Arrays.asList(credential)); */ System.out.println("##### DataBaseInitial"); // get db names for (String s : mongoClient.getDatabaseNames()) { System.out.println(s); } // get a db DB db = mongoClient.getDB("mydb"); System.out.println("##### With new DataBase MYDB"); // do an insert so that the db will really be created. Calling getDB() doesn't really take any // action with the server db.getCollection("testcollection").insert(new BasicDBObject("i", 1)); for (String s : mongoClient.getDatabaseNames()) { System.out.println(s); } // drop a database mongoClient.dropDatabase("mydb"); System.out.println("##### DataBase drop MYDB"); for (String s : mongoClient.getDatabaseNames()) { System.out.println(s); } // create a collection db = mongoClient.getDB("mydb"); db.createCollection("testCollection", new BasicDBObject("capped", true).append("size", 1048576)); System.out.println("##### ListAllCollection MYDB"); // List all collections for (String s : db.getCollectionNames()) { System.out.println(s); } // Dropping a collection DBCollection testCollection = db.getCollection("testCollection"); testCollection.drop(); System.out.println("##### ListAllCollection MYDB - Drop testCollection"); System.out.println(db.getCollectionNames()); /* Indexes */ // get a collection object to work with DBCollection coll = db.getCollection("testCollection"); // drop all the data in it coll.drop(); // create an index on the "i" field coll.createIndex(new BasicDBObject("i", 1)); // Geospatial query coll.createIndex(new BasicDBObject("loc", "2dsphere")); BasicDBList coordinates = new BasicDBList(); coordinates.put(0, -73.97); coordinates.put(1, 40.77); coll.insert(new BasicDBObject("name", "Central Park") .append("loc", new BasicDBObject("type", "Point").append("coordinates", coordinates)) .append("category", "Parks")); coordinates.put(0, -73.88); coordinates.put(1, 40.78); coll.insert(new BasicDBObject("name", "La Guardia Airport") .append("loc", new BasicDBObject("type", "Point").append("coordinates", coordinates)) .append("category", "Airport")); // Find whats within 500m of my location BasicDBList myLocation = new BasicDBList(); myLocation.put(0, -73.965); myLocation.put(1, 40.769); DBObject myDoc = coll.findOne(new BasicDBObject("loc", new BasicDBObject("$near", new BasicDBObject("$geometry", new BasicDBObject("type", "Point").append("coordinates", myLocation)) .append("$maxDistance", 500)))); System.out.println(myDoc.get("name")); // create a text index on the "content" field coll.createIndex(new BasicDBObject("content", "text")); coll.insert(new BasicDBObject("_id", 0).append("content", "textual content")); coll.insert(new BasicDBObject("_id", 1).append("content", "additional content")); coll.insert(new BasicDBObject("_id", 2).append("content", "irrelevant content")); // Find using the text index BasicDBObject search = new BasicDBObject("$search", "textual content -irrelevant"); BasicDBObject textSearch = new BasicDBObject("$text", search); int matchCount = coll.find(textSearch).count(); System.out.println("Text search matches: " + matchCount); // Find using the $language operator textSearch = new BasicDBObject("$text", search.append("$language", "english")); matchCount = coll.find(textSearch).count(); System.out.println("Text search matches (english): " + matchCount); // Find the highest scoring match BasicDBObject projection = new BasicDBObject("score", new BasicDBObject("$meta", "textScore")); myDoc = coll.findOne(textSearch, projection); System.out.println("Highest scoring document: " + myDoc); // list the indexes on the collection List<DBObject> list = coll.getIndexInfo(); for (final DBObject o : list) { System.out.println(o); } // clean up mongoClient.dropDatabase("mydb"); mongoClient.close(); }
From source file:tour.Decimal128LegacyAPIQuickTour.java
License:Apache License
/** * Run this main method to see the output of this quick example. * * @param args takes an optional single argument for the connection string *///from www .jav a 2 s .c o m public static void main(final String[] args) { MongoClient mongoClient; if (args.length == 0) { // connect to the local database server mongoClient = new MongoClient(); } else { mongoClient = new MongoClient(new MongoClientURI(args[0])); } // get handle to "mydb" database DB database = mongoClient.getDB("mydb"); // get a handle to the "test" collection DBCollection collection = database.getCollection("test"); // drop all the data in it collection.drop(); // make a document and insert it BasicDBObject doc = new BasicDBObject("name", "MongoDB").append("amount1", Decimal128.parse(".10")) .append("amount2", new Decimal128(42L)).append("amount3", new Decimal128(new BigDecimal(".200"))); collection.insert(doc); DBObject first = collection .findOne(QueryBuilder.start("amount1").is(new Decimal128(new BigDecimal(".10"))).get()); Decimal128 amount3 = (Decimal128) first.get("amount3"); BigDecimal amount2AsBigDecimal = amount3.bigDecimalValue(); System.out.println(amount3.toString()); System.out.println(amount2AsBigDecimal.toString()); }
From source file:tour.QuickTour.java
License:Apache License
/** * Run this main method to see the output of this quick example. * * @param args takes an optional single argument for the connection string *//*from w ww.j a v a 2s . co m*/ @SuppressWarnings("deprecation") public static void main(final String[] args) { MongoClient mongoClient; if (args.length == 0) { // connect to the local database server mongoClient = new MongoClient(); } else { mongoClient = new MongoClient(new MongoClientURI(args[0])); } // get handle to the "mydb" database DB db = mongoClient.getDB("mydb"); // get a list of the collections in this database and print them out Set<String> collectionNames = db.getCollectionNames(); for (final String s : collectionNames) { System.out.println(s); } // get a handle to the "test" collection DBCollection collection = db.getCollection("test"); // drop all the data in it collection.drop(); // make a document and insert it BasicDBObject doc = new BasicDBObject("name", "MongoDB").append("type", "database").append("count", 1) .append("info", new BasicDBObject("x", 203).append("y", 102)); collection.insert(doc); // get it (since it's the only one in there since we dropped the rest earlier on) DBObject myDoc = collection.findOne(); System.out.println(myDoc); // now, lets add lots of little documents to the collection so we can explore queries and cursors List<DBObject> documents = new ArrayList<DBObject>(); for (int i = 0; i < 100; i++) { documents.add(new BasicDBObject().append("i", i)); } collection.insert(documents); System.out.println( "total # of documents after inserting 100 small ones (should be 101) " + collection.getCount()); // lets get all the documents in the collection and print them out DBCursor cursor = collection.find(); try { while (cursor.hasNext()) { System.out.println(cursor.next()); } } finally { cursor.close(); } // now use a query to get 1 document out cursor = collection.find(new BasicDBObject("i", 71)); try { while (cursor.hasNext()) { System.out.println(cursor.next()); } } finally { cursor.close(); } // now use a range query to get a larger subset cursor = collection.find(new BasicDBObject("i", new BasicDBObject("$gt", 50))); try { while (cursor.hasNext()) { System.out.println(cursor.next()); } } finally { cursor.close(); } // range query with multiple constraints cursor = collection.find(new BasicDBObject("i", new BasicDBObject("$gt", 20).append("$lte", 30))); try { while (cursor.hasNext()) { System.out.println(cursor.next()); } } finally { cursor.close(); } // create an ascending index on the "i" field collection.createIndex(new BasicDBObject("i", 1)); // list the indexes on the collection List<DBObject> list = collection.getIndexInfo(); for (final DBObject o : list) { System.out.println(o); } // release resources mongoClient.close(); }