mongodb的ID为String类型查询时的问题

Question

mongodb的ID为String（"102a1ds0as",不是正常的数字）类型，注意不是ObjectId,在用mongoTemplate.findAll(）查询时虽然ID的字符串是一模一样，但只要mongodb的ID为string类型就是查询不出来，ObjectId类型的都可以，请问怎么处理

Answer 1

你可以试试我这样的方法查询

  public static void main(String[] args) {
        //1. 连接到mongodb服务
        MongoClient mongoClient = new MongoClient("localhost", 27017);

        //2. 连接数据库，你需要指定数据库名称，如果指定的数据库不存在，mongo会自动创建数据库
        MongoDatabase db = mongoClient.getDatabase("primton");//database
        System.out.println("MongoDB连接成功");

        //3. 获得集合users
        MongoCollection<Document> collection = db.getCollection("users");//table


        //5. 添加查询条件
        Document find = new Document("sex", "男");


        //4. 遍历集合users
        FindIterable<Document> documents = collection.find(find);//rows
        MongoCursor<Document> mongoCursor = documents.iterator();
        while (mongoCursor.hasNext()) {
            Document document = mongoCursor.next();
            System.out.print(document.get("_id"));
            System.out.print("," + document.get("userName"));
            System.out.print("," + document.get("userPwd"));
            System.out.print("," + document.get("sex"));
            System.out.print("," + document.get("remark"));
            System.out.print("," + document.get("age"));
            System.out.println("22222222222222");
        }
        System.out.println("ok");

    }