Java请求接口，解析接口返回的json数据并存到数据库中

需求：调用其他平台接口，根据json格式里的字段获取数据并存到数据库中。

/定义接收格式，可以根据需求增加和修改
@Data
public class ETest01 implements Serializable {

    /**
     * state : 1
     * message : OK
     * data : [{"}]
     */

    private int state;
    private String message;
    private List<DataBean> data;

    @Data
    public static class DataBean implements Serializable {
        /**
         * cameraIndexCode : 111
         * cameraName : 1
         * cameraTypeName : 2
         * channelNo : 3
         * encodeDevIndexCode : 4
         * gbIndexCode : 5
         * regionIndexCode : 6
         * updateTime : 2021-08-24T09:00:52.000+00:00
         * message : null
         */
        private String cameraIndexCode;
        private String cameraName;
        private String cameraTypeName;
        private int channelNo;
        private String encodeDevIndexCode;
        private String gbIndexCode;
        private String regionIndexCode;
        private String updateTime;
        private Object message;

    }
}

import com.google.gson.Gson;
import com.httprequest.demo.entity.ETest01;
import com.httprequest.demo.utils.JsonUtil;
import org.json.JSONArray;
import org.json.JSONObject;
import org.junit.jupiter.api.Test;
import java.io.BufferedReader;
import java.io.ByteArrayOutputStream;
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.io.OutputStream;
import java.io.UnsupportedEncodingException;
import java.net.HttpURLConnection;
import java.net.URL;
import java.net.URLEncoder;
import java.sql.;
import java.util.;
import javax.net.ssl.HostnameVerifier;
import javax.net.ssl.HttpsURLConnection;
import javax.net.ssl.SSLSession;

/**

• HTTP请求
  */
  public class HTTPUtils {
  private static final int TIMEOUT = 45000;
  public static final String ENCODING = “UTF-8”;

  /**

  • 创建请求连接

  • url:地址

  • method:方法

  • headerParameters:请求头

  • body:请求内容
    */
    private static HttpURLConnection createConnection(String url,
    String method, Map<String, String> headerParameters, String body)
    throws Exception {
    URL Url = new URL(url);
    trustAllHttpsCertificates();
    HttpURLConnection httpConnection = (HttpURLConnection) Url
    .openConnection();
    // 设置请求时间
    httpConnection.setConnectTimeout(TIMEOUT);
    // 设置 header
    if (headerParameters != null) {
    Iterator iteratorHeader = headerParameters.keySet()
    .iterator();