我有以下实体:
public class QuestionnaireTemplateEntity extends BaseEntity {
@Id
@GeneratedValue(generator="system-uuid")
@GenericGenerator(name="system-uuid", strategy = "uuid")
@Column(updatable = false, nullable = false)
private String id;
@OneToMany(mappedBy="questionnaireTemplate", cascade = CascadeType.ALL)
@OrderBy("subQuestionnaireOrder ASC")
private Set<SubQuestionnaireTemplateEntity> subQuestionnaires = new HashSet<>();
}
public class SubQuestionnaireTemplateEntity extends BaseEntity {
@Id
@GeneratedValue(generator="system-uuid")
@GenericGenerator(name="system-uuid", strategy = "uuid")
@Column(updatable = false, nullable = false)
private String id;
@OneToMany(mappedBy="subQuestionnaireTemplate", cascade = CascadeType.ALL)
@OrderBy("questionOrder ASC")
private Set<QuestionEntity> questions = new HashSet<>();
private Integer subQuestionnaireOrder;
}
public class QuestionEntity extends BaseEntity {
@Id
@GeneratedValue(generator="system-uuid")
@GenericGenerator(name="system-uuid", strategy = "uuid")
@Column(updatable = false, nullable = false)
private String id;
@ManyToOne
@JoinColumn(name="sub_questionnaire_template_id")
private SubQuestionnaireTemplateEntity subQuestionnaireTemplate;
private Integer questionOrder;
}
questionnaireTemplateRepository.findAll()