台站管理

lxw

2022-09-09 780e7c8ee91fccc72582e1c526fe0c38f0b1e2f3

台站管理

 src/main/java/com/whyc/controller/StationController.java

New file
@@ -0,0 +1,24 @@
package com.whyc.controller;

import com.whyc.dto.Response;
import com.whyc.service.StationService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

@Api(tags = "树状列表")
@RestController
@RequestMapping("station")
public class StationController {
    @Autowired
    private StationService service;

    @ApiOperation(value = "查询台站列表")
    @GetMapping("getStation")
    public Response getStation(){
        return  service.getStation();
    }
}

 src/main/java/com/whyc/dto/Station/StationName1.java

New file
@@ -0,0 +1,12 @@
package com.whyc.dto.Station;

import lombok.Data;

import java.io.Serializable;
import java.util.List;

@Data
public class StationName1 implements Serializable {
    private String station1;
    private List<StationName2> sName2s;
}

 src/main/java/com/whyc/dto/Station/StationName2.java

New file
@@ -0,0 +1,12 @@
package com.whyc.dto.Station;

import lombok.Data;

import java.io.Serializable;
import java.util.List;
@Data
public class StationName2 implements Serializable {
    private String station1;
    private String station2;
    private List<StationName3> sName3s;
}

 src/main/java/com/whyc/dto/Station/StationName3.java

New file
@@ -0,0 +1,12 @@
package com.whyc.dto.Station;

import lombok.Data;

import java.io.Serializable;
@Data
public class StationName3 implements Serializable {
    private String station1;
    private String station2;
    private String station3;
    private String stationId;
}

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

New file
@@ -0,0 +1,10 @@
package com.whyc.mapper;

import com.whyc.dto.Station.StationName1;

import java.util.List;

public interface StationMapper extends CustomMapper<StationName1>{
    //查询台站列表
    List getStation();
}

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

New file
@@ -0,0 +1,20 @@
package com.whyc.service;

import com.whyc.dto.Response;
import com.whyc.mapper.StationMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class StationService {
    @Autowired(required = false)
    private StationMapper mapper;

    //查询台站列表
    public Response getStation() {
        List list=mapper.getStation();
        return new Response().setII(1,list.size()>0,list,"台站列表");
    }
}

 src/main/resources/mapper/StationMapper.xml

New file
@@ -0,0 +1,35 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.whyc.mapper.StationMapper">
    <resultMap id="stationList" type="StationName1">
        <result property="station1" column="station_name1" ></result>
        <collection property="sName2s" javaType="java.util.ArrayList" ofType="com.whyc.dto.Station.StationName2" column="{station1=station_name1}" select="selectSName2">
        </collection>
    </resultMap>
    <select id="getStation" resultMap="stationList">
        SELECT distinct station_name1 from db_res_meter.tb_station_info
    </select>

    <resultMap id="name2List" type="StationName2">
        <result property="station1" column="station1"></result>
        <result property="station2" column="station_name2" ></result>
        <collection property="sName3s" javaType="java.util.ArrayList" ofType="com.whyc.dto.Station.StationName3" column="{station1=station1,station2=station_name2}" select="selectSName3">
        </collection>
    </resultMap>
    <select id="selectSName2" resultMap="name2List">
        SELECT distinct #{station1} as station1,station_name2 from db_res_meter.tb_station_info
        where station_name1=#{station1} and station_name2!="-"
    </select>

    <resultMap id="name3List" type="StationName3">
        <result property="station1" column="station1"></result>
        <result property="station2" column="station2" ></result>
        <result property="station3" column="station_name3" ></result>
        <result property="stationId" column="station_id" ></result>
    </resultMap>
    <select id="selectSName3" resultMap="name3List">
        SELECT distinct #{station1} as station1, #{station2} as station2,station_name3,station_id from db_res_meter.tb_station_info
        where station_name1=#{station1} and station_name2=#{station2}
        and station_name3!="-"
    </select>
</mapper>