Mybatis - Mapper文件简练

select

from CEICS_EXECUTION


AND EXECUTION_ID=#{executionId,jdbcType=DECIMAL}
www.2cto.com

AND EXECUTION_NAME like #{executionName,jdbcType=VARCHAR}


AND EXECUTION_ACTIVE like #{executionActive,jdbcType=DECIMAL}


AND REG_DATE=#{regDate,jdbcType=TIMESTAMP}

SELECT nvl(max(EXECUTION_ID),0)+1 as executionId FROM CEICS_EXECUTION

insert into CEICS_EXECUTION (EXECUTION_ID, EXECUTION_NAME, EXECUTION_ACTIVE,
REG_DATE)
values (#{executionId,jdbcType=DECIMAL}, #{executionName,jdbcType=VARCHAR}, #{executionActive,jdbcType=DECIMAL},
#{regDate,jdbcType=TIMESTAMP})