强力的mongoDB CRUD 操作 DAO

实现了一个用于mongoDB crud的DAO,

运用泛型,对任何对象都能CRUD

hoho~~

 

core code:

package cn.allchin.nosql.mongoDB.dao.impl; import java.util.ArrayList; import java.util.List; import cn.allchin.nosql.mongoDB.objStoneFormat.ObjectAndDBObject; import com.mongodb.BasicDBObject; import com.mongodb.DB; import com.mongodb.DBCollection; import com.mongodb.DBCursor; import com.mongodb.DBObject; /** * <p>Title:MongoDAO</p> * <p>Description: * * * </p> * <p>Copyright: Copyright (c) 2011</p> * @author Allchin * * @version 1.0 $ 2011-6-16 下午09:12:14 * * */ public class BasicCRUDMongoDAO { private DBCollection table=null; public BasicCRUDMongoDAO() { } /** * @param db * @param objOfTable */ public BasicCRUDMongoDAO(DB db,Object objOfTable) { this.table=db.getCollection(objOfTable.getClass().getSimpleName()); } public void save(Object obj)throws Exception{ getTable().insert(ObjectAndDBObject.obj2DBObject(obj)); } public void update(Object obj,Object like)throws Exception{ DBObject target=ObjectAndDBObject.obj2DBObject(obj); DBObject model=ObjectAndDBObject.obj2DBObjectWithoutNull(like); getTable().update(model,target); } public void delete(Object like)throws Exception{ DBObject model=ObjectAndDBObject.obj2DBObjectWithoutNull(like); getTable().remove(model); } /** * @param <T> * @param like * @param pageNo * @param pageSize * @return * @throws Exception */ public <T> List<T> queryPage( T like,int pageNo,int pageSize )throws Exception{ List<T> resultList=new ArrayList<T>(); DBObject queryCnd=ObjectAndDBObject.obj2DBObjectWithoutNull(like); int skip=(pageNo-1)*pageSize; int fetchSize=pageSize; DBCursor cusor= getTable().find(queryCnd,null,skip,fetchSize); while(cusor.hasNext()){ T t=(T)ObjectAndDBObject.dbo2Object(cusor.next(),like.getClass()) ; resultList.add(t); } return resultList; } public DBCollection getTable() { return table; } public void setTable(DBCollection table) { this.table = table; } }

 

辅助类

