jpa 关联其它类（下拉框单选）

最新推荐文章于 2022-05-29 08:16:48 发布

tonysh_zds

最新推荐文章于 2022-05-29 08:16:48 发布

阅读量339

点赞数

分类专栏： springboot

本文链接：https://blog.csdn.net/tonysh_zds/article/details/108000530

版权

springboot 专栏收录该内容

31 篇文章 1 订阅

订阅专栏

1、查询条件修改

public class ItemTopicDetailQueryCriteria{

  //原通过id查
    /** 精确 */
   // @Query
   // private Integer topicId;
 //改为通过ID关联对象查
    @Query(propName = "id", type = Query.Type.EQUAL, joinName = "itemTopic")
    private Integer topicId ;
...
}
    ```
   2、dto 数据传输对象修改

/** 专题序号 */
//private Integer topicId;
// 改为对象，对应查询类的joinName =“itemTopic”
private ItemTopic itemTopic;
```

3、domain 修改

 /*@Column(name = "topic_id",nullable = false)
 @NotNull
 @ApiModelProperty(value = "专题序号")
 private Integer topicId;
 */

 @OneToOne
 @JoinColumn(name = "topic_id",,nullable = false)
 @ApiModelProperty(value = "专题模板")
 private ItemTopic itemTopic;
 ```
4、修改完后注意要 clear一下，重新生成MapperImpl,要不然数据转换不出来，也不报错,页面查询会无数据。

public class ItemTopicDetailMapperImpl implements ItemTopicDetailMapper {
@Override
public ItemTopicDetail toEntity(ItemTopicDetailDto arg0) {
if ( arg0 == null ) {
return null;
}

    ItemTopicDetail itemTopicDetail = new ItemTopicDetail();

    itemTopicDetail.setCreateBy( arg0.getCreateBy() );
    itemTopicDetail.setUpdatedBy( arg0.getUpdatedBy() );
    itemTopicDetail.setCreateTime( arg0.getCreateTime() );
    itemTopicDetail.setUpdateTime( arg0.getUpdateTime() );
    itemTopicDetail.setId( arg0.getId() );
    itemTopicDetail.setFullname( arg0.getFullname() );
    itemTopicDetail.setDeptId( arg0.getDeptId() );
    itemTopicDetail.setItemTopic( arg0.getItemTopic() );
    itemTopicDetail.setObjnameCn( arg0.getObjnameCn() );
    itemTopicDetail.setEnabled( arg0.getEnabled() );
    itemTopicDetail.setAuditComment( arg0.getAuditComment() );
    itemTopicDetail.setMemo( arg0.getMemo() );
    itemTopicDetail.setMemo1( arg0.getMemo1() );
    itemTopicDetail.setMemo2( arg0.getMemo2() );
    itemTopicDetail.setMemo3( arg0.getMemo3() );
    itemTopicDetail.setMemo4( arg0.getMemo4() );
    itemTopicDetail.setUuid( arg0.getUuid() );

    return itemTopicDetail;
}
@Override
public ItemTopicDetailDto toDto(ItemTopicDetail arg0) {
    if ( arg0 == null ) {
        return null;
    }

    ItemTopicDetailDto itemTopicDetailDto = new ItemTopicDetailDto();

    itemTopicDetailDto.setCreateBy( arg0.getCreateBy() );
    itemTopicDetailDto.setUpdatedBy( arg0.getUpdatedBy() );
    itemTopicDetailDto.setCreateTime( arg0.getCreateTime() );
    itemTopicDetailDto.setUpdateTime( arg0.getUpdateTime() );
    itemTopicDetailDto.setId( arg0.getId() );
    itemTopicDetailDto.setFullname( arg0.getFullname() );
    itemTopicDetailDto.setDeptId( arg0.getDeptId() );
    itemTopicDetailDto.setItemTopic( arg0.getItemTopic() );
    itemTopicDetailDto.setObjnameCn( arg0.getObjnameCn() );
    itemTopicDetailDto.setEnabled( arg0.getEnabled() );
    itemTopicDetailDto.setAuditComment( arg0.getAuditComment() );
    itemTopicDetailDto.setMemo( arg0.getMemo() );
    itemTopicDetailDto.setMemo1( arg0.getMemo1() );
    itemTopicDetailDto.setMemo2( arg0.getMemo2() );
    itemTopicDetailDto.setMemo3( arg0.getMemo3() );
    itemTopicDetailDto.setMemo4( arg0.getMemo4() );
    itemTopicDetailDto.setUuid( arg0.getUuid() );

    return itemTopicDetailDto;
}

@Override
public List<ItemTopicDetail> toEntity(List<ItemTopicDetailDto> arg0) {
    if ( arg0 == null ) {
        return null;
    }

    List<ItemTopicDetail> list = new ArrayList<ItemTopicDetail>( arg0.size() );
    for ( ItemTopicDetailDto itemTopicDetailDto : arg0 ) {
        list.add( toEntity( itemTopicDetailDto ) );
    }

    return list;
}

@Override
public List<ItemTopicDetailDto> toDto(List<ItemTopicDetail> arg0) {
    if ( arg0 == null ) {
        return null;
    }

    List<ItemTopicDetailDto> list = new ArrayList<ItemTopicDetailDto>( arg0.size() );
    for ( ItemTopicDetail itemTopicDetail : arg0 ) {
        list.add( toDto( itemTopicDetail ) );
    }

    return list;
}

}