Shain用マッピング・ファイル（public_SHAIN


			// resultMap要素

			<resultMap id="abatorgenerated_ShainResult" class="dto.Shain">

			    <result column="SHAIN_ID" property="shainId" jdbcType="INTEGER" />

			    <result column="SHAIN_NAME" property="shainName" jdbcType="VARCHAR" />

			    <result column="BUSHO_ID" property="busho.bushoId" jdbcType="INTEGER" />

			    <result column="BUSHO_NAME" property="busho.bushoName" jdbcType="VARCHAR" />

			    <result column="EXTENSION_NUM" property="busho.extensionNum" jdbcType="INTEGER" />

			</resultMap>


			// 内部結合用SQL文の追加

			<select id="getShains" resultMap="abatorgenerated_ShainResult" parameterClass="dto.ShainKey">

			    select *

			    from SHAIN, BUSHO

			    WHERE SHAIN.BUSHO_ID = BUSHO.BUSHO_ID

			    AND SHAIN_ID = #shainId#

			</select>