SpringBoot JSON問(wèn)題

查詢使用SpringBoot 默認(rèn)的json，數(shù)據(jù)庫(kù)返回的JSON是這樣的

[{
    "bg_CycleId": null,
    "bg_BugId": null,
    "bg_Status": "Closed",
    "bg_Responsible": "范偉",
    "bg_Project": null,
    "bg_Subject": null,
    "bg_Summary": "1、教學(xué)實(shí)訓(xùn)教師無(wú)法選擇教學(xué)任務(wù)和上傳文件",
    "bg_Description": "<html><body>1、教學(xué)實(shí)訓(xùn)教師無(wú)法選擇教學(xué)任務(wù)和上傳文件</body></html>",
    "bg_DevComments": null,
    "bg_Reproducible": "Y",
    "bg_Severity": "1-一般缺陷",
    "bg_Priority": "5-Urgent",
    "bg_DetectedBy": null,
    "bg_TestReference": null,
    "bg_CycleReference": null,
    "bg_RunReference": null,
    "bg_StepReference": null,
    "bg_DetectionDate": null,
    "bg_DetectionVersion": null,
    "bg_PlannedClosingVer": null,
    "bg_EstimatedFixTime": null,
    "bg_ActualFixTime": null,
    "bg_ClosingDate": null,
    "bg_ClosingVersion": null,
    "bg_ToMail": null,
    "bg_Attachment": "Y",
    "bg_User01": null,
    "bg_User02": null,
    "bg_User03": null,
    "bg_User04": null,
    "bg_User05": null,
    "bg_User06": null,
    "bg_User07": null,
    "bg_User08": null,
    "bg_User09": null,
    "bg_User10": null,
    "bg_User11": null,
    "bg_User12": null,
    "bg_User13": null,
    "bg_User14": null,
    "bg_User15": null,
    "bg_User16": null,
    "bg_User17": null,
    "bg_User18": null,
    "bg_User19": null,
    "bg_User20": null,
    "bg_User21": null,
    "bg_User22": null,
    "bg_User23": null,
    "bg_User24": null,
    "bg_UserHr01": null,
    "bg_UserHr02": null,
    "bg_UserHr03": null,
    "bg_UserHr04": null,
    "bg_UserHr05": null,
    "bg_UserHr06": null,
    "bg_BugVerStamp": null,
    "bg_HasChange": null,
    "bg_Vts": "2017-08-23 14:11:59",
    "bg_ExtendedReference": null,
    "bg_TaskStatus": null
}, {
    "bg_CycleId": null,
    "bg_BugId": null,
    "bg_Status": "Closed",
    "bg_Responsible": "王鄉(xiāng)城",
    "bg_Project": null,
    "bg_Subject": null,
    "bg_Summary": "2、實(shí)訓(xùn)成績(jī)導(dǎo)出excel所選信息學(xué)號(hào)和姓名位置錯(cuò)亂",
    "bg_Description": "<html><body>2、實(shí)訓(xùn)成績(jī)導(dǎo)出excel所選信息學(xué)號(hào)和姓名位置錯(cuò)亂</body></html>",
    "bg_DevComments": null,
    "bg_Reproducible": "Y",
    "bg_Severity": "1-一般缺陷",
    "bg_Priority": "5-Urgent",
    "bg_DetectedBy": null,
    "bg_TestReference": null,
    "bg_CycleReference": null,
    "bg_RunReference": null,
    "bg_StepReference": null,
    "bg_DetectionDate": null,
    "bg_DetectionVersion": null,
    "bg_PlannedClosingVer": null,
    "bg_EstimatedFixTime": null,
    "bg_ActualFixTime": null,
    "bg_ClosingDate": null,
    "bg_ClosingVersion": null,
    "bg_ToMail": null,
    "bg_Attachment": "Y",
    "bg_User01": null,
    "bg_User02": null,
    "bg_User03": null,
    "bg_User04": null,
    "bg_User05": null,
    "bg_User06": null,
    "bg_User07": null,
    "bg_User08": null,
    "bg_User09": null,
    "bg_User10": null,
    "bg_User11": null,
    "bg_User12": null,
    "bg_User13": null,
    "bg_User14": null,
    "bg_User15": null,
    "bg_User16": null,
    "bg_User17": null,
    "bg_User18": null,
    "bg_User19": null,
    "bg_User20": null,
    "bg_User21": null,
    "bg_User22": null,
    "bg_User23": null,
    "bg_User24": null,
    "bg_UserHr01": null,
    "bg_UserHr02": null,
    "bg_UserHr03": null,
    "bg_UserHr04": null,
    "bg_UserHr05": null,
    "bg_UserHr06": null,
    "bg_BugVerStamp": null,
    "bg_HasChange": null,
    "bg_Vts": "2017-08-23 14:12:01",
    "bg_ExtendedReference": null,
    "bg_TaskStatus": null
}]

