在MongoDB jdbc中使用ObjectID进行搜索

String url = "jdbc:mongodb://localhost:27017/mydatabase";
Connection conn = DriverManager.getConnection(url);

String sql = "SELECT * FROM mycollection WHERE _id = ?";
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setObject(1, new ObjectId("ObjectIdValue"));
ResultSet rs = pstmt.executeQuery();

while (rs.next()) {
    // 处理查询结果
    String id = rs.getString("_id");
    // 其他字段处理...
}