| 本帖最后由 jsl8071808 于 2016-7-6 13:11 编辑 FR的多级上报,每个人写的备注,最终在数据库里存成了一个数组,如下: [{"time":"2016-07-01 10:40:53","nodeIdx":0,"message":"已填","user":"曹琳(caolin)"},{"time":"2016-07-01 10:41:48","nodeIdx":0,"message":"已填","user":"陈杰(chenjie)"},{"time":"2016-07-01 10:43:09","nodeIdx":1,"message":"退回测试","user":"许光(xuguang)"},{"time":"2016-07-01 10:47:52","nodeIdx":2,"message":"试试","user":"曹琳(caolin)"},{"time":"2016-07-01 10:47:13","nodeIdx":2,"message":"试试","user":"陈杰(chenjie)"},{"time":"2016-07-01 10:48:19","nodeIdx":3,"message":"试试","user":"许光(xuguang)"},{"time":"2016-07-01 10:49:02","nodeIdx":4,"message":"试试","user":"陈杰(chenjie)"},{"time":"2016-07-01 10:49:30","nodeIdx":5,"message":"通过","user":"许光(xuguang)"}] 我想在模板数据集中用这个数组,写成select * from [{"time":"2016-07-01 10:40:53","nodeIdx":0,"message":"已填","user":"曹琳(caolin)"},{"time":"2016-07-01 10:41:48","nodeIdx":0,"message":"已填","user":"陈杰(chenjie)"},{"time":"2016-07-01 10:43:09","nodeIdx":1,"message":"退回测试","user":"许光(xuguang)"},{"time":"2016-07-01 10:47:52","nodeIdx":2,"message":"试试","user":"曹琳(caolin)"},{"time":"2016-07-01 10:47:13","nodeIdx":2,"message":"试试","user":"陈杰(chenjie)"},{"time":"2016-07-01 10:48:19","nodeIdx":3,"message":"试试","user":"许光(xuguang)"},{"time":"2016-07-01 10:49:02","nodeIdx":4,"message":"试试","user":"陈杰(chenjie)"},{"time":"2016-07-01 10:49:30","nodeIdx":5,"message":"通过","user":"许光(xuguang)"}] 系统显示错误,正确的写法和解决方法是什么呢 |
