查询返回JSON数据结果集

查询返回JSON数据结果集

设计目标：

1）一次性可以返回N个数据表的JSON数据

2）跨数据库引擎

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27

{     "tables":     [         {             "cols":             [                 {                     "name": "field1",                     "type": "string",                     "size": 10                 }                 {                     "name": "field2",                     "type": "int"                 }             ]             "rows":             [                 {                     "field1": "咏南中间件"                     "field2": 888                 }             ]         }         ......     ] }