Apache Derby
昨日10/21の続き。
データベースを更新する。
UpdatePolice.java
import java.util.*; import java.sql.*; public class UpdatePolice { public static void main(String args[]) { try{ Class.forName("org.apache.derby.jdbc.EmbeddedDriver"); } catch (ClassNotFoundException e) { e.printStackTrace(); } Connection conn = null; Statement stmt = null; Properties props = new Properties(); try { conn = DriverManager.getConnection("jdbc:derby:police_db",props); stmt = conn.createStatement(); int updated = stmt.executeUpdate( "update app.police_tbl set" + " nickname='" + args[1] + "'," + " player='" + args[2] + "'" + " where id=" + args[0]); System.out.println("update count : " + updated); } catch (SQLException e) { e.printStackTrace(); } finally { try { if (stmt != null) { stmt.close(); } if (conn != null) { conn.close(); } } catch (Exception ignore) {} } } }
まずはデータ内容の確認。
D:\home\hoge>derby_run.bat D:\home\hoge>java org.apache.derby.tools.ij ij バージョン 10.1 ij> connect 'jdbc:derby:police_db'; ij> SELECT id AS ID, nickname AS "ニックネーム", player AS "役者" FROM police_tbl; ID |ニックネーム |役者
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- -
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
データの更新
D:\home\hoge>java UpdatePolice 8 ジーパン 何じゃこりゃぁ!! update count : 1
更新内容の確認
D:\home\hoge>java org.apache.derby.tools.ij ij バージョン 10.1 ij> connect 'jdbc:derby:police_db'; ij> SELECT id AS ID, nickname AS "ニックネーム", player AS "役者" FROM police_tbl; ID |ニックネーム |役者
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- -
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-