つぇこでいん - プログラム倉庫

import java.sql.*;
class insert{

String[] title=new String[100];
String[] source=new String[100];  
String[] content=new String[100];
String[] link=new String[100];  
int tsecode;
int year[]=new int[100];
int month[]=new int[100];
int day[]=new int[100];

void makedata(String database,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+"(tsecode,zyear,zmonth,zday,title,source,link,content) values (?,?,?,?,?,?,?,?)";

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

int nu = pstmt.executeUpdate();

dbx.close();

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

}