mybatis写法如下:
<insert id="insert1" parameterType="com.model.table1 ">
insert into table1 (clumn1, clumn2, TRACE_NO,
TRACE_TIME, SETTLE_DATE, SETTLE_CURRENCY_CODE,
SETTLE_AMT,SETTLE_YEAR)
values (#{clumn1,jdbcType=VARCHAR}, #{clumn2,jdbcType=VARCHAR},
#{traceNo,jdbcType=VARCHAR},
#{traceTime,jdbcType=VARCHAR},
#{settleDate,jdbcType=VARCHAR},
#{settleCurrencyCode,jdbcType=VARCHAR},
#{settleAmt,jdbcType=DECIMAL},
(select
case
when to_date(to_char(sysdate,'yyyy')||'0112','yyyyMMdd')>sysdate
then to_char(sysdate-12,'yyyy')
else to_char(sysdate,'yyyy')
end from dual)
)
</insert>
记录一下