ちぃんせｒｔ - プログラム倉庫

import java.sql.*;

class yinsertdata{
String[] title=new String[100];
String[] link=new String[100];
String[] des=new String[100];
int year[]=new int[100];
String month[]=new String[100];
int day[]=new int[100];
int ccode;
String name;
int num;

void makedata(String database,int num,int s){

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

Connection dbx;    
String sqx;

sqx="insert into ";
sqx=sqx+database;
sqx=sqx+"(num,name,ccode,nyear,month,day,title,des,link) values (?,?,?,?,?,?,?,?,?)";

try {
dbx = DriverManager.getConnection(url, usr, pwd);  
PreparedStatement pstmt = dbx.prepareStatement(sqx);
pstmt.setInt(1, num);
pstmt.setString(2,name);  
pstmt.setInt(3, ccode);
pstmt.setInt(4, year[s]);
pstmt.setString(5,month[s]);  
pstmt.setInt(6, day[s]);
pstmt.setString(7, title[s]);
pstmt.setString(8, des[s]);
pstmt.setString(9, link[s]);

int nu = pstmt.executeUpdate();

dbx.close();

}catch (SQLException e){System.out.println("SQLException:" + e.getMessage());}

}

}