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">

<hibernate-mapping package="com.sf.integration.uploadttidentrsfullup.domain" auto-import="true">
    <class name="IdentRsFull" table="TT_IDENT_RS_FULL">
        <id name="id" type="java.lang.Long">
            <column name="id" precision="20" scale="0" />
            <generator class="sequence">
            <param name="sequence">seq_tt_ident_rs_full</param>
            </generator>
        </id>
        <property name="waybillNo" type="java.lang.String">
            <column name="WAYBILL_NO" length="32" />
        </property>
        <property name="src" type="java.lang.String">
            <column name="SRC" length="10" />
        </property>
        <property name="otherNodeFlg" type="java.lang.Integer">
            <column name="OTHER_NODE_FLG"/>
        </property>
        <property name="transZno" type="java.lang.String">
            <column name="TRANS_ZNO" length="20" />
        </property>
        <property name="srcZno" type="java.lang.String">
            <column name="SRC_ZNO" length="30" />
        </property>
        <property name="originDesZno" type="java.lang.String">
            <column name="ORIGIN_DES_ZNO" length="30" />
        </property>
        <property name="identDesCity" type="java.lang.String">
            <column name="IDENT_DES_CITY" length="30" />
        </property>
        <property name="identDesOutZno" type="java.lang.String">
            <column name="IDENT_DES_OUT_ZNO" length="30" />
        </property>
        <property name="identDesAreaZno" type="java.lang.String">
            <column name="IDENT_DES_AREA_ZNO" length="30" />
        </property>
        <property name="identDesZno" type="java.lang.String">
            <column name="IDENT_DES_ZNO" length="30" />
        </property>
        <property name="identDesTeamZno" type="java.lang.String">
            <column name="IDENT_DES_TEAM_ZNO" length="30" />
        </property>
        <property name="originsIdentDesZno" type="java.lang.String">
            <column name="ORIGINS_IDENT_DES_ZNO" length="30" />
        </property>
        <property name="identDesZnoMapbef" type="java.lang.String">
            <column name="IDENT_DES_ZNO_MAPBEF" length="30" />
        </property>
        <property name="areaDesZnoMap" type="java.lang.String">
            <column name="AREA_DES_ZNO_MAP" length="30" />
        </property>
        <property name="normalDesZno" type="java.lang.String">
            <column name="NORMAL_DES_ZNO" length="30" />
        </property>
        <property name="productType" type="java.lang.String">
            <column name="PRODUCT_TYPE" length="30" />
        </property>
        <property name="detailInfo" type="java.lang.String">
            <column name="DETAIL_INFO" length="30" />
        </property>
        <property name="weight" type="java.lang.Double">
            <column name="WEIGHT" precision="20" scale="3" />
        </property>
        <property name="bgType" type="java.lang.Integer">
            <column name="BG_TYPE" precision="3" scale="0" />
        </property>
        <property name="isDeadwFlg" type="java.lang.Integer">
            <column name="IS_DEADW_FLG" precision="3" scale="0" />
        </property>
        <property name="dealFlg" type="java.lang.Integer">
            <column name="DEAL_FLG" precision="3" scale="0" />
        </property>
        <property name="dealTm" type="java.util.Date">
            <column name="DEAL_TM" />
        </property>
        <property name="dealIp" type="java.lang.String">
            <column name="DEAL_IP" length="20" />
        </property>
        <property name="dealCount" type="java.lang.Integer">
            <column name="DEAL_COUNT" precision="3" scale="0"/>
        </property>
        <property name="status" type="java.lang.String">
            <column name="STATUS" length="10" />
        </property>
        <property name="srcDeliveCode" type="java.lang.String">
            <column name="SRC_DELIVE_CODE" length="30" />
        </property>
        <property name="deliveCode" type="java.lang.String">
            <column name="DELIVE_CODE" length="30" />
        </property>
        <property name="insertTm" type="java.sql.Timestamp">
            <column name="INSERT_TM" />
        </property>
        <property name="scanTm" type="java.sql.Timestamp">
            <column name="SCAN_TM" />
        </property>
        <property name="updateTm" type="java.sql.Timestamp">
            <column name="UPDATE_TM" />
        </property>
        <property name="specialConfigId" type="java.lang.String">
            <column name="SPECIAL_CONFIG_ID" length="30" />
        </property>
        <property name="haveSpecialMapping" type="java.lang.Boolean">
            <column name="HAVE_SPECIAL_MAPPING" />
        </property>
        <property name="specialTypeEscape" type="java.lang.Long">
            <column name="SPECIAL_TYPE_ESCAPE" length="22"/>
        </property>
        <property name="specialType" type="java.lang.String">
            <column name="SPECIAL_TYPE" length="50" />
        </property>
        <property name="val" type="java.lang.Double">
            <column name="VAL" precision="20" scale="5"/>
        </property>
        <property name="identStatus" type="java.lang.Integer">
            <column name="IDENT_STATUS" length="3"/>
        </property>
        <property name="opr" type="java.lang.String">
            <column name="OPR" length="20"/>
        </property>
        <property name="fullTel" type="java.lang.String">
			<column name="FULL_TEL" length="30"/>
		</property>
		<property name="srcTel" type="java.lang.String">
			<column name="SRC_TEL" length="30"/>
		</property>
		<property name="opTm" type="java.sql.Timestamp">
			<column name="OP_TM" />
		</property>
        <property name="instTm" type="java.sql.Timestamp">
            <column name="INST_TM" />
        </property>
        <property name="extendattach1" type="java.lang.String">
            <column name="EXTENDATTACH1" length="1000"/>
        </property>
        <property name="extendattach2" type="java.lang.String">
            <column name="EXTENDATTACH2" length="1000"/>
        </property>
        <property name="extendattach3" type="java.lang.String">
            <column name="EXTENDATTACH3" length="1000"/>
        </property>
        <property name="extendattach4" type="java.lang.String">
            <column name="EXTENDATTACH4" length="1000"/>
        </property>
        <property name="extendattach5" type="java.lang.String">
            <column name="EXTENDATTACH5" length="1000"/>
        </property>
        <property name="extendattach6" type="java.lang.String">
            <column name="EXTENDATTACH6" length="1000"/>
        </property>
        <property name="extendattach7" type="java.lang.String">
            <column name="EXTENDATTACH7" length="1000"/>
        </property>
        <property name="extendattach8" type="java.lang.String">
            <column name="EXTENDATTACH8" length="1000"/>
        </property>
        <property name="extendattach9" type="java.lang.String">
            <column name="EXTENDATTACH9" length="1000"/>
        </property>
        <property name="extendattach10" type="java.lang.String">
            <column name="EXTENDATTACH10" length="1000"/>
        </property>
    </class>
    
    <class name="TtIdentRsFullLog" table="TL_IDENT_RS_FULL">
        <id name="id" type="java.lang.Long">
            <column name="id" precision="20" scale="0" />
            <generator class="sequence">
            <param name="sequence">seq_tl_ident_rs_full</param>
            </generator>
        </id>
        <property name="waybillNo" type="java.lang.String">
            <column name="WAYBILL_NO" length="32" />
        </property>
        <property name="src" type="java.lang.String">
            <column name="SRC" length="10" />
        </property>
        <property name="otherNodeFlg" type="java.lang.Integer">
            <column name="OTHER_NODE_FLG"/>
        </property>
        <property name="transZno" type="java.lang.String">
            <column name="TRANS_ZNO" length="20" />
        </property>
        <property name="srcZno" type="java.lang.String">
            <column name="SRC_ZNO" length="30" />
        </property>
        <property name="originDesZno" type="java.lang.String">
            <column name="ORIGIN_DES_ZNO" length="30" />
        </property>
        <property name="identDesCity" type="java.lang.String">
            <column name="IDENT_DES_CITY" length="30" />
        </property>
        <property name="identDesOutZno" type="java.lang.String">
            <column name="IDENT_DES_OUT_ZNO" length="30" />
        </property>
        <property name="identDesAreaZno" type="java.lang.String">
            <column name="IDENT_DES_AREA_ZNO" length="30" />
        </property>
        <property name="identDesZno" type="java.lang.String">
            <column name="IDENT_DES_ZNO" length="30" />
        </property>
        <property name="identDesTeamZno" type="java.lang.String">
            <column name="IDENT_DES_TEAM_ZNO" length="30" />
        </property>
        <property name="originsIdentDesZno" type="java.lang.String">
            <column name="ORIGINS_IDENT_DES_ZNO" length="30" />
        </property>
        <property name="identDesZnoMapbef" type="java.lang.String">
            <column name="IDENT_DES_ZNO_MAPBEF" length="30" />
        </property>
        <property name="areaDesZnoMap" type="java.lang.String">
            <column name="AREA_DES_ZNO_MAP" length="30" />
        </property>
        <property name="normalDesZno" type="java.lang.String">
            <column name="NORMAL_DES_ZNO" length="30" />
        </property>
        <property name="productType" type="java.lang.String">
            <column name="PRODUCT_TYPE" length="30" />
        </property>
        <property name="detailInfo" type="java.lang.String">
            <column name="DETAIL_INFO" length="30" />
        </property>
        <property name="weight" type="java.lang.Double">
            <column name="WEIGHT" precision="20" scale="3" />
        </property>
        <property name="bgType" type="java.lang.Integer">
            <column name="BG_TYPE" precision="3" scale="0" />
        </property>
        <property name="isDeadwFlg" type="java.lang.Integer">
            <column name="IS_DEADW_FLG" precision="3" scale="0" />
        </property>
        <property name="dealFlg" type="java.lang.Integer">
            <column name="DEAL_FLG" precision="3" scale="0" />
        </property>
        <property name="dealTm" type="java.util.Date">
            <column name="DEAL_TM" />
        </property>
        <property name="dealIp" type="java.lang.String">
            <column name="DEAL_IP" length="20" />
        </property>
        <property name="dealCount" type="java.lang.Integer">
            <column name="DEAL_COUNT" precision="3" scale="0"/>
        </property>
        <property name="status" type="java.lang.String">
            <column name="STATUS" length="10" />
        </property>
        <property name="srcDeliveCode" type="java.lang.String">
            <column name="SRC_DELIVE_CODE" length="30" />
        </property>
        <property name="deliveCode" type="java.lang.String">
            <column name="DELIVE_CODE" length="30" />
        </property>
        <property name="insertTm" type="java.sql.Timestamp">
            <column name="INSERT_TM" />
        </property>
        <property name="scanTm" type="java.sql.Timestamp">
            <column name="SCAN_TM" />
        </property>
        <property name="specialConfigId" type="java.lang.String">
            <column name="SPECIAL_CONFIG_ID" length="30" />
        </property>
        <property name="haveSpecialMapping" type="java.lang.Boolean">
            <column name="HAVE_SPECIAL_MAPPING" />
        </property>
        <property name="specialTypeEscape" type="java.lang.Long">
            <column name="SPECIAL_TYPE_ESCAPE" length="22"/>
        </property>
        <property name="specialType" type="java.lang.String">
            <column name="SPECIAL_TYPE" length="50" />
        </property>
        <property name="val" type="java.lang.Double">
            <column name="VAL" precision="20" scale="5"/>
        </property>
        <property name="identStatus" type="java.lang.Integer">
            <column name="IDENT_STATUS" length="3"/>
        </property>
        <property name="opr" type="java.lang.String">
            <column name="OPR" length="20"/>
        </property>
        <property name="fullTel" type="java.lang.String">
			<column name="FULL_TEL" length="30"/>
		</property>
		<property name="srcTel" type="java.lang.String">
			<column name="SRC_TEL" length="30"/>
		</property>
		<property name="opTm" type="java.sql.Timestamp">
			<column name="OP_TM" />
		</property>
        <property name="instTm" type="java.sql.Timestamp">
            <column name="INST_TM" />
        </property>
        <property name="extendattach1" type="java.lang.String">
            <column name="EXTENDATTACH1" length="1000"/>
        </property>
        <property name="extendattach2" type="java.lang.String">
            <column name="EXTENDATTACH2" length="1000"/>
        </property>
        <property name="extendattach3" type="java.lang.String">
            <column name="EXTENDATTACH3" length="1000"/>
        </property>
        <property name="extendattach4" type="java.lang.String">
            <column name="EXTENDATTACH4" length="1000"/>
        </property>
        <property name="extendattach5" type="java.lang.String">
            <column name="EXTENDATTACH5" length="1000"/>
        </property>
        <property name="extendattach6" type="java.lang.String">
            <column name="EXTENDATTACH6" length="1000"/>
        </property>
        <property name="extendattach7" type="java.lang.String">
            <column name="EXTENDATTACH7" length="1000"/>
        </property>
        <property name="extendattach8" type="java.lang.String">
            <column name="EXTENDATTACH8" length="1000"/>
        </property>
        <property name="extendattach9" type="java.lang.String">
            <column name="EXTENDATTACH9" length="1000"/>
        </property>
        <property name="extendattach10" type="java.lang.String">
            <column name="EXTENDATTACH10" length="1000"/>
        </property>
        <property name="info" type="java.lang.String">
            <column name="info" length="1000"/>
        </property>
    </class>
    
    <class name="IdentRsFullMid" table="TT_IDENT_RS_FULL_MID">
        <id name="id" type="java.lang.Long">
            <column name="id" precision="20" scale="0" />
            <generator class="sequence">
            <param name="sequence">seq_tt_ident_rs_full</param>
            </generator>
        </id>
        <property name="waybillNo" type="java.lang.String">
            <column name="WAYBILL_NO" length="32" />
        </property>
        <property name="src" type="java.lang.String">
            <column name="SRC" length="10" />
        </property>
        <property name="otherNodeFlg" type="java.lang.Integer">
            <column name="OTHER_NODE_FLG"/>
        </property>
        <property name="transZno" type="java.lang.String">
            <column name="TRANS_ZNO" length="20" />
        </property>
        <property name="srcZno" type="java.lang.String">
            <column name="SRC_ZNO" length="30" />
        </property>
        <property name="originDesZno" type="java.lang.String">
            <column name="ORIGIN_DES_ZNO" length="30" />
        </property>
        <property name="identDesCity" type="java.lang.String">
            <column name="IDENT_DES_CITY" length="30" />
        </property>
        <property name="identDesOutZno" type="java.lang.String">
            <column name="IDENT_DES_OUT_ZNO" length="30" />
        </property>
        <property name="identDesAreaZno" type="java.lang.String">
            <column name="IDENT_DES_AREA_ZNO" length="30" />
        </property>
        <property name="identDesZno" type="java.lang.String">
            <column name="IDENT_DES_ZNO" length="30" />
        </property>
        <property name="identDesTeamZno" type="java.lang.String">
            <column name="IDENT_DES_TEAM_ZNO" length="30" />
        </property>
        <property name="originsIdentDesZno" type="java.lang.String">
            <column name="ORIGINS_IDENT_DES_ZNO" length="30" />
        </property>
        <property name="identDesZnoMapbef" type="java.lang.String">
            <column name="IDENT_DES_ZNO_MAPBEF" length="30" />
        </property>
        <property name="areaDesZnoMap" type="java.lang.String">
            <column name="AREA_DES_ZNO_MAP" length="30" />
        </property>
        <property name="normalDesZno" type="java.lang.String">
            <column name="NORMAL_DES_ZNO" length="30" />
        </property>
        <property name="productType" type="java.lang.String">
            <column name="PRODUCT_TYPE" length="30" />
        </property>
        <property name="detailInfo" type="java.lang.String">
            <column name="DETAIL_INFO" length="30" />
        </property>
        <property name="weight" type="java.lang.Double">
            <column name="WEIGHT" precision="20" scale="3" />
        </property>
        <property name="bgType" type="java.lang.Integer">
            <column name="BG_TYPE" precision="3" scale="0" />
        </property>
        <property name="isDeadwFlg" type="java.lang.Integer">
            <column name="IS_DEADW_FLG" precision="3" scale="0" />
        </property>
        <property name="dealFlg" type="java.lang.Integer">
            <column name="DEAL_FLG" precision="3" scale="0" />
        </property>
        <property name="dealTm" type="java.util.Date">
            <column name="DEAL_TM" />
        </property>
        <property name="dealIp" type="java.lang.String">
            <column name="DEAL_IP" length="20" />
        </property>
        <property name="dealCount" type="java.lang.Integer">
            <column name="DEAL_COUNT" precision="3" scale="0"/>
        </property>
        <property name="status" type="java.lang.String">
            <column name="STATUS" length="10" />
        </property>
        <property name="srcDeliveCode" type="java.lang.String">
            <column name="SRC_DELIVE_CODE" length="30" />
        </property>
        <property name="deliveCode" type="java.lang.String">
            <column name="DELIVE_CODE" length="30" />
        </property>
        <property name="insertTm" type="java.sql.Timestamp">
            <column name="INSERT_TM" />
        </property>
        <property name="scanTm" type="java.sql.Timestamp">
            <column name="SCAN_TM" />
        </property>
        <property name="updateTm" type="java.sql.Timestamp">
            <column name="UPDATE_TM" />
        </property>
        <property name="specialConfigId" type="java.lang.String">
            <column name="SPECIAL_CONFIG_ID" length="30" />
        </property>
        <property name="haveSpecialMapping" type="java.lang.Boolean">
            <column name="HAVE_SPECIAL_MAPPING" />
        </property>
        <property name="specialTypeEscape" type="java.lang.Long">
            <column name="SPECIAL_TYPE_ESCAPE" length="22"/>
        </property>
        <property name="specialType" type="java.lang.String">
            <column name="SPECIAL_TYPE" length="50" />
        </property>
        <property name="val" type="java.lang.Double">
            <column name="VAL" precision="20" scale="5"/>
        </property>
        <property name="identStatus" type="java.lang.Integer">
            <column name="IDENT_STATUS" length="3"/>
        </property>
        <property name="opr" type="java.lang.String">
            <column name="OPR" length="20"/>
        </property>
        <property name="fullTel" type="java.lang.String">
			<column name="FULL_TEL" length="30"/>
		</property>
		<property name="srcTel" type="java.lang.String">
			<column name="SRC_TEL" length="30"/>
		</property>
		<property name="opTm" type="java.sql.Timestamp">
			<column name="OP_TM" />
		</property>
        <property name="instTm" type="java.sql.Timestamp">
            <column name="INST_TM" />
        </property>
        <property name="extendattach1" type="java.lang.String">
            <column name="EXTENDATTACH1" length="1000"/>
        </property>
        <property name="extendattach2" type="java.lang.String">
            <column name="EXTENDATTACH2" length="1000"/>
        </property>
        <property name="extendattach3" type="java.lang.String">
            <column name="EXTENDATTACH3" length="1000"/>
        </property>
        <property name="extendattach4" type="java.lang.String">
            <column name="EXTENDATTACH4" length="1000"/>
        </property>
        <property name="extendattach5" type="java.lang.String">
            <column name="EXTENDATTACH5" length="1000"/>
        </property>
        <property name="extendattach6" type="java.lang.String">
            <column name="EXTENDATTACH6" length="1000"/>
        </property>
        <property name="extendattach7" type="java.lang.String">
            <column name="EXTENDATTACH7" length="1000"/>
        </property>
        <property name="extendattach8" type="java.lang.String">
            <column name="EXTENDATTACH8" length="1000"/>
        </property>
        <property name="extendattach9" type="java.lang.String">
            <column name="EXTENDATTACH9" length="1000"/>
        </property>
        <property name="extendattach10" type="java.lang.String">
            <column name="EXTENDATTACH10" length="1000"/>
        </property>
        <property name="dataType" type="java.lang.Integer">
            <column name="DATA_TYPE"/>
        </property>
    </class>
           <class name="Dtx5ForceUpdate" table="tm_dtx5_config">
        <id name="id" type="java.lang.Long">
            <column name="id" precision="18" scale="0" />
            <generator class="sequence">
            <param name="sequence">seq_tm_dtx5_config</param>
            </generator>
        </id>
        <property name="type" type="java.lang.String">
            <column name="TYPE" length="32" />
        </property>
        <property name="versionNumber" type="java.lang.String">
            <column name="VERSION_NUMBER" length="32" />
        </property>
        <property name="deadline" type="java.lang.String">
            <column name="DEADLINE" length="32"/>
        </property>
        <property name="status" type="java.lang.String">
            <column name="STATUS" length="30" />
        </property>
         <property name="deliveCode" type="java.lang.String">
            <column name="DELIVE_CODE" length="1000" />
        </property>
         <property name="transitCode" type="java.lang.String">
            <column name="TRANSIT_CODE" length="4000" />
        </property>
         <property name="dealFlg" type="java.lang.Integer">
            <column name="DEAL_FLG" length="2" />
        </property>
        <property name="createTm" type="java.util.Date">
            <column name="CREATE_TM" />
        </property>
         <property name="dataComment" type="java.lang.String">
            <column name="DATA_COMMENT" length="1000" />
        </property>
        <property name="param1" type="java.lang.String">
          <column name="PARAM_1" length="1000"/>
        </property>
        <property name="param2" type="java.lang.String">
          <column name="PARAM_2" length="1000"/>
        </property>
        <property name="param3" type="java.lang.String">
          <column name="PARAM_3" length="1000"/>
        </property>
        <property name="param4" type="java.lang.String">
          <column name="PARAM_4" length="1000"/>
        </property>
        <property name="param5" type="java.lang.String">
          <column name="PARAM_5" length="1000"/>
        </property>
        <property name="param6" type="java.lang.String">
          <column name="PARAM_6" length="1000"/>
        </property>
        <property name="param7" type="java.lang.String">
          <column name="PARAM_7" length="1000"/>
        </property>
        <property name="param8" type="java.lang.String">
          <column name="PARAM_8" length="1000"/>
        </property>
        <property name="param9" type="java.lang.String">
          <column name="PARAM_9" length="1000"/>
        </property>
        <property name="param10" type="java.lang.String">
          <column name="PARAM_10" length="1000"/>
        </property>
    </class>
    
    <sql-query name="identRsFullMid.update">
	    <![CDATA[
        update TT_IDENT_RS_FULL_MID
           set id                    = seq_tt_ident_rs_full.nextval,
               SRC                   = :src,
               OTHER_NODE_FLG        = :otherNodeFlg,
               SRC_ZNO               = :srcZno,
               ORIGIN_DES_ZNO        = :originDesZno,
               IDENT_DES_CITY        = :identDesCity,
               IDENT_DES_OUT_ZNO     = :identDesOutZno,
               IDENT_DES_AREA_ZNO    = :identDesAreaZno,
               IDENT_DES_ZNO         = :identDesZno,
               IDENT_DES_TEAM_ZNO    = :identDesTeamZno,
               ORIGINS_IDENT_DES_ZNO = :originsIdentDesZno,
               IDENT_DES_ZNO_MAPBEF  = :identDesZnoMapbef,
               AREA_DES_ZNO_MAP      = :areaDesZnoMap,
               NORMAL_DES_ZNO        = :normalDesZno,
               PRODUCT_TYPE          = :productType,
               DETAIL_INFO           = :detailInfo,
               WEIGHT                = :weight,
               BG_TYPE               = :bgType,
               IS_DEADW_FLG          = :isDeadwFlg,
               STATUS               = :status,
               SRC_DELIVE_CODE      = :srcDeliveCode,
               DELIVE_CODE          = :deliveCode,
               SCAN_TM              = :scanTm,
               UPDATE_TM            = current_timestamp,
               SPECIAL_CONFIG_ID    = :specialConfigId,
               HAVE_SPECIAL_MAPPING = :haveSpecialMapping,
               SPECIAL_TYPE_ESCAPE  = :specialTypeEscape,
               SPECIAL_TYPE         = :specialType,
               VAL                  = :val,
               IDENT_STATUS         = :identStatus,
               OPR                  = :opr,
               FULL_TEL             = :fullTel,
               SRC_TEL              = :srcTel,
               OP_TM                = :opTm,
               INST_TM              = :instTm,
               EXTENDATTACH1        = :extendattach1,
               EXTENDATTACH2        = :extendattach2,
               EXTENDATTACH3        = :extendattach3,
               EXTENDATTACH4        = :extendattach4,
               EXTENDATTACH5        = :extendattach5,
               EXTENDATTACH6        = :extendattach6,
               EXTENDATTACH7        = :extendattach7,
               EXTENDATTACH8        = :extendattach8,
               EXTENDATTACH9        = :extendattach9,
               EXTENDATTACH10       = :extendattach10
           where WAYBILL_NO = :waybillNo and TRANS_ZNO = :transZno
	    ]]>
    </sql-query>
</hibernate-mapping>