2024年Go最全MongoDb查询工具类_mongodb sql查询工具类(3)，2024最新Golang面试题目解答

最新推荐文章于 2024-08-29 05:30:00 发布

2401_84910943

最新推荐文章于 2024-08-29 05:30:00 发布

阅读量482

点赞数 8

文章标签： go 学习面试

本文链接：https://blog.csdn.net/2401_84910943/article/details/138877260

版权

网上学习资料一大堆，但如果学到的知识不成体系，遇到问题时只是浅尝辄止，不再深入研究，那么很难做到真正的技术提升。

需要这份系统化的资料的朋友，可以添加戳这里获取

一个人可以走的很快，但一群人才能走的更远！不论你是正从事IT行业的老鸟或是对IT行业感兴趣的新人，都欢迎加入我们的的圈子（技术交流、学习资源、职场吐槽、大厂内推、面试辅导），让我们一起学习成长！

        .getLogger(MongoHelper.class);
@Value("${spring.data.mongodb.database}")
private String DBName;

@Value("${spring.data.mongodb.host}")
private String ServerAddress;

@Value("${spring.data.mongodb.port}")
private int PORT;

public MongoHelper() {
}

public MongoClient getMongoClient() {
    MongoClient mongoClient = null;
    try {
        // 连接到 mongodb 服务
        mongoClient = new MongoClient(ServerAddress, PORT);
        logger.debug("Connect to mongodb successfully");
    } catch (Exception e) {
        System.err.println(e.getClass().getName() + ": " + e.getMessage());
    }
    return mongoClient;
}

public MongoDatabase getMongoDataBase(MongoClient mongoClient) {
    MongoDatabase mongoDataBase = null;
    try {
        if (mongoClient != null) {
            // 连接到数据库
            mongoDataBase = mongoClient.getDatabase(DBName);
            logger.debug("Connect to DataBase successfully");
        } else {
            throw new RuntimeException("MongoClient不能够为空");
        }
    } catch (Exception e) {
        e.printStackTrace();
    }
    return mongoDataBase;
}

public MongoDatabase getMongoDataBase() {
    MongoDatabase mongoDataBase = null;
    try {
        // 连接到数据库
        mongoDataBase = getMongoDataBase(getMongoClient());
    } catch (Exception e) {
        e.printStackTrace();
    }
    return mongoDataBase;
}

public void closeMongoClient(MongoDatabase mongoDataBase,
                             MongoClient mongoClient) {
    if (mongoDataBase != null) {
        mongoDataBase = null;
    }
    if (mongoClient != null) {
        mongoClient.close();
    }
    logger.debug("CloseMongoClient successfully");
}

}


###  b.MongoDb接口

package mongoDB.util;

import java.util.List;

/**

MongoDb工具类
/
public interface IMongoDb{
/*
- 查询条件
- @param field 字段名
- @param value 值
- @return
  */
  IMongoDb whereAnd(String field,String value);
/**
- 模糊查询
- //完全匹配
- Pattern pattern = Pattern.compile(“^name$”, Pattern.CASE_INSENSITIVE);
- ```
//右匹配
```
- Pattern pattern = Pattern.compile(“^.*name$”, Pattern.CASE_INSENSITIVE);
- ```
//左匹配
```
- Pattern pattern = Pattern.compile(“^name.*$”, Pattern.CASE_INSENSITIVE);
- ```
//模糊匹配
```
- Pattern pattern = Pattern.compile(“^.name8.$”, Pattern.CASE_INSENSITIVE);
- @param field 字段
- @param value 值
- @return
  */
  IMongoDb like(String field,String value);
/**
- 执行表名
- @param tableName 表的名字
  */
  List execute(String tableName);

}


### c.MongoDB工具类

package mongoDB.util;

import com.mongodb.BasicDBObject;
import com.mongodb.client.FindIterable;
import com.mongodb.client.MongoCollection;
import com.mongodb.client.MongoCursor;
import com.mongodb.client.MongoDatabase;
import com.smt.interfaces.mongoDB.MongoHelper;
import org.bson.Document;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.ArrayList;
import java.util.List;
import java.util.regex.Pattern;

/**

MongoDB数据库查询工具类
@User myMarksa
@time 2019年5月23日15:28:44

*/
@Service
public class MongoDbDqlUtil implements IMongoDb{

private static final Logger logger = LoggerFactory
        .getLogger(MongoDbDqlUtil.class);

@Autowired
private MongoHelper mongoHelper;

private Pattern queryPattern;

private BasicDBObject basicDBObject ;

{
     basicDBObject = new BasicDBObject();
}

@Override
public IMongoDb whereAnd (String field , String value) {
    basicDBObject.put(field, value);
    return this;
}


@Override
public IMongoDb like (String field , String value) {
    queryPattern = Pattern.compile(value, Pattern.CASE_INSENSITIVE);
    basicDBObject.put(field,queryPattern);
    return this;
}

@Override
public List<String> execute (String tableName) {
    MongoDatabase db=mongoHelper.getMongoDataBase();
    if(null == tableName){
         logger.debug("报出异常,table:{}",tableName);
         return null;
    }
    MongoCollection<Document> collection = db.getCollection(tableName);
    FindIterable<Document> iterable = collection.find(basicDBObject);
    return jsonIrerable(iterable);
}