JPA实体中格式hh:mm:ss属性的映射持续时间

Question

我有一个excel文件，用于记录驾驶员分数，其中包括指定的驾驶持续时间，如hh:mm:ss格式的54:30:15。h代表小时，m代表分钟，秒。我有以下JPA实体

public class DriverScorecard {
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private Long id;

    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name = "driver_id", referencedColumnName = "id")
    private Driver driver;
    @Column(name = "month", nullable = false)
    private Integer month;
    @Column(name = "year", nullable = false)
    private Integer year;
    private Double distance;
    private Double maxSpeed;
    private Integer harshBreakingPenalty;
    private Integer harshBreakingOccurency;
    private Double harshBreakingScore;
    private Integer harshAccelerationPenalty;
    private Integer harshAccelerationOccurency;
    private Double harshAccelerationScore;
    private Integer overSpeedingPenalty;
    private Duration overSpeedingDuration;
    private Double overSpeedingScore;
    private Integer HOSPenalty;
    private Duration HOSDuration;
    private Double HOSScore;
    private Double totalScore;
    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name = "status_id", referencedColumnName = "id")
    private ScorecardStatus status;
    @CreationTimestamp
    @Builder.Default
    private ZonedDateTime createdAt = ZonedDateTime.now();
}

我从excel中得到了价值

String durationString = "54:30:15";

并使用java。时间持续时间api。我使用了

Duration duration = Duration.parse(durationString);

但是java出现了一个错误。时间总体安排DateTimeParseException：无法在java中将文本解析为持续时间。基本/java。时间期间解析（Duration.java:419）。欢迎就可能的解决方案提出任何建议

Answer 1

根据文档，parse方法接受ISO-8601中的字符序列。因此，如果要为parse方法提供参数，应该这样编写：PT54H30M15S
我建议编写一个额外的方法，在ISO-8601中解析它，除非您无法更改excel文件中的传入数据。

String[] durationArray = durationString.split(":");
String durationFormatted = String.format("PT%sH%sM%sS", (Object[]) duration);
Duration duration = Duration.parse(durationFormatted);