MyBatis调用oracle的自定义函数

来源：互联网发布：html合并单元格编程题编辑：程序博客网时间：2024/05/22 00:09

fn_no_make这个就是我的方法名字。直接调用传入参数。经过实验证明该方式可行

insert into application        (application_id,        serial_number,        application_type,        applicant,        agent,        process_id,        reason,        createtime,        creater,        updatetime,        updater)        values        (#{applicationId},fn_no_make('app'),        #{applicationType},#{applicant},#{agent},#{processId},#{reason},#{createTime},#{creater},#{updateTime},#{updater})

再继续加深一点
传入参数和使用函数

<insert id="saveResApplication" parameterType="com.asiainfo.modules.pas.bean.ApplicationBean">        insert into application        (application_id,        serial_number,        application_type,        applicant,        agent,        process_id,        reason,        createtime,        creater,        updatetime,        updater)        values        (#{applicationId},fn_no_make(substr(#{applicationId},1,3),'application','serial_number'),        #{applicationType},#{applicant},#{agent},#{processId},#{reason},#{createTime},#{creater},#{updateTime},#{updater})    </insert>

0 0