Shain用マッピング・ファイル(public_SHAIN_SqlMap.xml)修正箇所抜粋
 |
// 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>
|
|
 |