hibernate,jpa @onetoone效率问题求助大佬解决

项目大类的信息

/**
 * 项目大类(一级分类)
 * @author luoye
 *
 */
@Entity
@Table(name="~~~(省略)")
public class FirstLevelClassification {
	@Id
	@GeneratedValue(generator = "baseeGenerator") 
	@GenericGenerator(name = "baseeGenerator" , strategy = "guid") //根据表主键的规则自动生成 guid
	@Column(name = "dlbm" , length = 36)
	private String id;	//大类编码
	@Column(name="dlmc")
	private String name;	//大类名称
	@OneToMany(fetch=FetchType.LAZY,cascade= {CascadeType.PERSIST,CascadeType.REFRESH},mappedBy="firstLevelClassification")
	private Set<SecondLevelClassification> secondLevelClassifications;//小类
	@OneToOne(fetch=FetchType.EAGER,mappedBy="firstLevelClassification")
	private FirstLevelClassificationExpandInfo firstLevelClassificationExpandInfo;//大类拓展信息表
	public String getId() {
		return id;
	}
	public void setId(String id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public Set<SecondLevelClassification> getSecondLevelClassifications() {
		return secondLevelClassifications;
	}
	public void setSecondLevelClassifications(Set<SecondLevelClassification> secondLevelClassifications) {
		this.secondLevelClassifications = secondLevelClassifications;
	}
	public FirstLevelClassificationExpandInfo getFirstLevelClassificationExpandInfo() {
		return firstLevelClassificationExpandInfo;
	}
	public void setFirstLevelClassificationExpandInfo(
			FirstLevelClassificationExpandInfo firstLevelClassificationExpandInfo) {
		this.firstLevelClassificationExpandInfo = firstLevelClassificationExpandInfo;
	}
}

这是医院项目大类的拓展信息

@Entity
@Table(name="~~~(省略)")
public class FirstLevelClassificationExpandInfo extends HisBaseEntity implements Serializable{
	private static final long serialVersionUID = 1L;
	@JoinColumn(name="xmdlxh")
	@OneToOne(fetch=FetchType.EAGER)
	private FirstLevelClassification firstLevelClassification;//大类
	@Column(name="xmjj")
	private String Introduction;//简介
	public FirstLevelClassification getFirstLevelClassification() {
		return firstLevelClassification;
	}
	public void setFirstLevelClassification(FirstLevelClassification firstLevelClassification) {
		this.firstLevelClassification = firstLevelClassification;
	}
	public String getIntroduction() {
		return Introduction;
	}
	public void setIntroduction(String introduction) {
		Introduction = introduction;
	}
}

然后我查询大类信息

/**
	 * 获取项目大类列表
	 */
	@Override
	public Result getFirstLevelClassifications() throws Exception {
		List<FirstLevelClassification> firstLevelClassifications = firstLevelClassificationRepository.findAll();
		System.out.println(firstLevelClassifications.size());
		return success();
	}

关键问题来了,我查询大类信息我想连着拓展信息一起查出来,可是他查询的拓展信息的时候不是左连接查询,是先查出大类,在循环查询拓展信息,导致效率极低~,有没有精通hibernate的大佬帮助我一下我这个可怜的小码农啊
目前自己的解决的方案是手写sql查vo,想问问大佬们有没有便捷的解决方案~~
贴下目前的效率
在这里插入图片描述万分感谢大佬~~~

评论 4
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值