gamedv - プログラム倉庫

import java.io.*;
import java.net.*;
import java.sql.*;

class game0501 implements Runnable{

String bun;
String article[]=new String[100];
int num,s;
String title[]=new String[100];
String des[]=new String[100];
String link[]=new String[100];
String date[]=new String[100];
String author[]=new String[100];
String pub[]=new String[100];
String sub[]=new String[100];
String pubdate[]=new String[100];

public static void main(String [] args) {

       game0501 f=new game0501();         
   } 

game0501(){

String urlx;

urlx="http://feeds.nytimes.com/nyt/rss/Americas";

getdata(urlx);

makearticle();

for (s=1;s<num+1;s++){
title[s]=makedata(article[s],"title");
des[s]=makedata(article[s],"description");
link[s]=makedata(article[s],"link");
date[s]=makedata(article[s],"dc:date");
author[s]=makedata(article[s],"dc:creator");
pub[s]=makedata(article[s],"dc:publisher");
sub[s]=makedata(article[s],"dc:subject");
pubdate[s]=makedata(article[s],"dc:Pubdate");
}

Thread th=new Thread(this);
th.start();
}

public void run(){
s=1;
while(s<100){
try{
makeinsert(s);
Thread.sleep(100);
}catch(InterruptedException e){}
s=s+1;
if(s>num)s=1000;
}
}

void makeinsert(int s){

String url = "jdbc:derby:db;create=true";
String usr = "";
String pwd = "";

Connection db;
Statement st;
String sq;

sq="insert into dbdb(title,link,des) values('";
sq=sq+title[s];
sq=sq+"','";
sq=sq+link[s];
sq=sq+"','";
sq=sq+des[s];
sq=sq+"')";

try {
db = DriverManager.getConnection(url, usr, pwd);
st = db.createStatement();
st.executeUpdate(sq);
st.close();
db.close();
} catch (Exception ex) {ex.printStackTrace();}
System.out.println(title[s]);

}

String makedata(String doc,String you){
String sx1,sx2,sx;
int x1,x2;
int lp1;
int lp2;
sx1="<"+you+">";
sx2="</"+you+">";
lp1=sx1.length();
lp2=sx2.length();
x1=doc.indexOf(sx1);
x2=doc.indexOf(sx2);
sx="";
if(x1>-1)sx=doc.substring(x1+lp1,x2);
return sx;
}

void makearticle(){
int point,x,n;
int x2,lp2;
String sx;
point=0;
x=bun.indexOf("<item");
n=0;
while(x>0){
n=n+1;
article[n]=makeart(bun,point);
sx="</item>";
lp2=sx.length();
x2=bun.indexOf(sx,point);
point=x2+lp2;
x=bun.indexOf("<item",point);
}
num=n;
}

String makeart(String bun,int point){
String sx1,sx2;
int x1,x2;
int lp1;
int lp2;
sx1="<item";
sx2="</item>";
lp1=sx1.length();
lp2=sx2.length();
x1=bun.indexOf(sx1,point);
x2=bun.indexOf(sx2,point);
return bun.substring(x1,x2+lp2);
}

void getdata(String name){
int nu;
int n;
String data[]=new String[1000];

nu=0;
try{

       URL url = new URL(name); 

       HttpURLConnection con = (HttpURLConnection)url.openConnection(); 
       con.setRequestMethod("GET"); 
       con.connect(); 

       BufferedReader reader = 
           new BufferedReader(new InputStreamReader(con.getInputStream(),"UTF-8")); 

n=0;

       while (true){ 
           String [[line]] = reader.readLine(); 
           if ( line == null ){ 
               break; 
           } 

data[n]=line;
n=n+1;
nu=n;

       } 
       reader.close(); 
       con.disconnect(); 

}
catch(Exception e) { System.err.println(e); }
bun="";
for (n=0;n<nu;n++){
bun=bun+data[n];
}

}

}