ヴぇんと - プログラム倉庫

import java.sql.*;

class historyread{

int readmonth[]=new int[10000];
int readday[]=new int[10000];
int readyear[]=new int[10000];
double readvolume[]=new double[10000];
int readnumber;

void makedata(String dbtable,int gcode){

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

Connection dbx;    
Statement  stx;
ResultSet rsx;

String sqlx;
int s;
double z1;
int x1,x2,x3;
s=0;

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

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

      rsx = stx.executeQuery(sqlx);
      if (rsx != null) {
        while (rsx.next()) {
        x1=rsx.getInt("gyear");
        x2=rsx.getInt("gmonth");
        x3=rsx.getInt("gday");
        z1=rsx.getDouble("volume");
s=s+1;
readyear[s]=x1;
readmonth[s]=x2;
readday[s]=x3;
}
}

readnumber=s;

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

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

}





}