苍穹外卖--启用禁用员工账号

Controller层

 @ApiOperation("启用禁用员工账号")
    @PostMapping("/status/{status}")
    public Result tartOrClose(@PathVariable Integer status, Long id){
        employeeService.StartOrClose(status,id);
        return Result.success();
    }

Service层

@Override
    public void StartOrClose(Integer status, Long id) {
        Employee employee= Employee.builder()
                .status(status)
                .id(id).build();
        employeeMapper.update(employee);
    }

Mapper层

 void update(Employee employee);

在 EmployeeMapper.xml 中编写SQL：

<update id="update">
        update employee
        <set>
            <if test="name != null">name = #{name},</if>
            <if test="username != null">username = #{username},</if>
            <if test="password != null">password = #{password},</if>
            <if test="phone != null">phone = #{phone},</if>
            <if test="sex != null">sex = #{sex},</if>
            <if test="idNumber != null">id_Number = #{idNumber},</if>
            <if test="updateTime != null">update_Time = #{updateTime},</if>
            <if test="updateUser != null">update_User = #{updateUser},</if>
            <if test="status != null">status = #{status},</if>
        </set>
        where id = #{id}

    </update>