我有一个JSON,其格式如下:
{
"header": {
"source_code": "S12345"
"user_id": "987456"
},"body":{
"source_code": "S12345","wrapper_list": [
{
"item_wrapper_code": "WRAP01","item_amount": 10,"item_type_amount": 2,"creation_date": 20191115,"worker": "W001","workstation_no": "1"
"item_list":[
{
"item_code": "I001"
"item_id": "","bar_code": "123987456"
"remark": ""
},{
"item_code": "I002"
"item_id": "","bar_code": "213987456"
"remark": ""
}
]
}
]
}
}
上述JSON对象的主体在父子关系中包含数据。
Parent: WRAP01
Child1: Item I001
Child2: Item I002
我必须能够解析此JSON对象,并将这些详细信息作为行插入到相应的表中,即,将与父相关的内容插入到父表中,并将与子相关的内容插入到子表中。
我请这里的专业人员来指导我。