<!-- 根据主键查询患者信息、申请单、报告单 -->

<!-- clob字段映射 -->

<resultMap class="java.util.HashMap" id="clobCloumnMap">

    <result property="ORGID" column="ORGID"/>

    <result property="DEVICENUM" column="DEVICENUM"/>

    <result property="YEARS" column="YEARS"/>

    <result property="PARTS" column="PARTS"/>

    <result property="PATIENTNAME" column="PATIENTNAME"/>

    <result property="SEX" column="SEX"/>

    <result property="AGE" column="AGE"/>

    <result property="SUBJECTIVE" column="SUBJECTIVE"/>

    <result property="BL_JWS" column="BL_JWS"/>

    <!-- 报告单 -->

    <result property="REPORT_FILE" column="REPORT_FILE" javaType="java.lang.String" jdbcType="CLOB"/>

    <!-- 申请单 -->

    <result property="APPLICATION_FILE" column="APPLICATION_FILE" javaType="java.lang.String" jdbcType="CLOB"/>

</resultMap>

<select id="getPatientInfo" parameterClass="map" resultMap="clobCloumnMap">

    SELECT

           T.ORGID,

           T.DEVICENUM,

           T.YEARS,

           T.PARTS,

           T.PATIENTNAME,

           T.SEX,

           T.AGE,

           T.SUBJECTIVE,

           T.BL_JWS,

           T.REPORT_FILE,

           T.APPLICATION_FILE

      FROM UPLOAD_IMAGE_INFO T

      WHERE T.ID = #ID#

</select>

相关推荐：

• java 读取clob
• java 数据类型与数据库 数据类型的对应关系
• ibatis 调用存储过程