网关添加修改

lxw

2023-12-13 df709b80155d1fd6a1d3fa5a049a3283cc40c68f

网关添加修改

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

@@ -11,4 +11,6 @@
    List<String> getCommType();
    //获取所属网关
    List<String> getGatewayName();
    //查询库中最大的网关
    Integer getMaxGatewayId();
}

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

@@ -49,6 +49,14 @@
    }
    //增加网关
    public Response addGateway(GatewayInf ginf) {
        //查询库中最大的网关
        Integer gatewayId=mapper.getMaxGatewayId();
        if(gatewayId==null){
            gatewayId=10001;
        }else{
            gatewayId+=1;
        }
        ginf.setGatewayId(gatewayId);
        int flag=mapper.insert(ginf);
        return new Response().set(1,flag>0,"增加网关");
    }

 src/main/resources/mapper/GatewayInfMapper.xml

@@ -11,4 +11,7 @@
    <select id="getGatewayName" resultType="java.lang.String">
        select distinct gateway_name from db_ckpwrdev_inf.tb_gateway_inf
    </select>
    <select id="getMaxGatewayId" resultType="java.lang.Integer">
        select max(gateway_id) from db_ckpwrdev_inf.tb_gateway_inf
    </select>
</mapper>