有3个表,“医院表”,“病种表”形成多对多关系,中间表为“开通表设置”T_HOSPITAL_INFORMATION(医院表):
id
serial_number(医院编号)
....
-----------------
T_FATAL_DISEASES_DIRECTORY(病种表):
id
serial_number(病种编号)
-------------------------
T_FATAL_DISEASES_SET(开通表设置):
id
hospital_number(医院编号)
disease_number(病种编号)映射表已配置<?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">
<!-- 
    Mapping file autogenerated by MyEclipse Persistence Tools
-->
<hibernate-mapping>
    <class name="myclass.database.tablemapping.TFatalDiseasesDirectory" table="T_FATAL_DISEASES_DIRECTORY" schema="SA">
        <id name="id" type="java.lang.Long">
            <column name="ID" precision="20" scale="0" />
            <generator class="sequence">
   <param name="sequence">T_FATAL_DISEASES_DIRECTORY_SEQ</param>
   </generator>
        </id>
        <property name="serialNumber" type="java.lang.String">
            <column name="SERIAL_NUMBER" length="20" />
        </property>
        <property name="name" type="java.lang.String">
            <column name="NAME" length="200" />
        </property>
        <property name="note" type="java.lang.String">
            <column name="NOTE" length="1000" />
        </property>
        <property name="disable" type="java.lang.String">
            <column name="DISABLE" length="1" />
        </property>
        <property name="creatorNumber" type="java.lang.String">
            <column name="CREATOR_NUMBER" length="20" />
        </property>
        <property name="creatorTime" type="java.lang.String">
            <column name="CREATOR_TIME" length="20" />
        </property>
        <property name="modifyNumber" type="java.lang.String">
            <column name="MODIFY_NUMBER" length="20" />
        </property>
        <property name="modifyTime" type="java.lang.String">
            <column name="MODIFY_TIME" length="20" />
        </property>
        <property name="disableNumber" type="java.lang.String">
            <column name="DISABLE_NUMBER" length="20" />
        </property>
        <property name="disableTime" type="java.lang.String">
            <column name="DISABLE_TIME" length="20" />
        </property>
        <set name="fatalDiseasesLimit" table="T_FATAL_DISEASES_LIMIT"
cascade="save-update" inverse="true" lazy="false" where=" disable='0' ">
<key column="SERIAL_NUMBER" property-ref="serialNumber"></key>
<one-to-many
class="myclass.database.tablemapping.TFatalDiseasesLimit" />
</set>
<set name="hospital" table="T_FATAL_DISEASES_SET"
cascade="save-update" inverse="true" lazy="false">
<key column="DISEASE_NUMBER" property-ref="serialNumber"></key>
<many-to-many column="HOSPITAL_NUMBER" property-ref="serialNumber"
class="myclass.database.tablemapping.THospitalInformation" />
</set>
    </class>
</hibernate-mapping>
<?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">
<!-- 
    Mapping file autogenerated by MyEclipse Persistence Tools
-->
<hibernate-mapping>
    <class name="myclass.database.tablemapping.THospitalInformation" table="T_HOSPITAL_INFORMATION" schema="SA">
        <id name="id" type="java.lang.Long">
            <column name="ID" precision="22" scale="0" />
            <generator class="sequence">
   <param name="sequence">T_HOSPITAL_INFORMATION_SEQ</param>
   </generator>
        </id>
        <property name="serialNumber" type="java.lang.String">
            <column name="SERIAL_NUMBER" length="20" />
        </property>
        <property name="name" type="java.lang.String">
            <column name="NAME" length="50" />
        </property>
        <property name="type" type="java.lang.String">
            <column name="TYPE" length="1" />
        </property>
        <property name="provinceNumber" type="java.lang.String">
            <column name="PROVINCE_NUMBER" length="20" />
        </property>
        <property name="cityNumber" type="java.lang.String">
            <column name="CITY_NUMBER" length="20" />
        </property>
        <property name="countyNumber" type="java.lang.String">
            <column name="COUNTY_NUMBER" length="20" />
        </property>
        <property name="townNumber" type="java.lang.String">
            <column name="TOWN_NUMBER" length="20" />
        </property>
        <property name="villageNumber" type="java.lang.String">
            <column name="VILLAGE_NUMBER" length="20" />
        </property>
        <property name="contact" type="java.lang.String">
            <column name="CONTACT" length="50" />
        </property>
        <property name="tel" type="java.lang.String">
            <column name="TEL" length="20" />
        </property>
        <property name="email" type="java.lang.String">
            <column name="EMAIL" length="200" />
        </property>
        <property name="address" type="java.lang.String">
            <column name="ADDRESS" length="200" />
        </property>
        <property name="stop" type="java.lang.String">
            <column name="STOP" length="1" />
        </property>
        <property name="creatorNumber" type="java.lang.String">
            <column name="CREATOR_NUMBER" length="20" />
        </property>
        <property name="creatorTime" type="java.lang.String">
            <column name="CREATOR_TIME" length="20" />
        </property>
        <property name="modifyNumber" type="java.lang.String">
            <column name="MODIFY_NUMBER" length="20" />
        </property>
        <property name="modifyTime" type="java.lang.String">
            <column name="MODIFY_TIME" length="20" />
        </property>
        <property name="stopNumber" type="java.lang.String">
            <column name="STOP_NUMBER" length="20" />
        </property>
        <property name="stopTime" type="java.lang.String">
            <column name="STOP_TIME" length="20" />
        </property>
        <property name="state" type="java.lang.String">
            <column name="STATE" length="1" />
        </property>
        <!-- --> 
        <set name="fatalDiseaseDirectory" table="T_FATAL_DISEASES_SET"
cascade="save-update" inverse="true" lazy="false" where=" disable='0' ">
<key column="HOSPITAL_NUMBER" property-ref="serialNumber"></key>
<many-to-many column="DISEASE_NUMBER" property-ref="serialNumber"
class="myclass.database.tablemapping.TFatalDiseasesDirectory" />
</set>

    </class>
</hibernate-mapping>
两个表都已经创建数据了,医院表有数据:A,B,C; 病种表有数据:01,02,03
我想开通A医院有01,02,03这些病种,如何通过程序新增中间表数据,
最后中间表的数据为:
1 A 01
2 A 02
3 A 03