springboot：将对象数组写入数据库

{
sourceImageRepo: "xxx",sourcetagMatch: "xxx",targetProject: "xxx",targetFiles: [
{
name: "xxx",pattern: "xxx"
},{
name: "xxx",pattern: "xxx"
}
]
}


我收到这样的错误消息：

{
"timestamp": "2019-12-10T06:36:42.745+0000","status": 500,"error": "Internal Server Error","message": "Could not write JSON: (was java.lang.ArrayIndexOutOfBoundsException); nested exception is com.fasterxml.jackson.databind.JsonmappingException: (was java.lang.ArrayIndexOutOfBoundsException) (through reference chain: org.springframework.data.rest.webmvc.json.PersistentEntityJackson2Module$PersistentEntityResourceSerializer$1[\"content\"]->com.example.demo.model.suiteInformations[\"targetFiles\"]->java.util.ArrayList[0])","path": "/suiteInformationses/1"
}


当前模型

suiteInformations.java

package com.example.demo.model;
import javax.persistence.*;
import java.util.ArrayList;
@Entity
@Table(name = "suitesInformations")
public class suiteInformations {
public suiteInformations(int id,String sourceImageRepo,String sourcetagMatch,String email,String targetProject,ArrayList targetFiles) {
this.id = id;
this.sourceImageRepo = sourceImageRepo;
this.sourcetagMatch = sourcetagMatch;
Email = email;
this.targetProject = targetProject;
this.targetFiles = targetFiles;
}
public suiteInformations() {}
@Id
@Column(name = "id")
@GeneratedValue
public int id;
@Column(name = "sourceImageRepo")
public String sourceImageRepo;
@Column(name = "sourcetagMatch")
public String sourcetagMatch;
@Column(name = "Email")
public String Email;
@Column(name = "targetProject")
public String targetProject;
@Embedded
public ArrayList targetFiles;
// getters/setters omitted
}


TargetFiles.java

package com.example.demo.model;
import javax.persistence.Column;
import javax.persistence.Embeddable;
import java.util.ArrayList;
@Embeddable
public class TargetFiles {
@Column(name = "name")
public String name;
@Column(name = "pattern")
public String pattern;
}


数据库内容

SELECT * FROM SUITESINFORMATIONS;
ID EMAIL SOURCEIMAGEREPO SOURCetaGMATCH SIZE TARGETPROJECT
1 xxx xxx xxx 1 xxx


您缺少json中键的引号。我希望这只是一个错字。

{
"sourceImageRepo": "xxx","sourceTagMatch": "xxx","targetProject": "xxx","targetFiles": [
{
"name": "xxx","pattern": "xxx"
},{
"name": "xxx","pattern": "xxx"
}
]
}


您如何尝试将json映射到对象中？
它是api的请求主体吗？您能提供该信息吗？

我将使用Spring的spring-boot-starter-data-jpa依赖项。看看Spring的@Repository注释也可能对您有好处。

spring-boot-starter-data-jpa的示例教程：https://spring.io/guides/gs/accessing-data-jpa/

您的JSON文件可能会成为POJO类：

@Entity
public class SuiteInfo {
@Id
@GeneratedValue(strategy=GenerationType.AUTO)
private Long id;
private String sourceImageRepo;
private String sourceTagMatch;
private String targetProject;
private List targetFiles;
//relevant getters,setters,equals,etc
public class SuiteFile {
private String name;
private String pattern;
//relevant getters,etc
}
}


然后可以创建存储库接口：

import org.springframework.data.repository.CrudRepository;
public interface SuiteInfoRepository extends CrudRepository {
SuiteInfo findById(long id);
// define other queries here
}


注意：（来自：https://spring.io/guides/gs/accessing-data-jpa/）
You need not write an implementation of the repository interface. Spring Data JPA creates an implementation when you run the application.