如何将Angular 7中的excel字符串JSON转换为实体对象列表并保存到数据库中？

Question

我已经用下面的模式从angular 7开始对excel JSON进行了字符串注册。

[{"Employee ID":"1234","Employee Name":"ABC","Designation":"Manager","Salary":"50000"}...]

我在controller类中使用object的List<<object>>从UI获取JSON

Controller.java

@PostMapping("/fetchExcelJson")

public void fetchExcelJson(@RequestBody List<<Object>> jsonData) {

employeeService.fetchJsonData(jsonDaata);

}

ServiceImpl.java

@Override

public void fetchJsonData(List<<Object>> jsonData) {

Iterator<Object> iterator = jsonData.iterator();

while(iterator.hasNext()) {

Object obj = iterator.next();

System.out.println(obj);

}

}

当我将JSON从UI发送到后端时，我在后端收到以下响应

{"Employee ID":"1234","Employee Name":"ABC","Designation":"Manager","Salary":"50000"}...

我需要将此JSON从后端转换为以下格式

{"employeeId":"1234","employeeName":"ABC","designation":"Manager","salary":"50000"}...

如果我使用实体对象，我会得到JSON解析错误。我只需要在后端格式中迭代这个来自UI的JSON列表。

有人能帮我解决这个问题吗？

Answer 1

示例JSON

    {
     "data": [
      {
         "employeeId": "Dummy",
         "employeeName": "Dummy",
         "designation": "Dummy",
         "salary": 50000
      },
      {
         "employeeId": "Dummy1",
         "employeeName": "Dummy1",
         "designation": "Dummy1",
         "salary": 5000
      }
   ]
  }

示例Java POJO

public class Employee {

private String employeeId;
private String employeeName;
private String designation;
private Double salary;

//Getters and Setters


}

Controller.java

@PostMapping("/fetchExcelJson")

public void fetchExcelJson(@RequestBody List<Employee> data) {

  employeeService.fetchJsonData(jsonDaata);

}