通过高德api查询所有店铺地址信息

2024-06-24 13:28

本文主要是介绍通过高德api查询所有店铺地址信息,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!

通过高德api查询所有店铺地址电话信息

  • 需求:通过高德api查询所有店铺地址信息
  • 需求分析
  • 具体实现
    • 1、申请高德appkey
    • 2、下载types city 字典值
    • 3、具体代码调用

需求:通过高德api查询所有店铺地址信息

需求分析

查询现有高德api发现现有接口关键字搜索API服务地址:

https://developer.amap.com/api/webservice/guide/api/search
参数需要主要参数:key、types、city
其中types city可以查询:
https://developer.amap.com/api/webservice/download

具体实现

1、申请高德appkey

地址:https://console.amap.com/dev/key/app

2、下载types city 字典值

并将字典值解析读取到代码中,如图
在这里插入图片描述

3、具体代码调用

类说明:

Api  调用方法
CityUtil 城市编码查询工具类
ReaderFile 文件读写工具类
Shop 地点实体类
ShopUtil 地点查询工具类

具体代码

package com.gaode;import cn.hutool.core.collection.CollectionUtil;
import com.alibaba.fastjson2.JSON;import java.util.ArrayList;
import java.util.List;/*** 时间:2024/6/21* 描述:*/public class Api {/*** 需要设置自己的apikey*/public static String apiKey = "";public static void main(String[] args)  throws Exception{//查询单个城市List<Shop> AllShopList = new ArrayList<>();List<String> types = ReaderFile.getTypes();List<String> citys = ReaderFile.getCitys();for (int i = 0; i < types.size(); i++) {String type = types.get(i);for (int j = 0; j < citys.size(); j++) {String city = citys.get(i);List<Shop> shopList = ShopUtil.queryShops(city,type);if(CollectionUtil.isNotEmpty(shopList)){AllShopList.addAll(shopList);}if(CollectionUtil.isNotEmpty(AllShopList)){System.out.println(shopList.size());System.out.println(shopList);continue;}}}System.out.println("结束===================");System.out.println("=============="+AllShopList.size());System.out.println(JSON.toJSONString(AllShopList));}public static  List<Shop> queryAll() {List<Shop> shopList = new ArrayList<>();List<String> list = CityUtil.queryCitys();if (CollectionUtil.isNotEmpty(list)) {for (String city : list) {List<Shop> oneShopList = ShopUtil.queryShops(city,null);if (CollectionUtil.isNotEmpty(oneShopList)) {shopList.addAll(oneShopList);}}}return shopList;}
}
package com.gaode;/*** 描述:*/import cn.hutool.json.JSONArray;
import cn.hutool.json.JSONObject;
import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.net.HttpURLConnection;
import java.net.URL;
import java.util.ArrayList;
import java.util.List;public class CityUtil {public static List<String> queryCitys(){String apiKey  = Api.apiKey;List<String> ls = new ArrayList<>();// 获取所有城市列表String cityListUrl = "https://restapi.amap.com/v3/config/district?key=" + apiKey + "&subdistrict=1";String cityListResponse = null;try {cityListResponse = sendGetRequest(cityListUrl);} catch (Exception e) {throw new RuntimeException(e);}JSONObject cityListJson = new JSONObject(cityListResponse);JSONArray cityList = cityListJson.getJSONArray("districts").getJSONObject(0).getJSONArray("districts");for (int i = 0; i < cityList.size(); i++) {JSONObject city = cityList.getJSONObject(i);String cityName = city.get("name", String.class);ls.add(cityName);}return ls;}// 发送GET请求private static String sendGetRequest(String url) throws Exception {StringBuilder response = new StringBuilder();HttpURLConnection connection = null;BufferedReader reader = null;try {URL requestUrl = new URL(url);connection = (HttpURLConnection) requestUrl.openConnection();connection.setRequestMethod("GET");connection.setConnectTimeout(5000);connection.setReadTimeout(5000);reader = new BufferedReader(new InputStreamReader(connection.getInputStream(), "UTF-8"));String line;while ((line = reader.readLine()) != null) {response.append(line);}} finally {if (reader != null) {reader.close();}if (connection != null) {connection.disconnect();}}return response.toString();}
}
package com.gaode;import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;import java.io.FileInputStream;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;/*** 时间:2024/6/23* 描述:*/public class ReaderFile {public static void main(String[] args)throws Exception {System.out.println(getTypes());System.out.println(getCitys());}public static  List<String> getCitys() throws Exception {String filePath = "D:\\workspace\\codeStr\\studyCode\\address\\src\\main\\resources\\citycode.xlsx";FileInputStream file = new FileInputStream(filePath);XSSFWorkbook workbook = new XSSFWorkbook(file);Sheet sheet = workbook.getSheetAt(0); // 获取第一个工作表Map<String,String> map = new HashMap<>();String cellValue = "";List<String> result = new ArrayList<>();try{for (Row row : sheet) {for (Cell cell : row) {int columnIndex = cell.getColumnIndex();String stringCellValue =null;if(columnIndex==2){try{stringCellValue = cell.getStringCellValue();}catch (Exception e){stringCellValue = String.valueOf(cell.getNumericCellValue());}stringCellValue = stringCellValue.replace(".0","");}if(stringCellValue!=null){String substring = stringCellValue;if(!substring.equals("citycode")){map.put(substring,substring);}continue;}}}for (String key : map.keySet()){result.add(key);}}catch (Exception e){System.out.println("==========="+cellValue);e.printStackTrace();}return result;}public static List<String> getTypes() throws Exception {String filePath = "D:\\workspace\\codeStr\\studyCode\\address\\src\\main\\resources\\poi.xlsx";List<String> list = new ArrayList<>();FileInputStream file = new FileInputStream(filePath);XSSFWorkbook workbook = new XSSFWorkbook(file);Sheet sheet = workbook.getSheetAt(0); // 获取第一个工作表Map<String,String> map = new HashMap<>();String cellValue = "";List<String> result = new ArrayList<>();try{for (Row row : sheet) {for (Cell cell : row) {int columnIndex = cell.getColumnIndex();String stringCellValue =null;if(columnIndex==1){try{stringCellValue = cell.getStringCellValue();}catch (Exception e){stringCellValue = String.valueOf(cell.getNumericCellValue());}stringCellValue = stringCellValue.replace(".0","");}if(stringCellValue!=null){String substring = stringCellValue.substring(0, 2);if(!substring.equals("NE")){map.put(substring,substring);}continue;}}}for (String key : map.keySet()){result.add(key);}}catch (Exception e){e.printStackTrace();}return result;}}
package com.gaode;/*** 时间:2024/6/21* 描述:*/import lombok.Data;import java.util.List;@Data
public class Shop {private String pname;private String cityname;private String address;private String type;private String location;private String tel;private String name;
}
package com.gaode;/*** 时间:2024/6/21* 描述:*/import com.alibaba.fastjson2.JSON;
import okhttp3.OkHttpClient;
import okhttp3.Request;
import okhttp3.Response;
import org.json.JSONArray;
import org.json.JSONObject;import java.io.IOException;
import java.util.ArrayList;
import java.util.List;public class ShopUtil {public static  List<Shop>   queryShops(String city,String types) {OkHttpClient client = new OkHttpClient();String apiKey = Api.apiKey;// 设置offset参数来获取更多的数据int pageSize = 100; // 每页显示的POI数量int currentPage = 0; // 当前页码JSONObject poi = null;List<Shop> shopList = new ArrayList<>();while (true) {int offset = currentPage * pageSize;String url = "https://restapi.amap.com/v3/place/text?key=" + apiKey + "&types="+types+"&city=" + city + "&offset=" + offset + "&page=" + (currentPage + 1);
//            String url = "https://restapi.amap.com/v3/place/text?key=" + apiKey +"&offset=" + offset + "&page=" + (currentPage + 1);Request request = new Request.Builder().url(url).build();try (Response response = client.newCall(request).execute()) {if (!response.isSuccessful()) {throw new IOException("Unexpected code " + response);}String responseBody = response.body().string();JSONObject jsonResponse = new JSONObject(responseBody);if (jsonResponse.has("pois")) {JSONArray pois = jsonResponse.getJSONArray("pois");if (pois.length() == 0) {// 如果当前页没有数据,说明已经查询完毕break;}for (int i = 0; i < pois.length(); i++) {poi = pois.getJSONObject(i);Shop shop = new Shop();shop.setPname(JSON.toJSONString(poi.get("pname")));shop.setCityname(JSON.toJSONString(poi.get("cityname")));shop.setAddress(JSON.toJSONString(poi.get("address")));shop.setType(JSON.toJSONString(poi.get("type")));shop.setLocation(JSON.toJSONString(poi.get("location")));shop.setTel(JSON.toJSONString(poi.get("tel")));shop.setName(JSON.toJSONString(poi.getString("name")));shopList.add(shop);}} else {System.out.println("没有找到相关的店铺信息。");break;}currentPage++;} catch (Exception e) {System.out.println("异常信息-----" + JSON.toJSONString(poi));e.printStackTrace();break;}}return shopList;}
}

以上为具体代码
pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"><modelVersion>4.0.0</modelVersion><groupId>org.example</groupId><artifactId>address</artifactId><version>1.0-SNAPSHOT</version><properties><maven.compiler.source>17</maven.compiler.source><maven.compiler.target>17</maven.compiler.target><project.build.sourceEncoding>UTF-8</project.build.sourceEncoding><hutool.version>5.8.22</hutool.version><lombok.version>1.18.26</lombok.version><druid.version>1.1.20</druid.version><mybatis.springboot.version>3.0.2</mybatis.springboot.version><mysql.version>8.0.11</mysql.version><swagger3.version>2.2.0</swagger3.version><mapper.version>4.2.3</mapper.version><fastjson2.version>2.0.40</fastjson2.version><persistence-api.version>1.0.2</persistence-api.version><spring.boot.test.version>3.1.5</spring.boot.test.version><spring.boot.version>3.2.0</spring.boot.version><spring.cloud.version>2023.0.0</spring.cloud.version><spring.cloud.alibaba.version>2022.0.0.0-RC2</spring.cloud.alibaba.version></properties><dependencies><dependency><groupId>com.alibaba</groupId><artifactId>easyexcel</artifactId><version>3.1.1</version></dependency><dependency><groupId>javax.servlet</groupId><artifactId>javax.servlet-api</artifactId><version>4.0.1</version><scope>provided</scope></dependency><dependency><groupId>javax.servlet</groupId><artifactId>javax.servlet-api</artifactId><version>4.0.1</version></dependency><!--SpringCloud consul discovery --><!-- 引入自己定义的api通用包 --><dependency><groupId>com.atguigu.cloud</groupId><artifactId>cloud-api-commons</artifactId><version>1.0-SNAPSHOT</version></dependency><!--SpringBoot集成druid连接池--><!--mybatis和springboot整合--><!--hutool--><dependency><groupId>cn.hutool</groupId><artifactId>hutool-all</artifactId><version>${hutool.version}</version></dependency><!-- fastjson2 --><dependency><groupId>com.alibaba.fastjson2</groupId><artifactId>fastjson2</artifactId><version>${fastjson2.version}</version></dependency><!--lombok--><dependency><groupId>org.projectlombok</groupId><artifactId>lombok</artifactId><version>1.18.28</version><scope>provided</scope></dependency><!--test--><dependency><groupId>org.springdoc</groupId><artifactId>springdoc-openapi-starter-webmvc-ui</artifactId><version>${swagger3.version}</version></dependency><dependency><groupId>com.alibaba.fastjson2</groupId><artifactId>fastjson2</artifactId><version>${fastjson2.version}</version></dependency><!-- 其他依赖项 --><dependency><groupId>com.alibaba</groupId><artifactId>easyexcel</artifactId><version>2.2.11</version></dependency><dependency><groupId>com.squareup.okhttp3</groupId><artifactId>okhttp</artifactId><version>4.9.1</version></dependency><dependency><groupId>org.json</groupId><artifactId>json</artifactId><version>20210307</version></dependency></dependencies></project>

这篇关于通过高德api查询所有店铺地址信息的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!



http://www.chinasem.cn/article/1090277

相关文章

Knife4j+Axios+Redis前后端分离架构下的 API 管理与会话方案(最新推荐)

《Knife4j+Axios+Redis前后端分离架构下的API管理与会话方案(最新推荐)》本文主要介绍了Swagger与Knife4j的配置要点、前后端对接方法以及分布式Session实现原理,... 目录一、Swagger 与 Knife4j 的深度理解及配置要点Knife4j 配置关键要点1.Spri

从入门到精通MySQL联合查询

《从入门到精通MySQL联合查询》:本文主要介绍从入门到精通MySQL联合查询,本文通过实例代码给大家介绍的非常详细,需要的朋友可以参考下... 目录摘要1. 多表联合查询时mysql内部原理2. 内连接3. 外连接4. 自连接5. 子查询6. 合并查询7. 插入查询结果摘要前面我们学习了数据库设计时要满

MySQL查询JSON数组字段包含特定字符串的方法

《MySQL查询JSON数组字段包含特定字符串的方法》在MySQL数据库中,当某个字段存储的是JSON数组,需要查询数组中包含特定字符串的记录时传统的LIKE语句无法直接使用,下面小编就为大家介绍两种... 目录问题背景解决方案对比1. 精确匹配方案(推荐)2. 模糊匹配方案参数化查询示例使用场景建议性能优

mysql表操作与查询功能详解

《mysql表操作与查询功能详解》本文系统讲解MySQL表操作与查询,涵盖创建、修改、复制表语法,基本查询结构及WHERE、GROUPBY等子句,本文结合实例代码给大家介绍的非常详细,感兴趣的朋友跟随... 目录01.表的操作1.1表操作概览1.2创建表1.3修改表1.4复制表02.基本查询操作2.1 SE

MySQL数据库的内嵌函数和联合查询实例代码

《MySQL数据库的内嵌函数和联合查询实例代码》联合查询是一种将多个查询结果组合在一起的方法,通常使用UNION、UNIONALL、INTERSECT和EXCEPT关键字,下面:本文主要介绍MyS... 目录一.数据库的内嵌函数1.1聚合函数COUNT([DISTINCT] expr)SUM([DISTIN

XML重复查询一条Sql语句的解决方法

《XML重复查询一条Sql语句的解决方法》文章分析了XML重复查询与日志失效问题,指出因DTO缺少@Data注解导致日志无法格式化、空指针风险及参数穿透,进而引发性能灾难,解决方案为在Controll... 目录一、核心问题:从SQL重复执行到日志失效二、根因剖析:DTO断裂引发的级联故障三、解决方案:修复

mysql查询使用_rowid虚拟列的示例

《mysql查询使用_rowid虚拟列的示例》MySQL中,_rowid是InnoDB虚拟列,用于无主键表的行ID查询,若存在主键或唯一列,则指向其,否则使用隐藏ID(不稳定),推荐使用ROW_NUM... 目录1. 基本查询(适用于没有主键的表)2. 检查表是否支持 _rowid3. 注意事项4. 最佳实

Python打印对象所有属性和值的方法小结

《Python打印对象所有属性和值的方法小结》在Python开发过程中,调试代码时经常需要查看对象的当前状态,也就是对象的所有属性和对应的值,然而,Python并没有像PHP的print_r那样直接提... 目录python中打印对象所有属性和值的方法实现步骤1. 使用vars()和pprint()2. 使

HTML5 getUserMedia API网页录音实现指南示例小结

《HTML5getUserMediaAPI网页录音实现指南示例小结》本教程将指导你如何利用这一API,结合WebAudioAPI,实现网页录音功能,从获取音频流到处理和保存录音,整个过程将逐步... 目录1. html5 getUserMedia API简介1.1 API概念与历史1.2 功能与优势1.3

springboot项目中整合高德地图的实践

《springboot项目中整合高德地图的实践》:本文主要介绍springboot项目中整合高德地图的实践,具有很好的参考价值,希望对大家有所帮助,如有错误或未考虑完全的地方,望不吝赐教... 目录一:高德开放平台的使用二:创建数据库(我是用的是mysql)三:Springboot所需的依赖(根据你的需求再