苍穹外卖实战-业务开发-03.启用禁用员工账号

一、接口设计

二、代码开发

1.EmployeeController.java

    /**
     * 启用禁用员工账号
     * @param status
     * @param id
     * @return
     */
    @PostMapping("/status/{status}")
    @ApiOperation("启用禁用员工账号")
    public Result startOrStop(@PathVariable Integer status, Long id){
        log.info("启用禁用员工账号:{},{}",status,id);
        employeeService.startOrStop(status,id);
        return Result.success();
    }

由于status是地址参数，需要加注解@PathVariable

2.EmployeeService.java

    /**
     * 启用禁用员工账号
     * @param status
     * @param id
     * @return
     */
    void startOrStop(Integer status, Long id);

3.EmployeeServiceImpl.java

    public void startOrStop(Integer status,Long id){
        // update employee set status = ? where id = ?

//        Employee employee = new Employee();
//        employee.setStatus(status);
//        employee.setId(id);

        //使用Builder构建器
        Employee employee = Employee.builder()
                .status(status)
                .id(id)
                .build();

        employeeMapper.update(employee);
    }

4.EmployeeMapper.java

    /**
     * 启用禁用员工
     * @param employee
     */
    void update(Employee employee);

5.EmployeeMapper.xml

    <update id="update" parameterType="Employee">
        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>

三、功能测试

1.接口测试 

调试并设置断点

首先在数据库中查看想要禁用的id

打开接口文档并测试（token过期了就重新申请一个或者把过期时间改长）

2.前后端联调

可以看到张三已被禁用

点击启用后也能成功启用