IDEA Maven用Java实现Mongo增删改查
准备Mongo数据库Docker连编部署mongo yml部署创建Mongo数据库use skeduIDEA创建Maven项目new project ------> Maven ------->Create from archetype//选择自动导入org.apache.maven.archetypes:maven-archetype-quicksta
·
准备Mongo数据库
创建Mongo数据库
use skedu
IDEA创建Maven项目
new project ------> Maven ------->Create from archetype
//选择自动导入
org.apache.maven.archetypes:maven-archetype-quickstart
编辑pol.xml
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>mongodb</groupId>
<artifactId>mongodb</artifactId>
<version>1.0-SNAPSHOT</version>
<dependencies>
<dependency>
<groupId>org.mongodb</groupId>
<artifactId>mongo-java-driver</artifactId>
<version>2.10.1</version>
</dependency>
</dependencies>
</project>
右下角弹出窗口 选择自动下载更新包
App.java
package mongotest;
import java.net.UnknownHostException;
import java.util.Date;
import com.mongodb.*;
import com.mongodb.BasicDBObject;
import com.mongodb.DB;
import com.mongodb.DBCollection;
import com.mongodb.DBCursor;
import com.mongodb.MongoClient;
import com.mongodb.MongoException;
/**
* Java + MongoDB Hello world Example
*
*/
public class App {
public static void main(String[] args) {
try {
/**** Connect to MongoDB ****/
// Since 2.10.0, uses MongoClient
MongoClient mongo = new MongoClient("localhost", 16161);
/**** Get database ****/
// if database doesn't exists, MongoDB will create it for you
DB db = mongo.getDB("skedu");
//DBCollection coll = (DBCollection) db.createCollection("student");
/**** Get collection / table from 'testdb' ****/
// if collection doesn't exists, MongoDB will create it for you
DBCollection table = db.getCollection("student");
/**** Insert ****/
// create a document to store key and value
BasicDBObject document = new BasicDBObject();
document.put("sname", "mkyong");
document.put("sage", 18);
document.put("sex", "man");
table.insert(document);
/**** Find and display ****/
BasicDBObject searchQuery = new BasicDBObject();
searchQuery.put("sname", "mkyong");
DBCursor cursor = table.find(searchQuery);
while (cursor.hasNext()) {
System.out.println(cursor.next());
}
/**** Update ****/
// search document where name="mkyong" and update it with new values
BasicDBObject query = new BasicDBObject();
query.put("sname", "mkyong");
BasicDBObject newDocument = new BasicDBObject();
newDocument.put("sname", "mkyong-updated");
BasicDBObject updateObj = new BasicDBObject();
updateObj.put("$set", newDocument);
table.update(query, updateObj);
/**** Find and display ****/
System.out.println("111111111111");
BasicDBObject searchQuery2
= new BasicDBObject().append("sname", "mkyong-updated");
DBCursor cursor2 = table.find(searchQuery2);
while (cursor2.hasNext()) {
System.out.println("111111111111");
System.out.println(cursor2.next());
}
/**** Done ****/
System.out.println("Done");
} catch (UnknownHostException e) {
e.printStackTrace();
} catch (MongoException e) {
e.printStackTrace();
}
}
}
Navicat检查
============================================================
插入多条信息
============================================================
package mongotest;
import java.net.UnknownHostException;
import java.util.Date;
import com.mongodb.*;
import com.mongodb.BasicDBObject;
import com.mongodb.DB;
import com.mongodb.DBCollection;
import com.mongodb.DBCursor;
import com.mongodb.MongoClient;
import com.mongodb.MongoException;
/**
* Java + MongoDB Hello world Example
*
*/
public class App {
public static void main(String[] args) {
try {
/**** Connect to MongoDB ****/
// Since 2.10.0, uses MongoClient
MongoClient mongo = new MongoClient("localhost", 16161);
/**** Get database ****/
// if database doesn't exists, MongoDB will create it for you
DB db = mongo.getDB("skedu");
//DBCollection coll = (DBCollection) db.createCollection("student");
/**** Get collection / table from 'testdb' ****/
// if collection doesn't exists, MongoDB will create it for you
DBCollection table = db.getCollection("book");
/**
* db.books.insertMany([
* {
* bname:"java",
* price:20,
* number:5,
* status:"在售"
*
* },
* {
* bname:"oracle",
* price:30,
* number:5,
* status:"缺货"
* }
* ])
* **/
BasicDBObject document1 = new BasicDBObject();
document1.put("bname", "java");
document1.put("price", 20);
document1.put("number", 5);
document1.put("status", "缺货");
table.insert(document1);
BasicDBObject document2 = new BasicDBObject();
document2.put("bname", "oracle");
document2.put("price", 30);
document2.put("number", 5);
document2.put("status", "缺货");
table.insert(document2);
/**** Insert ****/
// create a document to store key and value
/* BasicDBObject document = new BasicDBObject();
document.put("sname", "mkyong");
document.put("sage", 18);
document.put("sex", "man");
table.insert(document);*/
/**** Find and display ****/
/* BasicDBObject searchQuery = new BasicDBObject();
searchQuery.put("sname", "mkyong");*/
BasicDBObject searchQuery = new BasicDBObject();
searchQuery.put("bname", "java");
DBCursor cursor = table.find(searchQuery);
while (cursor.hasNext()) {
System.out.println(cursor.next());
}
BasicDBObject searchQuery2 = new BasicDBObject();
searchQuery.put("bname", "oracle");
DBCursor cursor2 = table.find(searchQuery);
while (cursor2.hasNext()) {
System.out.println(cursor2.next());
}
/**** Update ****/
// search document where name="mkyong" and update it with new values
BasicDBObject query = new BasicDBObject();
query.put("bname", "oracle");
BasicDBObject newDocument = new BasicDBObject();
newDocument.put("bname", "oracle2");
BasicDBObject updateObj = new BasicDBObject();
updateObj.put("$set", newDocument);
table.update(query, updateObj);
/**** Find and display ****/
BasicDBObject searchQuery9
= new BasicDBObject().append("bname", "oracle2");
DBCursor cursor9 = table.find(searchQuery9);
while (cursor9.hasNext()) {
System.out.println(cursor9.next());
}
/**** Done ****/
System.out.println("Done");
} catch (UnknownHostException e) {
e.printStackTrace();
} catch (MongoException e) {
e.printStackTrace();
}
}
}
更多推荐
已为社区贡献1条内容
所有评论(0)