1.pom.xml文件 4.0.0

tcl.ln.geturl geturl 1.0-SNAPSHOT

net.sf.json-lib json-lib 2.4 jdk15

mysql mysql-connector-java 5.1.25 org.springframework.boot spring-boot-maven-plugin geturl.Iputil repackage

2. 通过此数据建立实体类

package geturl;

import java.util.List;

public class JsonBean { private String status; private String msg;// 封装data的数据 private DataBean data;

public String getStatus() { return status; }

public void setStatus(String status) { this.status = status; }

public String getMsg() { return msg; }

public void setMsg(String msg) { this.msg = msg; }

public DataBean getData() { return data; }

public void setData(DataBean data) { this.data = data; }

//Data数据封装 public static class DataBean { private Integer totalSize; private Integer hasNext; // 封装tuples的数据 private List list;

public Integer getTotalSize() { return totalSize; }

public void setTotalSize(Integer totalSize) { this.totalSize = totalSize; }

public Integer getHasNext() { return hasNext; }

public void setHasNext(Integer hasNext) { this.hasNext = hasNext; }

public List getList() { return list; }

public void setList(List list) { this.list = list; } }//Tuples数据封装 public static class TuplesBean { private String id; private String sn; private String activationCode; private String source; private String phoneNum; private String ip; private String status; private String obtainTime; private String synTime;

public TuplesBean() { }

public String getId() { return id; }

public void setId(String id) { this.id = id; }

public String getSn() { return sn; }

public void setSn(String sn) { this.sn = sn; }

public String getActivationCode() { return activationCode; }

public void setActivationCode(String activationCode) { this.activationCode = activationCode; }

public String getSource() { return source; }

public void setSource(String source) { this.source = source; }

public String getIp() { return ip; }

public void setIp(String ip) { this.ip = ip; }

public String getStatus() { return status; }

public void setStatus(String status) { this.status = status; }

public String getObtainTime() { return obtainTime; }

public void setObtainTime(String obtainTime) { this.obtainTime = obtainTime; }

public String getSynTime() { return synTime; }

public void setSynTime(String synTime) { this.synTime = synTime; }

public String getPhoneNum() { return phoneNum; }

public void setPhoneNum(String phoneNum) { this.phoneNum = phoneNum; }

}}

3.数据库连接类

package geturl;

import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;

public class Conn {//数据库连接类

/** * @return Connection * @method getConn() */ public Connection getConn() {

String driver = "com.mysql.jdbc.Driver"; String url = "jdbc:mysql://10.68.23.151:3306/tcl_adwdfa"; String username = "ddadad"; String password = "dsadaw"; Connection conn = null;

try { Class.forName(driver); // conn = (Connection) DriverManager.getConnection(url, username, password);

System.out.println("数据库连接成功");

} catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); }

return conn; }

}

4.解析存储类package geturl;

import java.net.*;import java.security.MessageDigest;import java.sql.Connection;import java.sql.ResultSet;import java.sql.Statement;import java.text.ParseException;import java.text.SimpleDateFormat;import java.util.*;import java.io.*;

import net.sf.json.JSONArray;import net.sf.json.JSONObject;

//解析存储类public class Iputil {// 记录请求的json的页数 static int count = 1;// 记录日志的日期 static String date ; public static void main(String[] args) throws ParseException {

//请求得到json，有多少页执行多少次 for (int i=1;i