ｃｈだたごおｇぇ - プログラム倉庫

import java.sql.*;

class chdata{

String dbtable;
int ccode;
int cyear[]=new int[1000];
int cday[]=new int[1000];
String cmonth[]=new String[1000];
int chnumber;
int originaldata;

void makedata(String dbtable,int ccode){

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

Connection dbx;    
Statement  stx;
ResultSet rsx;

String sqlx;
int s;
int x2,x4;
String x3;

s=0;

try {
      dbx = DriverManager.getConnection(url, usr, pwd);
      stx = dbx.createStatement();

sqlx="select * from ";
sqlx=sqlx+dbtable;
sqlx=sqlx+" where ccode=";
sqlx=sqlx+ccode;


      rsx = stx.executeQuery(sqlx);
      if (rsx != null) {
        while (rsx.next()) {
           x2 = rsx.getInt("nyear");
           x3 = rsx.getString("month");
           x4 = rsx.getInt("day");
s=s+1;
cyear[s]=x2;
cmonth[s]=x3;
cday[s]=x4;

}
}

chnumber=s;

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

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

}


void makedn(String dbtable){

int pp;

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

Connection dbx;    
Statement  stx;
ResultSet rsx;

String sqlx;

pp=0;

try {
      dbx = DriverManager.getConnection(url, usr, pwd);
      stx = dbx.createStatement();

sqlx="select count(*) from ";
sqlx=sqlx+dbtable;

rsx = stx.executeQuery(sqlx);
rsx.next();        
pp = rsx.getInt(1);                  

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

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

originaldata=pp;

}


}