- 401 名前：デフォルトの名無しさん mailto:sage [2016/08/06(土) 02:13:17.61 ID:FfBiCVo4.net]
- private void insert_task(String table, BufferedReader br) {
Connection con = null;
PreparedStatement pstmt_ins = null;
PreparedStatement pstmt_del = null;
PreparedStatement pstmt_upd = null;
try {
//JDBCドライバのロード
//各設定
String url = "jdbc:odbc:kinmu";
String user = "";
String pass = "";
//データベースに接続
con = DriverManager.getConnection(url, user, pass);
String line = ""; //一行ずつ読み込む
int line_count = 1; //ヘッダーフラグ
boolean delete_flg = true; //ヘッダーフラグ
String sql_ins = "INSERT into KINMU values(?,?,?,?,?)";
pstmt_ins = con.prepareStatement(sql_ins);
while ((line = br.readLine()) != null) {
String[] strAry = line.split(",", 11);
pstmt_ins.setString(1, strAry[0]);
pstmt_ins.setString(2, strAry[1]);
pstmt_ins.setString(3, strAry[2]);
pstmt_ins.setString(4, strAry[3]);
pstmt_ins.setString(5, strAry[4]);
pstmt_ins.executeUpdate();
}
} catch (IOException exception) {
|
 |
