ｈｙｔ - プログラム倉庫

import java.sql.*;

class historycheck{
  
int check;
int gcode;
int gyear,gmonth,gday;  

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;
String x1;

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;
sqlx=sqlx+" AND ";
sqlx=sqlx+"gyear = ";  
sqlx=sqlx+gyear;
sqlx=sqlx+ " AND ";
sqlx=sqlx+"gmonth = ";  
sqlx=sqlx+gmonth;
sqlx=sqlx+" AND ";
sqlx=sqlx+"gday = ";  
sqlx=sqlx+gday;  

      rsx = stx.executeQuery(sqlx);
      if (rsx != null) {
        while (rsx.next()) {
        x1=rsx.getString("gcode");                  
s=s+100;
}
}

check=s;

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

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

}

}