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>