検証イ - プログラム倉庫

import java.sql.*;

class wordcheck{
  
int checknumber;      
String[] word=new String[1000];
int[] bcode=new int[1000];
int[] number=new int[1000];

void makedata(String dbtable){

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

Connection dbx;    
Statement  stx;
ResultSet rsx;

String sqlx;
int s;

s=0;

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

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

rsx = stx.executeQuery(sqlx);
if (rsx != null) {
while (rsx.next()) {
s=s+1;        
bcode[s]=rsx.getInt("bcode");
word[s]=rsx.getString("word");
number[s]=rsx.getInt("num");
}
}

checknumber=s;

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

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

}

}