我有一个要求,在我有一个复杂的数据库查询中返回某些结果集的地方。我必须将结果映射到POJO。如何使用优化的代码实现这一目标?最后,我必须解析pojo来创建一个json(json模式粘贴在下面)。
查询结果集示例(以竖线分隔):
object_id | object_name | object_owner | object_type | status | parent_id | last_modified_timestamp 123_S1 | ABC_S1 | XYZ_S1 |模式|有效|无| 2019-11-09_20:40:11 123_S1T1 | ABC_S1T1 | XYZ_S1T1 |表格|有效| 123_S1 | 2019-11-09_20:40:11 123_S1T1C1 | ABC_S1T1C1 | XYZ_S1T1C1 |列|有效| 123_S1T1 | 2019-11-09_20:40:11 123_S1T1C2 | ABC_S1T1C2 | XYZ_S1T1C2 |列|有效| 123_S1T1 | 2019-11-09_20:40:11 123_S1T1C3 | ABC_S1T1C3 | XYZ_S1T1C3 |列|有效| 123_S1T1 | 2019-11-09_20:40:11 123_S1T2 | ABC_S1T2 | XYZ_S1T2 |表格|有效| 123_S1 | 2019-11-09_20:40:11 123_S1T2C1 | ABC_S1T2C1 | XYZ_S1T2C1 |列|有效| 123_S1T2 | 2019-11-09_20:40:11 123_S1T2C2 | ABC_S1T2C2 | XYZ_S1T2C2 |列|有效| 123_S1T2 | 2019-11-09_20:40:11 123_S1T2C3 | ABC_S1T2C3 | XYZ_S1T2C3 |列|有效| 123_S1T2 | 2019-11-09_20:40:11 123_S1V1 | ABC_S1V1 | XYZ_S1V1 |视图|有效| 123_S1 | 2019-11-09_20:40:11 123_S1V1C1 | ABC_S1V1C1 | XYZ_S1V1C1 |列|有效| 123_S1V1 | 2019-11-09_20:40:11 123_S1V1C2 | ABC_S1V1C2 | XYZ_S1V1C2 |列|有效| 123_S1V1 | 2019-11-09_20:40:11 123_S1V1C3 | ABC_S1V1C3 | XYZ_S1V1C3 |列|有效| 123_S1V1 | 2019-11-09_20:40:11 123_S1V2 | ABC_S1V2 | XYZ_S1V2 |视图|有效| 123_S1 | 2019-11-09_20:40:11 123_S1V2C1 | ABC_S1V2C1 | XYZ_S1V2C1 |列|有效| 123_S1V2 | 2019-11-09_20:40:11 123_S1V2C2 | ABC_S1V2C2 | XYZ_S1V2C2 |列|有效| 123_S1V2 | 2019-11-09_20:40:11 123_S1V2C3 | ABC_S1V2C3 | XYZ_S1V2C3 |列|有效| 123_S1V2 | 2019-11-09_20:40:11
PS:我尝试使用行映射器方法,但是对于如何维护父子关系(如模式可以具有表/视图列表)感到困惑。同样,一个表/视图可以具有多个列。