Mybatis读取oracle的CLOB类型字段
<resultMap type="java.util.HashMap" id="partyVoiceMap">
<result property="content" column="CONTENT" javaType="java.lang.String" jdbcType="CLOB" />
<result property="contenttxt" column="CONTENTTXT" javaType="java.lang.String" jdbcType="CLOB" />
</resultMap>
在返回值那边使用
<select id="getPartyNewsDetail" resultType="java.util.HashMap" resultMap="partyVoiceMap">
select t.*, d.name dictname from PB_PARTY_NEWS t left join PB_PARTY_NEWS_TYPE d on d.id = t.TYPE where t.id = #{newsId}
</select>
网友评论