DBUtilsを使う
Apache Commons DBUtilsの使い方メモ
DBUtils1.5
http://commons.apache.org/dbutils/index.html
・抽出
・挿入
・更新
・削除
DBUtils1.5
http://commons.apache.org/dbutils/index.html
・抽出
QueryRunner qr = new QueryRunner();
ResultSetHandler
・挿入
QueryRunner qr = new QueryRunner();
qr.update(Connection, "INSERT INTO HOGE (foo, bar) VALUES (?, ?);", hoge1, hoge2);
・更新
QueryRunner qr = new QueryRunner();
qr.update(Connection, "UPDATE HOGE SET foo = ? WHERE bar = ?;", hoge1, hoge2);
・削除
QueryRunner qr = new QueryRunner();
qr.update(Connection, "DELETE FROM HOGE WHERE foo = ?;", hoge1);