而LayUi要求返回的JSON格式是下面這樣的：

{
  "code": 0,
  "msg": "",
  "count": 1000,
  "data": [{
    "id": 10000,
    "username": "user-0",
    "sex": "女",
    "city": "城市-0",
    "sign": "簽名-0",
    "experience": 255,
    "logins": 24,
    "wealth": 82830700,
    "classify": "作家",
    "score": 57
  }, {
    "id": 10001,
    "username": "user-1",
    "sex": "男",
    "city": "城市-1",
    "sign": "簽名-1",
    "experience": 884,
    "logins": 58,
    "wealth": 64928690,
    "classify": "詞人",
    "score": 27
  }, {
    "id": 10002,
    "username": "user-2",
    "sex": "女",
    "city": "城市-2",
    "sign": "簽名-2",
    "experience": 650,
    "logins": 77,
    "wealth": 6298078,
    "classify": "醬油",
    "score": 31
  }, {
    "id": 10003,
    "username": "user-3",
    "sex": "女",
    "city": "城市-3",
    "sign": "簽名-3",
    "experience": 362,
    "logins": 157,
    "wealth": 37117017,
    "classify": "詩(shī)人",
    "score": 68
  }, {
    "id": 10004,
    "username": "user-4",
    "sex": "男",
    "city": "城市-4",
    "sign": "簽名-4",
    "experience": 807,
    "logins": 51,
    "wealth": 76263262,
    "classify": "作家",
    "score": 6
  }, {
    "id": 10005,
    "username": "user-5",
    "sex": "女",
    "city": "城市-5",
    "sign": "簽名-5",
    "experience": 173,
    "logins": 68,
    "wealth": 60344147,
    "classify": "作家",
    "score": 87
  }, {
    "id": 10006,
    "username": "user-6",
    "sex": "女",
    "city": "城市-6",
    "sign": "簽名-6",
    "experience": 982,
    "logins": 37,
    "wealth": 57768166,
    "classify": "作家",
    "score": 34
  }, {
    "id": 10007,
    "username": "user-7",
    "sex": "男",
    "city": "城市-7",
    "sign": "簽名-7",
    "experience": 727,
    "logins": 150,
    "wealth": 82030578,
    "classify": "作家",
    "score": 28
  }, {
    "id": 10008,
    "username": "user-8",
    "sex": "男",
    "city": "城市-8",
    "sign": "簽名-8",
    "experience": 951,
    "logins": 133,
    "wealth": 16503371,
    "classify": "詞人",
    "score": 14
  }, {
    "id": 10009,
    "username": "user-9",
    "sex": "女",
    "city": "城市-9",
    "sign": "簽名-9",
    "experience": 484,
    "logins": 25,
    "wealth": 86801934,
    "classify": "詞人",
    "score": 75
  }]
}

如何轉(zhuǎn)換成layui官方要求的格式？還是說(shuō)要用第三方的JSON架包

回答

編輯回答

菊外人

你直接返回的是一個(gè)對(duì)象列表（List<OBJECT>），
UI要求的是一個(gè)復(fù)合對(duì)象，包含code，msg，count，data 四個(gè)屬性，然后data屬性是一個(gè)對(duì)象列表。
可以將返回對(duì)象封裝一下，
寫一個(gè)POJO，定義4個(gè)屬性，code，msg，count，data，
然后data屬性是一個(gè)List<OBJECT>，用于放你現(xiàn)有的對(duì)象列表，
然后把這個(gè)pojo返回給前臺(tái)

2017年5月24日 15:54

編輯回答