package tv3;
import tool.*;
public class pro {
int s,datanumber;
String[] data=new String[50000];
public static void main(String[] args) {
pro r=new pro();
}
pro(){
String str1="%20";
String id="1mP7sXTO9wnsJo-eejPGeKCiFkw7_QsNoFfgnAGmz";
String urlx="https://www.googleapis.com/fusiontables/v1/query?sql=SELECT";
urlx=urlx+str1+"*"+str1+"FROM"+str1+id+str1;
urlx=urlx+"&key=AIzaSyAH0WCAXRIdHdbI-6bnMSN4kVDDZZmGyqY";
getdata sub=new getdata();
sub.makedata(urlx,"UTF-8");
data=sub.data;
datanumber=sub.datanumber;
String str="";
for(s=1;s<datanumber+1;s++){
str=str+data[s];
}
int sx;
String[] x=str.split("]");
for(s=0;s<x.length;s++){
String[] y=x[s].split(",");
for(sx=0;sx<y.length;sx++){
y[sx]=y[sx].replace("\"","");
y[sx]=y[sx].trim();
if(sx==6)System.out.println(y[3]+","+y[sx]);
}
}
}
}
最終更新:2016年08月01日 19:23