超图SuperMap+openlayer+Vue3实现SQL查询 - 雨林笔记-前端个人技术记录

```javascript

// 通用 SQL 查询方法
export const querySQL = async (sql: string) => {
  const mapStore = useMapStore();
  const visibleLayers = getVisibleImageLayers();

if (visibleLayers.length === 0) {
    console.log('没有可查询的图层');
    mapStore.clearFeatures();
    return;
  }

try {
    const queries = visibleLayers.map(async (layer) => {
      const layerName = layer.get('source')?.name;
      const layerUrl = layer.get('source')?._url;
      const layerService = new LayerInfoService(layerUrl);
      const layersInfoRes = await layerService.getLayersInfo();
      const subLayerName = layersInfoRes.result.subLayers.layers[0].name;

if (!layerUrl || !subLayerName) {
        console.error(`图层 ${layer.get('title')} 缺少 URL 或 layerName`);
        return {layerTitle: layer.get('title'), features: []};
      }

const queryParams = new QueryBySQLParameters({
        queryParams: {
          name: subLayerName,
          attributeFilter: sql, // 使用 SQL 查询条件
        }
      })

const queryService = new QueryService(layerUrl);
      const result = await queryService.queryBySQL(queryParams);
      console.log('result', result)
      return {
        layerName,
        subLayerName,
        url: layerUrl,
        features: result?.result?.recordsets[0]?.features || [],
      };
    });