json解析

struggle@徐磊 2020-05-10 10:51:59

{
"ordersInfoList": [{
"planInfoList": [{
"stagePlanNo": "BT202002240000180600",
"exceedStatus": "M1"
}, {
"stagePlanNo": "BT202002240000180601",
"exceedStatus": "M0"
}, {
"stagePlanNo": "BT202002240000180602",
"exceedStatus": "M0"
}],
"accountNo": "01316150417801",
"bank": "CITICCFC"
}]
}

怎么用hql解析成两个表

...全文