java对所有mongodb表进行增删改查表名怎么设置

java对所有mongodb表进行增删改查表名怎么设置,第1张

一、MongoDB数据库参数配置

1、推荐使用mongodbcfgproperties配置,则在构造MongoDBService对象的时候只需调用无参构造方法即可自动完成配置。

2、如果没有通过mongodbcfgproperties,会采用程序指定的默认配置。

// 定义默认配置,1、IP地址 2、端口号 3、用户名 4、密码 5、配置文件位置名 6、数据库名    private static final String MONGODB_ADDRESS = "127001";    private static final int MONGODB_PORT = 27017;    private static final String MONGODB_USERNAME = "root";    private static final String MONGODB_PASSWORD = "";    private static final String MONGODB_RESOURCE_FILE = "mongodbcfgproperties";    private static final String MONGODB_DBNAME = "test";    private static final String MONGODB_COLLECTIONNAME = "test";

3、通过有参构造方法构造MongoDBService对象或通过get/set方法,指定数据库及集合,优先级最高。

//有参构造方法,指定数据库名与集合名    public MongoDBServiceImpl(String dbName, String collName) {        thisdbName = dbName;        thiscollName = collName;        try {            db = getDb();        } catch (Throwable e) {            eprintStackTrace();        }    }    //无参构造方法,返回配置文件配置的数据库对象引用,如果配置文件中没有设置则返回默认数据库对象引用    public MongoDBServiceImpl() {        getDb();    }    /      获取数据库对象,3种情况(优先级从高到低):<span style="white-space: pre"> </span> 1、构造方法指定2、配置文件指定3、默认数据库<span style="white-space: pre"> </span> (情况2、3在MongoDButil中设置)     /    public DB getDb() {        if (thisdb == null) {            if (thisdbName == null) {                thisdb = MongoDBUtilgetDB();            } else {                thisdb = MongoDBUtilgetDBByName(thisdbName);            }        }        return thisdb;    }         /      获取集合对象,3种情况(优先级从高到低):         1、构造方法指定2、配置文件指定3、默认数据库     (情况2、3在MongoDButil中设置)     /    public DBCollection getCollection() {        if(thiscollName != null){            return dbgetCollection(thiscollName);        }        else {            return MongoDBUtilgetDBCollection();        }    }

二、方法简介(具体实现参看MongoDBServiceImpl接口实现类)

1、获取基本信息或对象:

(1)、获取数据库名: getDbName()

(2)、设置数据库名(指定数据库): setDbName(String dbName)

(3)、获取集合名: getCollName()

(4)、设置集合名(指定集合): setCollName(String collName)

(5)、获取数据库对象: getDb()

2、数据插入方式:

(1)、插入单条数据: insert(DBObject obj)

(2)、插入多条数据: insertBatch(List list)void

3、数据删除方式:

(1)、删除单条数据: delete(DBObject obj)

(2)、删除多条数据: deleteBatch(List list)

4、数量统计方式:

(1)、获取集合中数据数量: getCollectionCount()

(2)、获取符合条件的数据数量: getCount(DBObject obj)

5、查找数据:

(1)、查找所有数据: findAll()

(2)、查找符合条件的数据: find(DBObject obj)

(3)、查找符合条件的数据并排序: find(DBObject query, DBObject sort)

(4)、查找符合条件的指定数量的数据并排序:find(DBObject query, DBObject sort, int start, int limit)

(5)、由ID查找数据: getById(String id)

6、更新数据 :update(DBObject setFields, DBObject whereFields) void

7、打印List: printListDBObj(List list)

测试代码:(@Test)

