ｘｄｈｊｙ - プログラム倉庫

import java.sql.*;

class atinsert{
String[] title=new String[100];
String[] content=new String[100];
String[] category=new String[100];
String[] id=new String[100];
String[] link=new String[100];
String[] author=new String[100];
int[] alyear=new int[100];
int[] almonth=new int[100];
int[] alday=new int[100];

int atcode;
String atname;

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+"(googleid,category,title,author,alyear,almonth,alday,link,content) values (?,?,?,?,?,?,?,?,?)";

try {
dbx = DriverManager.getConnection(url, usr, pwd);  
PreparedStatement pstmt = dbx.prepareStatement(sqx);
pstmt.setString(1, id[s]);
pstmt.setString(2,category[s]);  
pstmt.setString(3, title[s]);
pstmt.setString(4, author[s]);  
pstmt.setInt(5, alyear[s]);
pstmt.setInt(6, almonth[s]);
pstmt.setInt(7, alday[s]);
pstmt.setString(8, link[s]);
pstmt.setString(9, content[s]);

int nu = pstmt.executeUpdate();

dbx.close();

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

}

}