我想传递相同的ajax属性

Question

    1号  1号      1号     10号                                                                                                   10号                                         5号        5号        5号          

ajax结果

[0]“GNO”：1
 · · · ·“INO”：1
 · · · “ireq”：10
[1]“GNO”：4
 · · · “INO”：1
 · · “ireq”：100

ajax结果是我想要的

Answer 1

您不能直接这样做，因为大多数JSON实现不支持重复键。

您可能需要更改返回给客户端的数据的结构，例如，如下所示重命名列：

select G_NO, T1.I_NO AS T1_I_NO, T1.I_REQ AS T1_I_REQ,
       T2.I_NO AS T2_I_NO, T2.I_REQ AS T2_I_REQ,
       T3.I_NO AS T3_I_NO, T3.I_REQ AS T3_I_REQ
  from (select * from ELEMENT where I_NO=1) T1 
  inner join (select * from ELEMENT where I_NO=3) T2 using (G_NO) 
  inner join ( select * from ELEMENT where I_NO=5) T3 using (G_NO)  

在这种情况下，结果将是

[0]"gNo": 1 
   "t1INo": 1 
   "t1IReq": 10 
   "t2INo": 3
   "t2IReq": 20 
   "t3INo": 5 
   "t3IReq": 1 
[1]"gNo": 4 
   "t1INo": 1 
   "t1IReq": 100 
   "t2INo": 3
   "t2IReq": 10 
   "t3INo": 5 
   "t3IReq": 1