java操作Mongo
工具类:
import com.mongodb.DB;
import com.mongodb.DBCollection;
import com.mongodb.MongoClient;
public class MongoDBUtil {
private static MongoClient mongo;
private static DB db;
static{
//1,建立链接
try {
mongo = new MongoClient("localhost", 27017);
//2,得到数据库对象
db = mongo.getDB("tj");
} catch (UnknownHostException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
//得到表对象:文档对象
public static DBCollection getDBCollection(String tableName){
return db.getCollection(tableName);
}
//关闭
public static void closeDB(){
if(mongo!=null){
mongo.close();
}
}
}
add:
批量添加可以提高性能
//批量添加性能更优
public void addGbls(){
DBCollection dbCollection = MongoDBUtil.getDBCollection("gbl");
List<DBObject> list = new ArrayList<DBObject>();
DBObject jo = new BasicDBObject();
jo.put("chihuo", "包子2");
jo.put("tjdesc", "包子也是很白的2");
jo.put("baifumei", "包子比我白2");
list.add(jo);
DBObject jo2 = new BasicDBObject();
jo2.put("chihuo", "222");
jo2.put("tjdesc", "8.22");
jo2.put("baifumei", "2222");
list.add(jo2);
dbCollection.insert(list);
}
delete:
//删除
public void delGbl(String id){
DBCollection dbCollection = MongoDBUtil.getDBCollection("gbl");
DBObject o = new BasicDBObject("_id", new ObjectId(id));
dbCollection.remove(o);
}
update:
//修改
public void updateGbl(String id,String baifumei){
DBCollection dbCollection = MongoDBUtil.getDBCollection("gbl");
DBObject q=new BasicDBObject("_id", new ObjectId(id));
DBObject o=new BasicDBObject();//需要修改的内容,但是需要加$set,回忆:{$set:{key:value}}:json嵌套
o.put("$set", new BasicDBObject("baifumei",baifumei ));//需要把目标的 Object变成 JSON
dbCollection.update(q, o);
}
注意:JSON嵌套
find:
按照主键查找某条记录:
public void findByID(String id){
DBCollection dbCollection = MongoDBUtil.getDBCollection("gbl");
DBObject ref = new BasicDBObject("_id", new ObjectId(id));
DBCursor dbCursor = dbCollection.find(ref);
while(dbCursor.hasNext()){//判断是否有记录
BasicDBObject data = (BasicDBObject)dbCursor.next();
ObjectId objectId = data.getObjectId("_id");
System.out.println(objectId.toString());
String chihuo = data.getString("chihuo");
String tjdesc = data.getString("tjdesc");
String baifumei = data.getString("baifumei");
System.out.println(chihuo+"\t"+tjdesc+"\t"+baifumei);
}
}
//查询所有
public void findALL(){
DBCollection dbCollection = MongoDBUtil.getDBCollection("gbl");
DBCursor dbCursor = dbCollection.find();//不给条件就是查询所有
while(dbCursor.hasNext()){//判断是否有记录
BasicDBObject data = (BasicDBObject)dbCursor.next();
ObjectId objectId = data.getObjectId("_id");
String chihuo = data.getString("chihuo");
String tjdesc = data.getString("tjdesc");
String baifumei = data.getString("baifumei");
System.out.println(objectId.toString()+"\t"+chihuo+"\t"+tjdesc+"\t"+baifumei);
}
}
模糊查询:
//模糊查询
public void findByLike(String tjdesc){
DBCollection dbCollection = MongoDBUtil.getDBCollection("gbl");
DBObject ref = new BasicDBObject();
//模糊条件Object
Pattern pattern = Pattern.compile("^.*"+tjdesc+".*$");
ref.put("tjdesc", pattern);
DBCursor find = dbCollection.find(ref);
while(find.hasNext()){
BasicDBObject data = (BasicDBObject)find.next();
ObjectId objectId = data.getObjectId("_id");
String chihuo = data.getString("chihuo");
String tj = data.getString("tjdesc");
String baifumei = data.getString("baifumei");
System.out.println(objectId.toString()+"\t"+chihuo+"\t"+tj+"\t"+baifumei);
}
}
分页查询:
//分页
public void findByPage(int start,int size){
DBCollection dbCollection = MongoDBUtil.getDBCollection("gbl");
DBCursor limit = dbCollection.find().skip(start).limit(size);
while(limit.hasNext()){
BasicDBObject data = (BasicDBObject)limit.next();
ObjectId objectId = data.getObjectId("_id");
String chihuo = data.getString("chihuo");
String tj = data.getString("tjdesc");
String baifumei = data.getString("baifumei");
System.out.println(objectId.toString()+"\t"+chihuo+"\t"+tj+"\t"+baifumei);
}
}
对数据做封装到POJO:
实体对象JavaBean:
public void addGbl(GblPOJO pojo){//注意:POJO需要转化成BasicDBObject对象才能呢存入数据库
try {
//1,建立链接
MongoClient mongo = new MongoClient("localhost", 27017);
//2,得到数据库对象
DB db = mongo.getDB("tj");
//3,得到表对象
DBCollection collection = db.getCollection("gbl");
//4,操作数据
DBObject jo = new BasicDBObject();
jo.put("chihuo", pojo.getChihuo());
jo.put("tjdesc", pojo.getTjdesc());
jo.put("baifumei", pojo.getBaifumei());
collection.save(jo);
//5,关闭
mongo.close();
} catch (UnknownHostException e) {
e.printStackTrace();
}
}
//批量添加性能更优
public void addGbls(List<GblPOJO> pojos){
DBCollection dbCollection = MongoDBUtil.getDBCollection("gbl");
List<DBObject> list = new ArrayList<DBObject>();
for (GblPOJO pojo : pojos) {
DBObject jo = new BasicDBObject();
jo.put("chihuo", pojo.getChihuo());
jo.put("tjdesc", pojo.getTjdesc());
jo.put("baifumei", pojo.getBaifumei());
list.add(jo);
}
dbCollection.insert(list);
}
工具类:
import com.mongodb.DB;
import com.mongodb.DBCollection;
import com.mongodb.MongoClient;
public class MongoDBUtil {
private static MongoClient mongo;
private static DB db;
static{
//1,建立链接
try {
mongo = new MongoClient("localhost", 27017);
//2,得到数据库对象
db = mongo.getDB("tj");
} catch (UnknownHostException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
//得到表对象:文档对象
public static DBCollection getDBCollection(String tableName){
return db.getCollection(tableName);
}
//关闭
public static void closeDB(){
if(mongo!=null){
mongo.close();
}
}
}
add:
批量添加可以提高性能
//批量添加性能更优
public void addGbls(){
DBCollection dbCollection = MongoDBUtil.getDBCollection("gbl");
List<DBObject> list = new ArrayList<DBObject>();
DBObject jo = new BasicDBObject();
jo.put("chihuo", "包子2");
jo.put("tjdesc", "包子也是很白的2");
jo.put("baifumei", "包子比我白2");
list.add(jo);
DBObject jo2 = new BasicDBObject();
jo2.put("chihuo", "222");
jo2.put("tjdesc", "8.22");
jo2.put("baifumei", "2222");
list.add(jo2);
dbCollection.insert(list);
}
delete:
//删除
public void delGbl(String id){
DBCollection dbCollection = MongoDBUtil.getDBCollection("gbl");
DBObject o = new BasicDBObject("_id", new ObjectId(id));
dbCollection.remove(o);
}
update:
//修改
public void updateGbl(String id,String baifumei){
DBCollection dbCollection = MongoDBUtil.getDBCollection("gbl");
DBObject q=new BasicDBObject("_id", new ObjectId(id));
DBObject o=new BasicDBObject();//需要修改的内容,但是需要加$set,回忆:{$set:{key:value}}:json嵌套
o.put("$set", new BasicDBObject("baifumei",baifumei ));//需要把目标的 Object变成 JSON
dbCollection.update(q, o);
}
注意:JSON嵌套
find:
按照主键查找某条记录:
public void findByID(String id){
DBCollection dbCollection = MongoDBUtil.getDBCollection("gbl");
DBObject ref = new BasicDBObject("_id", new ObjectId(id));
DBCursor dbCursor = dbCollection.find(ref);
while(dbCursor.hasNext()){//判断是否有记录
BasicDBObject data = (BasicDBObject)dbCursor.next();
ObjectId objectId = data.getObjectId("_id");
System.out.println(objectId.toString());
String chihuo = data.getString("chihuo");
String tjdesc = data.getString("tjdesc");
String baifumei = data.getString("baifumei");
System.out.println(chihuo+"\t"+tjdesc+"\t"+baifumei);
}
}
//查询所有
public void findALL(){
DBCollection dbCollection = MongoDBUtil.getDBCollection("gbl");
DBCursor dbCursor = dbCollection.find();//不给条件就是查询所有
while(dbCursor.hasNext()){//判断是否有记录
BasicDBObject data = (BasicDBObject)dbCursor.next();
ObjectId objectId = data.getObjectId("_id");
String chihuo = data.getString("chihuo");
String tjdesc = data.getString("tjdesc");
String baifumei = data.getString("baifumei");
System.out.println(objectId.toString()+"\t"+chihuo+"\t"+tjdesc+"\t"+baifumei);
}
}
模糊查询:
//模糊查询
public void findByLike(String tjdesc){
DBCollection dbCollection = MongoDBUtil.getDBCollection("gbl");
DBObject ref = new BasicDBObject();
//模糊条件Object
Pattern pattern = Pattern.compile("^.*"+tjdesc+".*$");
ref.put("tjdesc", pattern);
DBCursor find = dbCollection.find(ref);
while(find.hasNext()){
BasicDBObject data = (BasicDBObject)find.next();
ObjectId objectId = data.getObjectId("_id");
String chihuo = data.getString("chihuo");
String tj = data.getString("tjdesc");
String baifumei = data.getString("baifumei");
System.out.println(objectId.toString()+"\t"+chihuo+"\t"+tj+"\t"+baifumei);
}
}
分页查询:
//分页
public void findByPage(int start,int size){
DBCollection dbCollection = MongoDBUtil.getDBCollection("gbl");
DBCursor limit = dbCollection.find().skip(start).limit(size);
while(limit.hasNext()){
BasicDBObject data = (BasicDBObject)limit.next();
ObjectId objectId = data.getObjectId("_id");
String chihuo = data.getString("chihuo");
String tj = data.getString("tjdesc");
String baifumei = data.getString("baifumei");
System.out.println(objectId.toString()+"\t"+chihuo+"\t"+tj+"\t"+baifumei);
}
}
对数据做封装到POJO:
实体对象JavaBean:
public void addGbl(GblPOJO pojo){//注意:POJO需要转化成BasicDBObject对象才能呢存入数据库
try {
//1,建立链接
MongoClient mongo = new MongoClient("localhost", 27017);
//2,得到数据库对象
DB db = mongo.getDB("tj");
//3,得到表对象
DBCollection collection = db.getCollection("gbl");
//4,操作数据
DBObject jo = new BasicDBObject();
jo.put("chihuo", pojo.getChihuo());
jo.put("tjdesc", pojo.getTjdesc());
jo.put("baifumei", pojo.getBaifumei());
collection.save(jo);
//5,关闭
mongo.close();
} catch (UnknownHostException e) {
e.printStackTrace();
}
}
//批量添加性能更优
public void addGbls(List<GblPOJO> pojos){
DBCollection dbCollection = MongoDBUtil.getDBCollection("gbl");
List<DBObject> list = new ArrayList<DBObject>();
for (GblPOJO pojo : pojos) {
DBObject jo = new BasicDBObject();
jo.put("chihuo", pojo.getChihuo());
jo.put("tjdesc", pojo.getTjdesc());
jo.put("baifumei", pojo.getBaifumei());
list.add(jo);
}
dbCollection.insert(list);
}