Spring＆MongoCursor＆Jackson JsonNode（数据库转换）(Spring & MongoCursor & Jackson JsonNode (Database conversion))

 我有一个解析从MongoCursor获得的字符串来处理JsonNode的问题。 我试图让MongoCursor返回的Json与我的Spring SQL POJO一起工作，所以我可以将它插入到我的SQL数据库中。 基本上这是一个数据库转换，SQL结束仅用于历史存储。 我没有使用spring的mongo，因为这些字段与POJO有些不同（MongoDB和SQL的模式略有不同） 
 
 目前，它的工作原理是使用模式匹配器/字符串拆分，然后替换HashMap，以便我可以获得每个字段的键和值对，然后将其插入到我的弹簧POJO中。 我知道我也可以使用杰克逊的POJO工作，但被告知使用jsonNode作为更好的解决方案。 必须有一些我错过了。 
 
 在Jackson文档中，“json”字符串的格式是： 
 
 
 
 {\“color \”：\“Black \”，\“type \”：\“BMW \”} 
 
 
 然而，MongoCursor回报我的情况并非如此。 用光标，我得到如下所示： 
 
 
 
 文档{{_ id = G8HQW9123，用户=测试}} 
 
 
 其中我使用了字符串模式匹配器并将replaceAll简化为： 
 
 
 
 {_id：G8G8HQW9123，用户：测试} 
 
 
 然而，杰克逊的斜杠和双引号让我失望，无法解析。 我错过了什么吗？ 或者我必须在我的代码中实际添加斜线和引号才能使其工作？ 目前正在获取请求双引号的分析错误。 

I have a problem parsing a String I got from MongoCursor to work with JsonNode. I'm trying to get the MongoCursor's returned Json to work with my Spring SQL POJO, so I can insert it to my SQL database. Basically this is a database conversion, and SQL end is just for history storage. I didn't use spring's mongo, because the fields are somewhat different than the POJO's.(MongoDB and SQL have slightly different schema)
 
Currently, it works by using pattern matcher/ string split and replace then HashMap them so I can get a key and value pair of each field and then insert that into my spring POJO. I know I can also use jackson's POJO to work, but was told to use jsonNode as a better solution. There must be something i'm missing.
 
In the Jackson docs, the format of a "json" string is: 
 
 
 
{ \"color\" : \"Black\", \"type\" : \"BMW\" }
 
 
However, that is not going to be the case of what MongoCursor returns me with. With the cursor, I get something like:
 
 
 
Document{{_id=G8HQW9123, User=test}}
 
 
which I used string pattern matcher and replaceAll to reduce to:
 
 
 
{_id:G8G8HQW9123, User:test} 
 
 
However, jackson's slashes and double quotes are throwing me off and unable to parse that. Am I missing something? or do I have to actually add in those slashes & quotes in my code to make things work? Currently getting parse error which requests double quotes. 

原文：https://stackoverflow.com/questions/43564646