1、表说明
客户表
create table CUST.CUST_INFO
(
cusid VARCHAR2(20) not null,--主键
cusfname VARCHAR2(50),
cussname VARCHAR2(50),
custype VARCHAR2(20),--外键1 关联静态参数表flagcode
cusbeltown VARCHAR2(50),--外键2 关联静态参数表flagcode
cusbelarea VARCHAR2(50),--外键3 关联静态参数表flagcode
cusugasequ VARCHAR2(20)
--其余字段省略
)
静态参数表
create table SF.REAL_FLAG_PRO
(
flagcode VARCHAR2(30) not null, --主键
flagkey VARCHAR2(20) not null, --标示符
flagcodedes VARCHAR2(100) not null, --内容
isdeleted VARCHAR2(1) default '0' not null
)
2、需求说明
要求客户表和静态参数表关联,且是单向多对一关系。注:此处如果用双向关联会导致程序陷入死循环。
hibernate 映射文件如下:
CustInfo.hbm.xml
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.*.CustInfo" table="CUST_INFO" schema="CUST"> <!-- 注意此处的name属性路径要写全 -->
<id name="cusid" type="string">
<column name="CUSID" length="20" />
<generator class="assigned"></generator>
</id>
<property name="cusfname" type="string">
<column name="CUSFNAME" length="50" />
</property>
<property name="cussname" type="string">
<column name="CUSSNAME" length="50" />
</property>
<many-to-one name="realFlagProByCustype" class="com.sw.gcms.app.bean.sf.RealFlagPro" fetch="select" lazy="false"> <!-- 注意此处的name属性路径要写全,下面的一样,否则会报找不到类的错误 -->
<column name="CUSTYPE" length="30" />
</many-to-one>
<many-to-one name="realFlagProByCusbelarea" class="com.sw.gcms.app.bean.sf.RealFlagPro" fetch="select" lazy="false"> <!--
lazy="false" 是用来关闭延迟加载,根据自己的需求调整
--> <column name="CUSBELAREA" length="30" /> </many-to-one> <many-to-one name="realFlagProByCusbeltown" class="com.sw.gcms.app.bean.sf.RealFlagPro" fetch="select" lazy="false"> <column name="CUSBELTOWN" length="30" /> </many-to-one> </class></hibernate-mapping>
RealFlagPro.hbm.xml 因为是单向映射,所以RealFlagPro.hbm.xml不需要做特别的配置就OK。
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.*.RealFlagPro" table="REAL_FLAG_PRO" schema="SF">
<id name="flagcode" type="java.lang.String">
<column name="FLAGCODE" length="30" />
<generator class="assigned" />
</id>
<property name="flagkey" type="java.lang.String">
<column name="FLAGKEY" length="20" not-null="true" />
</property>
<property name="flagcodedes" type="java.lang.String">
<column name="FLAGCODEDES" length="100" not-null="true" />
</property>
<property name="isdeleted" type="java.lang.String">
<column name="ISDELETED" length="1" not-null="true" />
</property>
</class>
</hibernate-mapping>
实体类:CustInfo.java
private String cusid;
private String cusfname;
private String cussname;
private RealFlagPro realFlagProByCustype;
private RealFlagPro realFlagProByCusbelarea;
private RealFlagPro realFlagProByCusbeltown;
//getter 和 setter 方法省略了
页面调用的时候直接通过 CustInfo.realFlagProByCustype.flagcodedes 就可以拿到flagcodedes的值。