ｄｂ０１ - プログラム倉庫

import java.sql.*;

public class game0310{
public static void main (String args[]) {
    
Connection db = null;  
Statement  st = null;  
ResultSet  rs = null;  

    String url = "jdbc:derby:db;create=true";  
    String usr = "";  
    String pwd = "";  

    try {  
      db = DriverManager.getConnection(url, usr, pwd);
      st = db.createStatement();  
      st.executeUpdate("create table db07 (pon int,pv long varchar,item varchar(16))");
      st.executeUpdate("insert into db07 values (1,'llllllll','Hello world!')");
      st.executeUpdate("insert into db07 values (2,'kkkkkkkkkkkkkkkk','ようこそ！')");

      rs = st.executeQuery("select * from db07");
      if (rs != null) {
        while (rs.next()) {
          String item = rs.getString("pv");
          System.out.println(item);
        }
      }
      rs.close();

      // 表の削除
      st.executeUpdate("drop table db07");

      // データベース切断
      st.close();
      db.close();

    }
catch (Exception ex) { ex.printStackTrace();}
  }
}