public class testMongoService {    //使用mongodbcfgproperties中配置的数据库与集合,如未指定,使用MongoDBUtil中默认的数据库与集合    MongoDBService mongoDBService1 = new MongoDBServiceImpl();         //测试插入数据    @Test    public void testInsert(){        //数据一,包括用户名、密码,地址信息(省份、城市),爱好[…]        BasicDBList dbList1 = new BasicDBList();        dbList1add("basketball");        dbList1add("music");        dbList1add("web");        DBObject dbObject1 = new BasicDBObject("username","insert1")            append("age", 18)            append("address", new BasicDBObject("province","广东")append("city", "广州"))            append("favourite", dbList1);        //数据二        BasicDBList dbList2 = new BasicDBList();        dbList2add("football");        dbList2add("music");        DBObject dbObject2 = new BasicDBObject("username","insert2")            append("age", 18)            append("address", new BasicDBObject("province","陕西")append("city", "西安"))            append("favourite", dbList2);        //数据三        BasicDBList dbList3 = new BasicDBList();        dbList3add("Linux");        DBObject dbObject3 = new BasicDBObject("username","insert3")            append("age", 18)            append("address", new BasicDBObject("province","河北")append("city", "保定"))            append("favourite", dbList3);        //数据四        BasicDBList dbList4 = new BasicDBList();        dbList4add("swim");        dbList4add("android");        DBObject dbObject4 = new BasicDBObject("username","insert4")            append("age", 18)            append("address", new BasicDBObject("province","四川")append("city", "成都"))            append("favourite", dbList4);        //数据五        DBObject dbObject5 = new BasicDBObject("username", "insert5")            append("age", 28)            append("address", new BasicDBObject("city", "杭州"));        mongoDBService1printListDBObj(mongoDBService1findAll());        Systemoutprintln("——————————————————insert collection——————————————————");        List<dbobject> list = new ArrayList<dbobject>();        listadd(dbObject1);        listadd(dbObject2);        listadd(dbObject3);        listadd(dbObject5);        mongoDBService1insertBatch(list);        Systemoutprintln("——————————————————insert one——————————————————");        mongoDBService1insert(dbObject4);        mongoDBService1printListDBObj(mongoDBService1findAll());    }         //测试查询数据    @Test    public void testFind(){        DBObject dbObject = new BasicDBObject("username","insert1");        Systemoutprintln("数量:" + mongoDBService1getCollectionCount());        Systemoutprintln("username=java的数据数量:" + mongoDBService1getCount(dbObject));        Systemoutprintln("——————————————————find all——————————————————");        mongoDBService1printListDBObj(mongoDBService1findAll());        Systemoutprintln("——————————————————find obj——————————————————");        mongoDBService1printListDBObj(mongoDBService1find(dbObject));        Systemoutprintln("——————————————————find sort——————————————————");        mongoDBService1printListDBObj(mongoDBService1find(new BasicDBObject(), new BasicDBObject("age", 1)));        Systemoutprintln("——————————————————find sort limit——————————————————");        mongoDBService1printListDBObj(mongoDBService1find(new BasicDBObject(), new BasicDBObject("age", 1), 1, 2));    }     //测试数据更新    @Test    public void testUpdate(){        BasicDBObject newDocument = new BasicDBObject("$set",new BasicDBObject("age",11));                         BasicDBObject searchQuery = new BasicDBObject()append("username", "insert2");             mongoDBService1printListDBObj(mongoDBService1find(searchQuery));        Systemoutprintln("——————————————————update——————————————————");        mongoDBService1update(newDocument, searchQuery);        mongoDBService1printListDBObj(mongoDBService1find(searchQuery));    }         //测试数据删除    @Test    public void testDelete(){        DBObject dbObject1 = new BasicDBObject("username", "insert1");        DBObject dbObject2 = new BasicDBObject("username", "insert2");        DBObject dbObject3 = new BasicDBObject("username", "insert3");        DBObject dbObject4 = new BasicDBObject("username", "insert4");        DBObject dbObject5 = new BasicDBObject("username", "insert5");        List<dbobject> list = new ArrayList<dbobject>();        listadd(dbObject1);        listadd(dbObject2);        listadd(dbObject3);        listadd(dbObject4);        mongoDBService1printListDBObj(mongoDBService1findAll());        Systemoutprintln("——————————————————delete list——————————————————");        mongoDBService1deleteBatch(list);        Systemoutprintln("——————————————————delete one——————————————————");        mongoDBService1delete(dbObject5);        //Systemoutprintln("——————————————————delete all——————————————————");        //mongoDBService1delete(new BasicDBObject());        mongoDBService1printListDBObj(mongoDBService1findAll());    }}</dbobject></dbobject></dbobject></dbobject>

测试结果:

源代码:(完整项目文件下载链接:点击打开链接)

MongoDBServiceImpljava

public class MongoDBServiceImpl implements MongoDBService {    private String dbName;    private String collName;    private DB db;         //有参构造方法,指定数据库名与集合名    public MongoDBServiceImpl(String dbName, String collName) {        thisdbName = dbName;        thiscollName = collName;        try {            db = getDb();        } catch (Throwable e) {            eprintStackTrace();        }    }    //无参构造方法,返回配置文件配置的数据库对象引用,如果配置文件中没有设置则返回默认数据库对象引用    public MongoDBServiceImpl() {        getDb();    }    /      获取数据库对象,3种情况(优先级从高到低):     1、构造方法指定2、配置文件指定3、默认数据库     (情况2、3在MongoDButil中设置)     /    public DB getDb() {        if (thisdb == null) {            if (thisdbName == null) {                thisdb = MongoDBUtilgetDB();            } else {                thisdb = MongoDBUtilgetDBByName(thisdbName);            }        }        return thisdb;    }         /      获取集合对象,3种情况(优先级从高到低):     1、构造方法指定2、配置文件指定3、默认数据库     (情况2、3在MongoDButil中设置)     /    public DBCollection getCollection() {        if(thiscollName != null){            return dbgetCollection(thiscollName);        }        else {            return MongoDBUtilgetDBCollection();        }    }     public DBObject map2Obj(Map<string, object=""> map) {        DBObject obj = new BasicDBObject();        if (mapcontainsKey("class") && mapget("class") instanceof Class)            mapremove("class");        objputAll(map);        return obj;    }    //插入数据    public void insert(DBObject obj) {        getCollection()insert(obj);    }    //插入多条数据    public void insertBatch(List<dbobject> list) {        if (list == null || listisEmpty()) {            return;        }        List<dbobject> listDB = new ArrayList<dbobject>();        for (int i = 0; i < listsize(); i++) {            listDBadd(listget(i));        }        getCollection()insert(listDB);    }    //删除数据    public void delete(DBObject obj) {        getCollection()remove(obj);    }    //删除多条数据    public void deleteBatch(List<dbobject> list) {        if (list == null || listisEmpty()) {            return;        }        for (int i = 0; i < listsize(); i++) {            getCollection()remove(listget(i));        }    }    //获取集合中的数据数量    public long getCollectionCount() {        return getCollection()getCount();    }    //查找符合条件的数据数量    public long getCount(DBObject obj) {        if (obj != null)            return getCollection()getCount(obj);        return getCollectionCount();    }    //查找符合条件的数据    public List<dbobject> find(DBObject obj) {        DBCursor cur = getCollection()find(obj);        return DBCursor2list(cur);    }         //查找符合条件的数据并排序    @Override    public List<dbobject> find(DBObject query, DBObject sort) {        DBCursor cur;        if (query != null) {            cur = getCollection()find(query);        } else {            cur = getCollection()find();        }        if (sort != null) {            cursort(sort);        }        return DBCursor2list(cur);    }     //查找符合条件的数据并排序,规定数据个数    @Override    public List<dbobject> find(DBObject query, DBObject sort, int start,            int limit) {        DBCursor cur;        if (query != null) {            cur = getCollection()find(query);        } else {            cur = getCollection()find();        }        if (sort != null) {            cursort(sort);        }        if (start == 0) {            curbatchSize(limit);        } else {            curskip(start)limit(limit);        }        return DBCursor2list(cur);    }         //将DBCursor转化为list<dbobject>    private List<dbobject> DBCursor2list(DBCursor cur) {        List<dbobject> list = new ArrayList<dbobject>();        if (cur != null) {            list = curtoArray();        }        return list;    }     //更新数据    public void update(DBObject setFields, DBObject whereFields) {        getCollection()updateMulti(whereFields, setFields);    }    //查询集合中所有数据    public List<dbobject> findAll() {        DBCursor cur = getCollection()find();        List<dbobject> list = new ArrayList<dbobject>();        if (cur != null) {            list = curtoArray();        }        return list;    }     //由ID获取数据    public DBObject getById(String id) {        DBObject obj = new BasicDBObject();        objput("_id", new ObjectId(id));        DBObject result = getCollection()findOne(obj);        return result;    }     public String getDbName() {        return dbName;    }     public void setDbName(String dbName) {        thisdbName = dbName;        thisdb = MongoDBUtilgetDBByName(thisdbName);    }     public String getCollName() {        return collName;    }     public void setCollName(String collName) {        thiscollName = collName;    }    @Override    public void printListDBObj(List<dbobject> list) {        // TODO Auto-generated method stub        for(DBObject dbObject: list){            Systemoutprintln(dbObject);        }    }       }</dbobject></dbobject></dbobject></dbobject></dbobject></dbobject></dbobject></dbobject></dbobject></dbobject></dbobject></dbobject></dbobject></dbobject></dbobject></string,>

MongoDBUtiljava

public class MongoDBUtil {    // 定义默认配置,1、IP地址 2、端口号 3、用户名 4、密码 5、配置文件位置名 6、数据库名    private static final String MONGODB_ADDRESS = "127001";    private static final int MONGODB_PORT = 27017;    private static final String MONGODB_USERNAME = "root";    private static final String MONGODB_PASSWORD = "";    private static final String MONGODB_RESOURCE_FILE = "mongodbcfgproperties";    private static final String MONGODB_DBNAME = "test";    private static final String MONGODB_COLLECTIONNAME = "test";    // 定义静态变量,1、Mongo对象(代表数据库连接)2、DB对象(代表数据库)3、集合名4、数据库相关配置映射集合5、已获取的数据库连接    private static Mongo mongo;    private static DB db;    private static DBCollection collection;    private static Map<string, string=""> cfgMap = new HashMap<string, string="">();    private static Hashtable<string, db=""> mongoDBs = new Hashtable<string, db="">();     /      初始化Mongo的数据库     /    static {        init();    }     /      获取配置文件中配置的DB对象     /    public static DB getDB() {        return db;    }     /      获取配置文件中配置的DBCollection对象     /    public static DBCollection getDBCollection() {        return collection;    }     /      根据数据库名称,得到数据库 如果不存在,则创建一个该名称的数据库,并设置用户名和密码为配置文件中的参数值           @param dbName      @return DB     /    @SuppressWarnings("deprecation")    public static DB getDBByName(String dbName) {        DB db = mongogetDB(dbName);        if (!mongoDBscontains(db)) {            Systemoutprintln("add");            dbaddUser(cfgMapget("mongodbusername"),                    cfgMapget("mongodbpassword")toCharArray());            mongoDBsput(dbName, db);        }        return db;    }     // ————————————————————————————————————初始化过程————————————————————————————————————    /      获取配置文件mongedbcfgproperties的文件对象     /    public static File getConfigFile() {        String path = MongoDBUtilclassgetResource("/")getPath();        String fileName = path + MONGODB_RESOURCE_FILE;        Systemoutprintln(fileName);        File file = new File(fileName);        if (fileexists()) {            return file;        }        return null;    }     /      通过mongedbcfgproperties配置文件初始化配置映射集合,如果没有编写配置文件,则加载程序指定的默认配置     /    @SuppressWarnings("unchecked")    private static void initCfgMap() {        File file = getConfigFile();        if (file != null) {            Properties p = new Properties();            try {                pload(new FileInputStream(file));                for (Enumeration enu = ppropertyNames(); enuhasMoreElements();) {                    String key = (String) enunextElement();                    String value = (String) pgetProperty(key);                    cfgMapput(key, value);                }            } catch (IOException e) {                Systemoutprintln("加载Mongo配置文件失败!");                eprintStackTrace();            }        } else { // 如果没有编写配置文件,则加载默认配置            cfgMapput("mongodbaddress", MONGODB_ADDRESS);            cfgMapput("mongodbport", StringvalueOf(MONGODB_PORT));            cfgMapput("mongodbusername", MONGODB_USERNAME);            cfgMapput("mongodbpassword", MONGODB_PASSWORD);            cfgMapput("mongodbdbname", MONGODB_DBNAME);            cfgMapput("mongodbcollectionname", MONGODB_COLLECTIONNAME);        }    }     /      初始化Mongo的数据库(将db指向相应对象引用,将collection指向相应对象引用,通过mongoDBs记录现有数据库对象)     /    @SuppressWarnings("deprecation")    private static void init() {        initCfgMap();        try {            String address = cfgMapget("mongodbaddress");            int port = IntegerparseInt(cfgMapget("mongodbport")toString());            String dbName = cfgMapget("mongodbdbname");            String username = cfgMapget("mongodbusername");            String password = cfgMapget("mongodbpassword");            String collectionName = cfgMapget("mongodbcollectionname");            mongo = new Mongo(address, port);            if (dbName != null && !""equals(dbName)) {                db = mongogetDB(dbName);                if (username != null && !""equals(username)) {                    dbaddUser(username, passwordtoCharArray());                    if (collectionName != null && !""equals(collectionName)) {                        collection = dbgetCollection(collectionName);                    }                }                mongoDBsput(dbName, db);            }        } catch (Exception e) {            eprintStackTrace();        }    } }

MongoDB创建表步骤,Mongo常用的数据库 *** 作命令,查询,添加,更新,删除_MongoDB 性能监测。

use Admin (切换到创建用户)

dbTestDb (创建数据库)

dbaddUser(“userName”,”Pwd”) 创建用户

dbauth(“userName”,”Pwd”) 设置用户为允许连接的用户

dbcreateCollection(“TableName”) 创建表

showcollections 查看表是否创建成功

dbTableNameSave({age:1}) 添加数据

dbTableNamefind() 查看添加的数据是否成功(如果没有查询到任何的结果,说明添加失败)

推荐学习《python教程》。

以上就是关于java对所有mongodb表进行增删改查表名怎么设置全部的内容,包括:java对所有mongodb表进行增删改查表名怎么设置、mongodb数据库如何建表、等相关内容解答,如果想了解更多相关内容,可以关注我们,你们的支持是我们更新的动力!

欢迎分享,转载请注明来源:内存溢出

原文地址: http://outofmemory.cn/sjk/9453141.html

(0)
打赏 微信扫一扫 微信扫一扫 支付宝扫一扫 支付宝扫一扫
上一篇 2023-04-28
下一篇 2023-04-28

发表评论

登录后才能评论

评论列表(0条)

保存