效果图:
如图,根据条件查询主表信息,并关联获取详细数据,并实现简单的排序功能,不多说,上代码:
model:
/** * @author xj * @date 2017/5/3 13:31 */ @Getter @Setter @Entity(name = "BOND_RATE") public class BondRate { @Id private String id; private String bondId; private String rateStaff; private String postStatus; private String internalRate; private String rateView; private String attachmentId; private Date rateTime; @ManyToOne(fetch = FetchType.LAZY) @JoinColumn(name = "bondId", insertable = false, updatable = false) @JsonIgnore @NotFound(action = NotFoundAction.IGNORE) private Bond bond; }
Controller:
/** * 根据条件查询债券评级的接口 * * @param bondId * @param bondName * @param rateStaff * @param postStatus * @param startTime * @param endTime * @param pageable * @return * @throws ParseException */ @GetMapping(value = "/allBondRate") public Result findA