mapper改用注释方式

朱俊杰

2022-02-14 54df5df0313f251b8d84b77bbc64e4a8bfe86393

mapper改用注释方式

 src/main/java/com/genersoft/iot/vmp/storager/dao/DeviceChannelMapper.java

@@ -203,5 +203,19 @@
    @Select("SELECT * FROM device_channel WHERE deviceId=#{deviceId} AND status=1")
    List<DeviceChannel> queryOnlineChannelsByDeviceId(String deviceId);

    @Select(" SELECT\n" +
            "        channelId,\n" +
            "        channelId as id,\n" +
            "        deviceId,\n" +
            "        parentId,\n" +
            "        status,\n" +
            "        name as title,\n" +
            "        channelId as \"value\",\n" +
            "        channelId as \"key\",\n" +
            "        channelId,\n" +
            "        longitude,\n" +
            "        latitude\n" +
            "        from device_channel\n" +
            "        where deviceId = #{deviceId}")
    List<DeviceChannelTree> tree(String deviceId);
}

 src/main/java/com/genersoft/iot/vmp/storager/dao/DeviceChannelMapper.xml

File was deleted

 src/main/java/com/genersoft/iot/vmp/vmanager/bean/DeviceChannelTree.java

@@ -28,6 +28,12 @@

    private String parentName;

    private String title;

    private String key;

    private String value;

    /**
     * 子孙节点
     */
@@ -47,4 +53,13 @@
        }
        return this.children;
    }

    @Override
    public Boolean getHasChildren() {
        if (children.size() > 0) {
            return true;
        } else {
            return this.hasChildren;
        }
    }
}