获取dbid

13693261870

2024-09-12 41a12f703f20dcd1eb88602cd0f49837968051b6

获取dbid

 src/main/java/com/se/simu/config/Knife4jConfig.java

@@ -5,6 +5,8 @@
import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.web.servlet.config.annotation.ResourceHandlerRegistry;
import org.springframework.web.servlet.config.annotation.WebMvcConfigurationSupport;
import springfox.documentation.builders.ApiInfoBuilder;
import springfox.documentation.builders.PathSelectors;
import springfox.documentation.builders.RequestHandlerSelectors;
@@ -21,7 +23,7 @@
 */
@Configuration
@EnableKnife4j
public class Knife4jConfig {
public class Knife4jConfig extends WebMvcConfigurationSupport {
    @Value("${server.port}")
    String serverPort;

@@ -34,6 +36,17 @@
    @Value("${server.servlet.context-path}")
    String contextPath;

    @Override
    public void addResourceHandlers(ResourceHandlerRegistry registry) {
        registry.addResourceHandler("doc.html")
                .addResourceLocations("classpath:/META-INF/resources/");

        registry.addResourceHandler("swagger-ui.html")
                .addResourceLocations("classpath:/META-INF/resources/");
        registry.addResourceHandler("/webjars/**")
                .addResourceLocations("classpath:/META-INF/resources/webjars/");
    }

    @Bean
    public Docket createRestApi() {
        return new Docket(new DocumentationType("openApi", "3.0"))

 src/main/java/com/se/simu/controller/WaterController.java

@@ -3,6 +3,8 @@
import com.se.simu.helper.WebHelper;
import com.se.simu.service.SedbService;
import com.se.simu.service.WaterService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import lombok.extern.slf4j.Slf4j;
import org.springframework.http.HttpStatus;
import org.springframework.web.bind.annotation.GetMapping;
@@ -19,6 +21,7 @@
 * @author WWW
 * @date   2024-07-16
 */
@Api(tags = "内涝控制器")
@Slf4j
@RestController
@RequestMapping("/waterlogging")
@@ -35,17 +38,13 @@

    private final static long Y2000 = 949334400000L;

    /**
     * 获取当前时间
     */
    @ApiOperation(value = "获取当前时间")
    @GetMapping("/getTime")
    public Object getTime() {
        return System.currentTimeMillis();
    }

    /**
     * 获取元数据信息
     */
    @ApiOperation(value = "获取元数据信息")
    @GetMapping("/{serviceName}/layer.json")
    public void getLayer(@PathVariable String serviceName, HttpServletResponse res) {
        try {
@@ -62,9 +61,7 @@
        }
    }

    /**
     * 获取地形高度图
     */
    @ApiOperation(value = "获取地形高度图")
    @GetMapping("/{serviceName}/terrain")
    public void getTerraMap(@PathVariable String serviceName, Integer width, Integer height, HttpServletResponse res) {
        try {
@@ -81,9 +78,7 @@
        }
    }

    /**
     * 获取水面高度图
     */
    @ApiOperation(value = "获取水面高度图")
    @GetMapping("/{serviceName}/waterMap")
    public void getWaterMap(@PathVariable String serviceName, Integer width, Integer height, Long timestamp, HttpServletResponse res) {
        try {
@@ -100,9 +95,7 @@
        }
    }

    /**
     * 获取水流向流速图
     */
    @ApiOperation(value = "获取水流向流速图")
    @GetMapping("/{serviceName}/flowMap")
    public void getFlowMap(@PathVariable String serviceName, Integer width, Integer height, Long timestamp, HttpServletResponse res) {
        try {
@@ -151,8 +144,9 @@
        return true;
    }

    @ApiOperation(value = "* 测试 *")
    @GetMapping("/test")
    public Object test() {
        return sedbService.getToken();
        return sedbService.test();
    }
}

 src/main/java/com/se/simu/service/SedbService.java

@@ -1,5 +1,6 @@
package com.se.simu.service;

import cn.hutool.json.JSONArray;
import cn.hutool.json.JSONObject;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Value;
@@ -7,6 +8,8 @@
import org.springframework.web.client.RestTemplate;

import javax.annotation.Resource;
import java.util.HashMap;
import java.util.Map;

/**
 * SDDB服务类
@@ -17,8 +20,8 @@
@Slf4j
@Service
public class SedbService {
    @Value("${sedb.url}")
    String url;
    @Value("${sedb.host}")
    String host;

    @Value("${sedb.user}")
    String user;
@@ -29,20 +32,49 @@
    @Resource
    RestTemplate restTemplate;

    public String getToken() {
        //http://106.120.22.26:8013/account-service/security/publickey
        String key = getPublicKey();
    public String test() {
        String token = getToken();
        String dbid = getDbId(token);

        System.out.println(dbid);

        return key;
        return dbid;
    }

    public String getPublicKey() {
        String uri = url + "account-service/security/publickey";

        //{"datetime":"2024-09-12 17:24:38","code":200,"data":"MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCtFwJCh2taVTEi05C8qT2oG7Y+rDmJhlO4zicpSeRtiro9LsytePeWI7BXM6sfDU0WeKun1izawcfgGkZgnoJuMBluAOKI1tL0uCrR+DreNLqMVtnXHwoWEIk/hGJedDWaf3q22aGDyEB5h9qCq0JklSShP1Ih4ppap4LmgxdTPQIDAQAB"}
        JSONObject obj = restTemplate.getForObject(uri, JSONObject.class);
        JSONObject obj = restTemplate.getForObject(host + "account-service/security/publickey", JSONObject.class);

        return obj.getStr("data");
    }

    public String getToken() {
        String key = getPublicKey();

        Map<String, Object> map = new HashMap<>(2);
        map.put("userid", user);
        map.put("password", pwd);

        JSONObject obj = restTemplate.postForObject(host + "account-service/security/login", map, JSONObject.class);

        JSONObject data = obj.getJSONObject("data");

        return data.getStr("token");
    }

    public String getDbId(String token) {
        Map<String, Object> map = new HashMap<>(1);
        map.put("token", token);

        JSONObject obj = restTemplate.postForObject(host + "geo-service/entitydb/list/canview", map, JSONObject.class);

        JSONArray arr = obj.getJSONArray("data");
        if (null == arr || arr.size() == 0) {
            return null;
        }

        JSONObject dbObj = arr.getJSONObject(0);

        return dbObj.getStr("dbid");
    }
}

 src/main/resources/application.yml

@@ -15,6 +15,14 @@
  config-location: classpath:mybatis.xml
  mapper-locations: classpath:mapper/**/*.xml

knife4j:
  # 是否开启
  enabled: true
  # 请求前缀
  pathMapping:
  # 是否开启增强模式
  enable: true

pagehelper:
  autoDialect: true
  autoRuntimeDialect: true
@@ -34,6 +42,7 @@
    data: D:\simu

sedb:
  url: http://106.120.22.26:8013/
  host: http://106.120.22.26:8013/
  user: WUWEIWEI
  pwd: WUWEIWEI
  #pwd: WUWEIWEI
  pwd: cDS4uMRTR2urgQDNpwkZhpnlzel+R3S9ChDlzk/UmcN8V5n30NwY4iJ9s8DtKr0oUdE7tQ3M+OZlYupw201unqxtUadiyCAme0F3W6eMvB5qanY0nao54TldiZJcIAlB1wqQgh9LinDILS4dRHy3jmwvc+5cOKMvy8WLJ3LZa4A=