我有一段位于Java服务器上的代码:
JSONArray resultJson = new JSONArray();
try{
ConnectToDB();
stmt = conn.prepareStatement(query);
m_ResultSet = stmt.executeQuery();
resultJson = FromDBToJSON.toJSON(m_ResultSet);
}
我得到了如下结果:
id: 1,
dest_country: "England",
fname: "Duncan",
lname: "Hurley",
address: "xyz"
},
{
id: 2,
dest_country: "England",
fname: "Duncan",
lname: "Hurley",
address: "xyz"
},
{
id: 3,
dest_country: "Israel",
fname: "Duncan",
lname: "Hurley",
address: "xyz"
},
{
id: 4,
dest_country: "USA",
fname: "Duncan",
lname: "Hurley",
address: "xyz"
},
我需要将所有用户数据(即名字、姓氏和地址)放入一个嵌套属性中,例如以下格式:
{
id : 2,
dest_country: "England",
user: {
fname: "Duncan",
lname: "Hurley",
address: "xyz"
}
}
如何实现这个目标?
谢谢!