Mr_Dracy的博客

SQL语句

先上一个SQL： SELECT temp.facility_id , temp.unit_id, temp.user_id, temp.`day`, temp.time_period, temp.stool_id, temp.stool_abbreviation, temp.situation_id, temp.situation_abbreviation, temp.stool_incontinence, temp.bloody_stool FROM ( SELECT mumr.bloody_stool

要查询的响应数据List<类>：可以看出是一对多的查询 @Data @ApiModel("カルテ一览响应参数") public class BeautyChartResVo { @ApiModelProperty("カルテ ID") private Long id; @ApiModelProperty("ルテ做成者(店员)") private String staff_name; @ApiModelProperty("顾客ID") private

原SQL： SELECT COUNT(DISTINCT a.customerid) FROM sl_sales_record a LEFT JOIN (SELECT customerid FROM sl_sales_record WHERE shopid = 55 AND regdate <= "2020-10-14" AND regdate > "2020-06-14" GROUP BY customerid) b ON a.customerid = b.customerid WHERE b.

注解 @Target(value = { ElementType.FIELD }) @Retention(value = RetentionPolicy.RUNTIME) public @interface Column { public String name(); } /** * 标识主键列对应的属性 */ @Target(value = { ElementType.FIELD }) @Retention(value = RetentionPolicy.RUNTIME) public