ぷれｈｊ - プログラム倉庫

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

class game0320{

String str,urlx;
String bun;
String article[]=new String[100];
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];
String x[]=new String[1000];
int num;
int s,n;
int count;
int z;

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

Connection db = null;  
Statement  st = null;
ResultSet  rs = null;

public static void main(String [] args) {
        game0320 f=new game0320();
            }

game0320(){

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");
}

count=0;

try {

      db = DriverManager.getConnection(url, usr, pwd);
      st = db.createStatement();

      rs = st.executeQuery("select * from dbdb");
      if (rs != null) {
        while (rs.next()) {
          String item = rs.getString("title");
count=count+1;          
x[count]=item;
        }
      }
      rs.close();
      st.close();
      db.close();

    } catch (Exception ex) {ex.printStackTrace();}


for(n=1;n<num+1;n++){
z=0;
for (s=1;s<count+1;s++){
if(title[5].equals(x[s]))z=100;
}
System.out.println(z);
}



}

void makeinsert(int s){

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]);

}




void maketable(){

Connection dbx;  
Statement stx;  

    try {  
      dbx = DriverManager.getConnection(url, usr, pwd);
      stx = dbx.createStatement();  
      stx.executeUpdate("create table dbdb(title varchar(100),link varchar(100),des long varchar)");

      stx.close();
      dbx.close();

    }
catch (Exception ex) { ex.printStackTrace();}
  }

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 n;
String data[]=new String[1000];

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;
num=n;
        }
        reader.close();
        con.disconnect();
}
catch(Exception e) { System.err.println(e); }  
bun="";
for (n=0;n<num;n++){
bun=bun+data[n];
}

}

}