mybatis在mysql中保存大附件_mybatis用法(三)mybatis保存CLOB类型到oracle数据库实例

POOL_PK_NO,BIG_DATA,CREATE_TIME,UPDATE_TIME

select

from WMS_IN_POOL

where POOL_PK_NO = #{poolPkNo,jdbcType=DECIMAL}

delete from WMS_IN_POOL

where POOL_PK_NO = #{poolPkNo,jdbcType=DECIMAL}

SELECT nvl(max(POOL_PK_NO),0)+1 from WMS_IN_POOL

insert into WMS_IN_POOL (POOL_PK_NO,BIG_DATA,CREATE_TIME,UPDATE_TIME)

values (

#{poolPkNo,jdbcType=DECIMAL},#{bigData,jdbcType=CLOB},

#{createTime,jdbcType=TIMESTAMP},#{updateTime,jdbcType=TIMESTAMP}

)

insert into WMS_IN_POOL

POOL_PK_NO,

BIG_DATA,

CREATE_TIME,

UPDATE_TIME,

#{poolPkNo,jdbcType=DECIMAL},

#{bigData,jdbcType=CLOB},

#{createTime,jdbcType=TIMESTAMP},

#{updateTime,jdbcType=TIMESTAMP},

update WMS_IN_POOL

BIG_DATA = #{bigData,jdbcType=CLOB},

UPDATE_