完成成果数据入库(DB)方式，修改DB文件上传接口。

rain

2024-05-09 38f0e3224ddaca7d71eacac0441b559a1bd7cc9a

完成成果数据入库(DB)方式，修改DB文件上传接口。

 src/main/java/com/dji/sample/common/model/ResponseResult.java

@@ -38,6 +38,12 @@
                .message(MESSAGE_SUCCESS)
                .build();
    }
    public static ResponseResult success(int code) {
        return ResponseResult.builder()
                .code(code)
                .message(MESSAGE_SUCCESS)
                .build();
    }

    public static ResponseResult error() {
        return ResponseResult.builder()

 src/main/java/com/dji/sample/territory/controller/TbDkjbxxController.java

@@ -76,23 +76,31 @@
                                     @RequestParam String taskName,
                                     @RequestParam String taskId){
        String workspaceId="4a574db8-4ad3-48f7-9f16-3edbcd8056e1";
        if (file==null){
            return ResponseResult.error("上传文件为空");
        }
        tbDkjbxxService.uploadFile(file);
        List<TbDkjbxxEntity> list = tbDkjbxxService.list();
        shpToDataSourceService.savaInMysql(list, workspaceId,taskId,taskName);
        if (list.size()==0){
            return ResponseResult.error("上传文件数据为空");
        }
        try {
            shpToDataSourceService.savaInMysql(list, workspaceId,taskId,taskName);
        }catch (Exception e){
            return ResponseResult.error("上传db文件的内容格式不匹配");
        }
        return ResponseResult.success("上传成功");
    }



    @PostMapping("/uploadUrl")
    public ResponseResult uploadUrl( @RequestParam String url,
                                     @RequestParam String taskName,
                                     @RequestParam String taskId){
        tbDkjbxxService.uploadUrl(url);
    public ResponseResult uploadUrl( @RequestBody UploadUrlParam param){
        tbDkjbxxService.uploadUrl(param.getDbUrl());
        String workspaceId="4a574db8-4ad3-48f7-9f16-3edbcd8056e1";
        List<TbDkjbxxEntity> list = tbDkjbxxService.list();
        shpToDataSourceService.savaInMysql(list, workspaceId,taskId,taskName);
        return ResponseResult.success("上传成功");
        shpToDataSourceService.savaInMysql(list, workspaceId,param.getTaskId(),param.getTaskName());
        return ResponseResult.success(200);
    }

    /**