hibernate orm配置一对多时，多方加一字段记录顺序 -CSDN博客

本文链接：https://blog.csdn.net/cgb278653219/article/details/84774525

本文探讨了在数据库映射中父子类关系的优化方法，特别关注于如何合理配置XML配置文件以避免错误并实现高效的数据操作。通过实例展示了如何在父类和子类间正确设置一对一或多对多关系，并解释了配置文件中`<order-by>`和`<order-column>`元素的使用及相互冲突的解决策略。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

代码：

一方：

import java.util.List;

public class Father {
	private Long id;
	List<Son> sons;
	public Long getId() {
		return id;
	}
	public void setId(Long id) {
		this.id = id;
	}
	public List<Son> getSons() {
		return sons;
	}
	public void setSons(List<Son> sons) {
		this.sons = sons;
	}
	
}

多方：

public class Son {
	private Long id;
	private String sort;
	private Father father;
	public Long getId() {
		return id;
	}
	public void setId(Long id) {
		this.id = id;
	}
	public String getSort() {
		return sort;
	}
	public void setSort(String sort) {
		this.sort = sort;
	}
	public Father getFather() {
		return father;
	}
	public void setFather(Father father) {
		this.father = father;
	}
	
}

配置文件：

一方：

不能同时配置 <order-by >和<order-column> 会报如下错误，

Invalid content was found starting with element 分开配置：

<?xml version="1.0" encoding="UTF-8"?>
<entity-mappings xmlns="http://java.sun.com/xml/ns/persistence/orm"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://java.sun.com/xml/ns/persistence/orm http://java.sun.com/xml/ns/persistence/orm_2_0.xsd"
	version="2.0">
	<package>...model...</package>
	<access>PROPERTY</access>
	<entity class="Father" name="Father">
		<table name="tb_father" />
		<sequence-generator name="SEQ_tb_father_ID" sequence-name="SEQ_tb_father_ID" allocation-size="1"/>
		<attributes>
			<id name="id">
				<column name="ID" unique="true" nullable="false"
					precision="11" scale="0" />
				<generated-value strategy="SEQUENCE" generator="SEQ_tb_father_ID" />
			</id>
			<!--1.对应关系跟下面2一样   ：查询子list时会加一个order by sort_order ASC的条件-->
			<one-to-many name="sons" fetch="LAZY" mapped-by="father">
			<order-by >sort_order ASC</order-by>
				<cascade><cascade-all/></cascade>
			</one-to-many>
			<!--2.对应关系跟上面1一样，分开写两次为了避开上面红字的报错。  插入或更新时会记录顺序，通过在tb_son的sort_order中从0递增记录-->
			<one-to-many name="sons" fetch="LAZY" mapped-by="resource">
			<order-column name="sort_order" insertable="true" updatable="true"/>
			</one-to-many>
		</attributes>
	</entity>
</entity-mappings>

多方：

<?xml version="1.0" encoding="UTF-8"?>
<entity-mappings xmlns="http://java.sun.com/xml/ns/persistence/orm"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://java.sun.com/xml/ns/persistence/orm http://java.sun.com/xml/ns/persistence/orm_2_0.xsd"
	version="2.0">
	<package>...model...</package>
	<access>PROPERTY</access>
	<entity class="Son" name="Son">
		<table name="tb_son" />
		<sequence-generator name="SEQ_tb_son_ID" sequence-name="SEQ_tb_son_ID" allocation-size="1"/>
		<attributes>
			<id name="id">
				<column name="ID" unique="true" nullable="false"
					precision="11" scale="0" />
				<generated-value strategy="SEQUENCE" generator="SEQ_tb_son_ID" />
			</id>
			<basic name="sort">
				<column name="sort_order" length="64" nullable="true" />
			</basic>
			<many-to-one name="father" fetch="LAZY">
				<join-column name="father_ID" insertable="true" updatable="true" />
				<cascade><cascade-persist/><cascade-merge/><cascade-refresh/></cascade>
			</many-to-one>
		</attributes>
	</entity>
</entity-mappings>

表结构如下：

| tb_father | tb_son

| id | id

| | sort_order

| | father_ID

father里有两个son1、son2，save（father）时：
tb_father 表数据：

tb_son 表数据：

id sort_order father_id

1 0 1

2 1 1