package cn.allchin.nosql.mongoDB.objStoneFormat; import java.util.LinkedHashMap; import java.util.Map; import cn.allchin.jackson.SimpleWraper; import cn.allchin.jackson.WithoutNullWraper; import cn.allchin.nosql.mongoDB.local.LocalMongo; import cn.allchin.test.pojo.Word; import com.mongodb.BasicDBObject; import com.mongodb.DB; import com.mongodb.DBCollection; import com.mongodb.DBObject; /** * <p>Title:ObjAndJSON</p> * <p>Description: * 在普通对象与DBOBject中转换 * * </p> * <p>Copyright: Copyright (c) 2011</p> * @author Allchin * * @version 1.0 $ 2011-6-16 下午04:03:28 * * */ public class ObjectAndDBObject { public static void main(String[] args) { try { DBObject odb=ObjectAndDBObject.obj2DBObject(Word.getTestWord()); DB db=LocalMongo.getMongo().getDB("test"); DBCollection table=db.getCollection("test"); //保存 table.insert(odb); //查询 DBObject cnd=new BasicDBObject(); cnd.put("id", 2); DBObject twoDBO=table.findOne(cnd); Word three=ObjectAndDBObject.dbo2Object(twoDBO, Word.class); String odbStr=odb.toString(); System.out.println(odbStr); Word word=ObjectAndDBObject.dbo2Object(odb,Word.class); System.out.println(word); } catch (Exception e) { e.printStackTrace(); } } /** 普通对象转DBObject * @param obj * @return * @throws Exception */ public static DBObject obj2DBObject(Object obj)throws Exception{ DBObject dbo=new BasicDBObject(); String jsonStr=SimpleWraper.toJSON(obj); Map map=SimpleWraper.fromJSON(jsonStr, LinkedHashMap.class); dbo.putAll(map); return dbo; } /** 普通对象转DBObject ,去掉为null的成员 * @param obj * @return * @throws Exception * * TODO test */ public static DBObject obj2DBObjectWithoutNull(Object obj)throws Exception{ DBObject dbo=new BasicDBObject(); String jsonStr=WithoutNullWraper.toJSON(obj); Map map=SimpleWraper.fromJSON(jsonStr, LinkedHashMap.class); dbo.putAll(map); return dbo; } /** DBObject 转普通对象 * @param <T> * @param dbo * @return * @throws Exception */ public static <T> T dbo2Object(DBObject dbo,Class<T> clazz)throws Exception{ String jsonStr=dbo.toString(); return SimpleWraper.fromJSON(jsonStr,clazz); } }

 

jackson 简单包装

package cn.allchin.jackson; import org.codehaus.jackson.map.ObjectMapper; import org.codehaus.jackson.map.DeserializationConfig.Feature; import org.codehaus.jackson.map.annotate.JsonSerialize.Inclusion; import cn.allchin.test.pojo.Word; /** * <p>Title:SimpleWraper</p> * <p>Description: * 对jackson简单包装 * * </p> * <p>Copyright: Copyright (c) 2011</p> * @author Allchin * * @version 1.0 $ 2011-6-14 下午04:29:13 * * */ public class SimpleWraper { public static void main(String[] args) { try { Word word=new Word(); word.setChinese("中国"); word.setEnglish("English"); //word.setId(null); System.out.println(SimpleWraper.toJSON(word)); String str="{/"id/":null,/"chinese/":/"中国/",/"english/":/"English/"}"; Word fromStr=null; fromStr=SimpleWraper.fromJSON(str, Word.class); System.out.println("over"); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } private static ObjectMapper mapper=new ObjectMapper(); static{ //所有字段都序列化 mapper.getSerializationConfig().setSerializationInclusion(Inclusion.ALWAYS); //反序列化设这,对于对象不存在的字段,忽略 mapper.getDeserializationConfig().set(Feature.FAIL_ON_UNKNOWN_PROPERTIES, false); } public static String toJSON(Object obj)throws Exception{ return mapper.writeValueAsString(obj); } public static <T> T fromJSON(String jsonStr,Class<T> clazz)throws Exception{ return mapper.readValue(jsonStr, clazz); } }

 

过滤null值得包装

package cn.allchin.jackson; import org.codehaus.jackson.map.ObjectMapper; import org.codehaus.jackson.map.DeserializationConfig.Feature; import org.codehaus.jackson.map.annotate.JsonSerialize.Inclusion; public class WithoutNullWraper { private static ObjectMapper mapper=new ObjectMapper(); static{ //所有字段都序列化 mapper.getSerializationConfig().setSerializationInclusion(Inclusion.NON_NULL); //反序列化设这,对于对象不存在的字段,忽略 mapper.getDeserializationConfig().set(Feature.FAIL_ON_UNKNOWN_PROPERTIES, false); } public static String toJSON(Object obj)throws Exception{ return getMapper().writeValueAsString(obj); } public static <T> T fromJSON(String jsonStr,Class<T> clazz)throws Exception{ return getMapper().readValue(jsonStr, clazz); } public static ObjectMapper getMapper() { return mapper; } public static void setMapper(ObjectMapper mapper) { WithoutNullWraper.mapper = mapper; } }

 

 

我觉得这东西能够成为一个项目,

并且我正在使他成为一个项目,

暂时给他起了个名字

mongoJuice

 

虽然功力有限,但是Just do it !

 

 

不知道国内的哪家opensource svn好一点.

google svn 就算了...