ID_,NAME_,CODE_,JOB_LEVEL_,DESCRIPTION_,UPDATE_TIME_,IS_DELE_,VERSION_ SELECT * FROM UC_ORG_JOB WHERE CODE_=#{code} AND IS_DELE_!='1' DELETE FROM UC_ORG_JOB WHERE IS_DELE_='1' SELECT * FROM UC_ORG_JOB WHERE NAME_ = #{name} AND IS_DELE_!='1' SELECT count(1) FROM UC_ORG_JOB WHERE CODE_ = #{code} INSERT INTO UC_ORG_JOB ( ID_,NAME_,CODE_,JOB_LEVEL_,DESCRIPTION_,UPDATE_TIME_,IS_DELE_,VERSION_,create_by_,create_time_,create_org_id_ ) VALUES (#{item.id,jdbcType=VARCHAR}, #{item.name,jdbcType=VARCHAR}, #{item.code,jdbcType=VARCHAR}, #{item.postLevel,jdbcType=VARCHAR}, #{item.description,jdbcType=VARCHAR},#{item.updateTime,jdbcType=TIMESTAMP},#{item.isDelete,jdbcType=VARCHAR},#{item.version,jdbcType=NUMERIC},#{item.createBy,jdbcType=VARCHAR},#{item.createTime,jdbcType=TIMESTAMP},#{item.createOrgId,jdbcType=VARCHAR}) INSERT INTO UC_ORG_JOB ( ID_,NAME_,CODE_,JOB_LEVEL_,DESCRIPTION_,UPDATE_TIME_,IS_DELE_,VERSION_,create_by_,create_time_,create_org_id_ ) ( select #{item.id,jdbcType=VARCHAR}, #{item.name,jdbcType=VARCHAR}, #{item.code,jdbcType=VARCHAR}, #{item.postLevel,jdbcType=VARCHAR}, #{item.description,jdbcType=VARCHAR},#{item.updateTime,jdbcType=TIMESTAMP},#{item.isDelete,jdbcType=VARCHAR},#{item.version,jdbcType=NUMERIC},#{item.createBy,jdbcType=VARCHAR},#{item.createTime,jdbcType=TIMESTAMP},#{item.createOrgId,jdbcType=VARCHAR} FROM DUAL )