断路器查用

lxw

2023-12-13 dded10dc3a390e48b97f36413899ffcdacbca45e

断路器查用

 src/main/java/com/whyc/mapper/GatewayInfMapper.java

@@ -1,5 +1,6 @@
package com.whyc.mapper;

import com.whyc.pojo.db_ckpwrdev_inf.BreakerInf;
import com.whyc.pojo.db_ckpwrdev_inf.GatewayInf;

import java.util.List;
@@ -13,4 +14,6 @@
    List<String> getGatewayName();
    //查询库中最大的网关
    Integer getMaxGatewayId();
    //删除之前判断是否被占用
    BreakerInf judgeBreaker(int num);
}

 src/main/java/com/whyc/service/GatewayInfService.java

@@ -69,9 +69,15 @@
    }
    //删除网关
    public Response deleteGateway(int num) {
        //删除之前判断是否被占用
        BreakerInf breakerInf=mapper.judgeBreaker(num);
        if(breakerInf!=null){
            return new Response().set(1,false,"网关被占用,无法删除");
        }else{
        UpdateWrapper wrapper=new UpdateWrapper();
        wrapper.eq("num",num);
        int flag=mapper.delete(wrapper);
        return new Response().set(1,flag>0,"删除网关");
            return new Response().set(1,flag>0?true:false,flag>0?"删除网关成功":"删除网关失败");
        }
    }
}

 src/main/resources/mapper/GatewayInfMapper.xml

@@ -14,4 +14,10 @@
    <select id="getMaxGatewayId" resultType="java.lang.Integer">
        select max(gateway_id) from db_ckpwrdev_inf.tb_gateway_inf
    </select>
    <select id="judgeBreaker" resultType="com.whyc.pojo.db_ckpwrdev_inf.BreakerInf">
        select * from db_ckpwrdev_inf.tb_gateway_inf,db_ckpwrdev_inf.tb_breaker_inf
        where tb_breaker_inf.gateway_id=tb_gateway_inf.gateway_id
        and tb_gateway_inf.num=#{num}
        limit 1
    </select>
</mapper>