hibernate的多对多关联之级联查询与自关联查询

最新推荐文章于 2021-08-04 09:41:19 发布

pssalways

最新推荐文章于 2021-08-04 09:41:19 发布

阅读量1.1k

点赞数

分类专栏： hibernate 文章标签： hibernate的多对多

本文链接：https://blog.csdn.net/pssalways/article/details/83420485

版权

本文主要探讨Hibernate中多对多关联的级联查询与自关联查询。通过TreeNode、Book和Category三个实体类及对应的XML映射文件，展示了在Dao层的实现。在JUnit测试中，详细阐述了级联查询的过程，包括一级、二级和三级节点的加载情况，特别是对懒加载策略在大量数据时的考量，提出了逐级加载菜单以优化用户体验的方案。

摘要由CSDN通过智能技术生成

一、级联查询：

实体类：

1、TreeNode.class

package com.five.entity;

import java.util.ArrayList;
import java.util.HashSet;
import java.util.List;
import java.util.Set;

public class TreeNode {
	/*create table t_hibernate_sys_tree_node
	(
	  tree_node_id int primary key auto_increment,                                                 -- ID
	  tree_node_name varchar(50) not null,                                                         -- 名字
	  tree_node_type int not null check(tree_node_type = 1 or tree_node_type = 2),                 -- 节点类型：1 枝节点 2 叶节点

	  position int,                                                                             -- 位置
	  parent_node_id int,                                                                         -- 父节点ID
	  url varchar(1024),                                                                           -- URL
	  foreign key(parent_node_id) references t_hibernate_sys_tree_node(tree_node_id)
	);*/
	
	private Integer treeNodeId;
	private String treeNodeName;
	private Integer treeNodeType;
	private Integer position;
	private String url;
	
	//当前节点与子节点的关联关系	一对多
//	private Set<TreeNode> children = new HashSet<>();
	private List<TreeNode> children = new ArrayList<>();
	//当前节点与父节点			多对一
	private TreeNode parent;
	private Integer initChildren = 0;
	
/*	public Set<TreeNode> getChildren() {
		return children;
	}
	public void setChildren(Set<TreeNode> children) {
		this.children = children;
	}*/
	public TreeNode getParent() {
		return parent;
	}
	public List<TreeNode> getChildren() {
		return children;
	}
	public void setChildren(List<TreeNode> children) {
		this.children = children;
	}
	public void setParent(TreeNode parent) {
		this.parent = parent;
	}
	public Integer getInitChildren() {
		return initChildren;
	}
	public void setInitChildren(Integer initChildren) {
		this.initChildren = initChildren;
	}
	public Integer getTreeNodeId() {
		return treeNodeId;
	}
	public void setTreeNodeId(Integer treeNodeId) {
		this.treeNodeId = treeNodeId;
	}
	public String getTreeNodeName() {
		return treeNodeName;
	}
	public void setTreeNodeName(String treeNodeName) {
		this.treeNodeName = treeNodeName;
	}
	public Integer getTreeNodeType() {
		return treeNodeType;
	}
	public void setTreeNodeType(Integer treeNodeType) {
		this.treeNodeType = treeNodeType;
	}
	public Integer getPosition() {
		return position;
	}
	public void setPosition(Integer position) {
		this.position = position;
	}
	public String getUrl() {
		return url;
	}
	public void setUrl(String url) {
		this.url = url;
	}
	@Override
	public String toString() {
		return "TreeNode [treeNodeId=