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 )