spring data jpa遇到的问题

spring data jpa遇到的问题

一.连表查询

1.连表查询时，from后的表要用（）包起来
    @Query(value = "SELECT b.cp01,b.ar01,b.cp02,b.cp03,b.cp04,b.cp05,a.bn10,a.bn11 from  **(tb_cupboard as a, tb_config as b)** where a.bn01=b.cp01",nativeQuery = true)
 2.不要为查询字段起别名

二.实体类

1.当查询出来的数据包含两张表的数据时，实体类需加上@SecondaryTable其中name属性为其他表的表名，需给字段加上@Column(name="bn10", table="tb_cupboard")，其中name为表的字段id，table为表明

@Data
@Entity
@Table(name = "tb_config")
@SecondaryTable(name="tb_cupboard")
public class ConfigDbo implements Serializable {

    @Id
    @Column(name = "cp01")
    @NotBlank(message = "设备编号不能为空")
    @ApiModelProperty(dataType = "String", value = "柜机编号", name = "code", example = "101")
    private String parentCode;//柜机编号

    @Column(name = "ar01")
    @NotBlank(message = "所属机构不能为空")
    @ApiModelProperty(dataType = "String", value = "所属机构", name = "areaCode", example = "202")
    private String areaCode;//所属机构


    @Column(name="bn11", table="tb_cupboard")
    @ApiModelProperty(dataType = "String", value = "安装位置", name = "dre", example = "大厅")
    private String dre;

}