解析与过滤JSONArray：Java/Android中根据键值提取特定数据

[
    {
        "num": "34304",
        "email": "<a class="__cf_email__" data-cfemail="2f4e4e4e4e6f424e4643014e4b4b5d4a5c5c" href="/cdn-cgi/l/email-protection">[email protected]</a>",
        "lati": "8888888",
        "longt": "88888888",
        "time": "2022-12-08 21:15:39"
    },
    {
        "num": "34303",
        "email": "<a class="__cf_email__" data-cfemail="2c4d4d4d4d6c414d4540024d48485e495f5f" href="/cdn-cgi/l/email-protection">[email protected]</a>",
        "lati": "8888",
        "longt": "88888",
        "time": "8888888"
    }
    // ... 更多数据
]

import org.json.JSONArray;
import org.json.JSONException;
import org.json.JSONObject;

public class JsonParser {

    public static void parseAndFilterJson(String jsonString, String targetEmail) {
        try {
            JSONArray jsonArray = new JSONArray(jsonString);
            // ... 后续处理
        } catch (JSONException e) {
            e.printStackTrace();
            System.err.println("JSON解析错误: " + e.getMessage());
        }
    }
}

import org.json.JSONArray;
import org.json.JSONException;
import org.json.JSONObject;
import java.util.regex.Matcher;
import java.util.regex.Pattern;

public class JsonParser {

    public static void parseAndFilterJson(String jsonString, String targetEmail) {
        try {
            JSONArray jsonArray = new JSONArray(jsonString);

            System.out.println("开始解析并过滤JSON数据...");

            for (int i = 0; i < jsonArray.length(); i++) {
                JSONObject jsonObject = jsonArray.optJSONObject(i); // 使用optJSONObject更安全，避免空指针

                if (jsonObject != null) {
                    // 提取并处理email字段
                    String rawEmailHtml = jsonObject.optString("email", "");
                    String extractedEmail = extractEmailFromHtml(rawEmailHtml); // 自定义方法处理HTML包裹的邮箱

                    // 提取经纬度
                    String lati = jsonObject.optString("lati", "0.0");
                    String longt = jsonObject.optString("longt", "0.0");

                    // 进行过滤
                    if (extractedEmail.equals(targetEmail)) {
                        System.out.println("找到匹配的邮箱: " + extractedEmail);
                        System.out.println("  纬度 (lati): " + lati);
                        System.out.println("  经度 (longt): " + longt);
                        // 您可以在这里将lati和longt添加到列表中，或进行其他操作
                    }
                }
            }
            System.out.println("JSON数据解析过滤完成。");

        } catch (JSONException e) {
            e.printStackTrace();
            System.err.println("JSON解析错误: " + e.getMessage());
        }
    }

    /**
     * 从HTML字符串中提取纯文本邮箱地址。
     * 假设邮箱地址位于<a>标签的文本内容中，且格式为[email protected]。
     * 更健壮的HTML解析应使用Jsoup等库。
     */
    private static String extractEmailFromHtml(String html) {
        if (html == null || html.isEmpty()) {
            return "";
        }
        // 匹配<a>...</a>标签中的内容
        Pattern pattern = Pattern.compile("<a[^>]*>([^<]+)</a>");
        Matcher matcher = pattern.matcher(html);
        if (matcher.find()) {
            String emailText = matcher.group(1);
            // 进一步处理[email protected]这种格式，如果需要解密
            // 对于本例，我们假设目标邮箱也是"[email protected]"这种形式
            return emailText;
        }
        return ""; // 如果没有找到匹配的邮箱格式，返回空字符串
    }

    public static void main(String[] args) {
        String sampleJson = "[" +
                "    {" +
                "        "num": "34304"," +
                "        "email": "<a class=\"__cf_email__\" data-cfemail=\"2f4e4e4e4e6f424e4643014e4b4b5d4a5c5c\" href=\"/cdn-cgi/l/email-protection\">[email&#160;protected]</a>"," +
                "        "lati": "8888888"," +
                "        "longt": "88888888"," +
                "        "time": "2022-12-08 21:15:39"" +
                "    }," +
                "    {" +
                "        "num": "34303"," +
                "        "email": "<a class=\"__cf_email__\" data-cfemail=\"2c4d4d4d4d6c414d4540024d48485e495f5f\" href=\"/cdn-cgi/l/email-protection\">[email&#160;protected]</a>"," +
                "        "lati": "8888"," +
                "        "longt": "88888"," +
                "        "time": "8888888"" +
                "    }," +
                "    {" +
                "        "num": "34302"," +
                "        "email": "<a class=\"__cf_email__\" data-cfemail=\"3c5e5e5e5e7c515d5550125d58584e594f4f\" href=\"/cdn-cgi/l/email-protection\">[email&#160;protected]</a>"," +
                "        "lati": "8888"," +
                "        "longt": "88888"," +
                "        "time": "8888888"" +
                "    }" +
                "]";

        // 假设我们要查找的邮箱是"[email protected]"
        String targetEmailToFind = "[email protected]";
        parseAndFilterJson(sampleJson, targetEmailToFind);
    }
}

import com.google.android.gms.maps.model.LatLng; // 假设您已导入Google Maps SDK

// ... 在parseAndFilterJson方法内部的过滤条件中 ...
if (extractedEmail.equals(targetEmail)) {
    try {
        double latitude = Double.parseDouble(lati);
        double longitude = Double.parseDouble(longt);
        LatLng latLng = new LatLng(latitude, longitude);
        System.out.println("  生成LatLng对象: " + latLng.latitude + ", " + latLng.longitude);
        // latLngList.add(latLng); // 如果有列表，可以添加到列表中
    } catch (NumberFormatException e) {
        System.err.println("经纬度格式错误: " + lati + ", " + longt);
    }
}