{"id":428,"date":"2007-10-28T00:00:00","date_gmt":"2007-10-27T16:00:00","guid":{"rendered":"http:\/\/www.strongd.net\/?p=428"},"modified":"2011-07-15T09:56:59","modified_gmt":"2011-07-15T01:56:59","slug":"connect-to-java-db-derby-with-org-apache-derby-jdbc-embeddeddriver","status":"publish","type":"post","link":"https:\/\/www.strongd.net\/?p=428","title":{"rendered":"Connect to Java DB (Derby) with org.apache.derby.jdbc.EmbeddedDriver"},"content":{"rendered":"

import <\/STRONG><\/FONT>java.sql.Connection;<\/FONT>
import <\/B><\/FONT>java.sql.DriverManager;<\/FONT>
import <\/B><\/FONT>java.sql.PreparedStatement;<\/FONT>
import <\/B><\/FONT>java.sql.ResultSet;<\/FONT>
import <\/B><\/FONT>java.sql.Statement;<\/FONT>
<\/FONT>
public class <\/B><\/FONT>JavaDBDemo <\/FONT>{<\/FONT>
  <\/FONT>static <\/B><\/FONT>Connection conn;<\/FONT>
<\/FONT>
  <\/FONT>public static <\/B><\/FONT>void <\/B><\/FONT>main<\/FONT>(<\/FONT>String<\/FONT>[] <\/FONT>args<\/FONT>) {<\/FONT>
    <\/FONT>String driver = <\/FONT>“org.apache.derby.jdbc.EmbeddedDriver”<\/FONT>;<\/FONT>
    <\/FONT>String connectionURL = <\/FONT>“jdbc:derby:myDatabase;create=true”<\/FONT>;<\/FONT>
    <\/FONT>String createString = <\/FONT>“CREATE TABLE Employee (NAME VARCHAR(32) NOT NULL, ADDRESS VARCHAR(50) NOT NULL)”<\/FONT>;<\/FONT>
    <\/FONT>try <\/B><\/FONT>{<\/FONT>
      <\/FONT>Class<\/B><\/FONT>.forName<\/FONT>(<\/FONT>driver<\/FONT>)<\/FONT>;<\/FONT>
    <\/FONT>} <\/FONT>catch <\/B><\/FONT>(<\/FONT>java.lang.ClassNotFoundException e<\/FONT>) {<\/FONT>
      <\/FONT>e.printStackTrace<\/FONT>()<\/FONT>;<\/FONT>
    <\/FONT>}<\/FONT>
    <\/FONT>try <\/B><\/FONT>{<\/FONT>
      <\/FONT>conn = DriverManager.getConnection<\/FONT>(<\/FONT>connectionURL<\/FONT>)<\/FONT>;<\/FONT>
      <\/FONT>Statement stmt = conn.createStatement<\/FONT>()<\/FONT>;<\/FONT>
      <\/FONT>stmt.executeUpdate<\/FONT>(<\/FONT>createString<\/FONT>)<\/FONT>;<\/FONT>
<\/FONT>
      <\/FONT>PreparedStatement psInsert = conn.prepareStatement<\/FONT>(<\/FONT>“insert into Employee values (?,?)”<\/FONT>)<\/FONT>;<\/FONT>
<\/FONT>
      <\/FONT>psInsert.setString<\/FONT>(<\/FONT>1<\/FONT>, args<\/FONT>[<\/FONT>0<\/FONT>])<\/FONT>;<\/FONT>
      <\/FONT>psInsert.setString<\/FONT>(<\/FONT>2<\/FONT>, args<\/FONT>[<\/FONT>1<\/FONT>])<\/FONT>;<\/FONT>
<\/FONT>
      <\/FONT>psInsert.executeUpdate<\/FONT>()<\/FONT>;<\/FONT>
<\/FONT>
      <\/FONT>Statement stmt2 = conn.createStatement<\/FONT>()<\/FONT>;<\/FONT>
      <\/FONT>ResultSet rs = stmt2.executeQuery<\/FONT>(<\/FONT>“select * from Employee”<\/FONT>)<\/FONT>;<\/FONT>
      <\/FONT>int <\/B><\/FONT>num = <\/FONT>0<\/FONT>;<\/FONT>
      <\/FONT>while <\/B><\/FONT>(<\/FONT>rs.next<\/FONT>()) {<\/FONT>
        <\/FONT>System.out.println<\/FONT>(<\/FONT>++num + <\/FONT>“: Name: ” <\/FONT>+ rs.getString<\/FONT>(<\/FONT>1<\/FONT>) <\/FONT>+ <\/FONT>“\\n Address” <\/FONT>+ rs.getString<\/FONT>(<\/FONT>2<\/FONT>))<\/FONT>;<\/FONT>
      <\/FONT>}<\/FONT>
      <\/FONT>rs.close<\/FONT>()<\/FONT>;<\/FONT>
    <\/FONT>} <\/FONT>catch <\/B><\/FONT>(<\/FONT>Exception e<\/FONT>) {<\/FONT>
      <\/FONT>e.printStackTrace<\/FONT>()<\/FONT>;<\/FONT>
    <\/FONT>}<\/FONT>
  <\/FONT>}<\/FONT>
}<\/FONT><\/FONT>

\n

<\/DIV><\/p>\n","protected":false},"excerpt":{"rendered":"

import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.Statement;public class JavaDBDemo {  static Connection conn;  public static void main(String[] args) {    String driver = “org.apache.derby.jdbc.EmbeddedDriver”;    String connectionURL = “jdbc:derby:myDatabase;create=true”;    String createString = “CREATE TABLE Employee (NAME VARCHAR(32) NOT NULL, ADDRESS VARCHAR(50) NOT NULL)”;    try {      Class.forName(driver);    } catch (java.lang.ClassNotFoundException e) {      e.printStackTrace();    }    try {      conn = DriverManager.getConnection(connectionURL);      Statement stmt = conn.createStatement();      stmt.executeUpdate(createString);      PreparedStatement psInsert = conn.prepareStatement(“insert into Employee values (?,?)”);      psInsert.setString(1, args[0]);      psInsert.setString(2, args[1]);      psInsert.executeUpdate();      Statement stmt2 = conn.createStatement();      ResultSet rs = stmt2.executeQuery(“select * from Employee”);      int num = 0;      while (rs.next()) {        System.out.println(++num + “: Name: ” + rs.getString(1) + “\\n Address” + rs.getString(2));      }      rs.close();    } catch (Exception e) {      e.printStackTrace();    }  }}<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,7],"tags":[139],"class_list":["post-428","post","type-post","status-publish","format-standard","hentry","category-java","category-nosql","tag-derby"],"_links":{"self":[{"href":"https:\/\/www.strongd.net\/index.php?rest_route=\/wp\/v2\/posts\/428","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.strongd.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.strongd.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.strongd.net\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.strongd.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=428"}],"version-history":[{"count":1,"href":"https:\/\/www.strongd.net\/index.php?rest_route=\/wp\/v2\/posts\/428\/revisions"}],"predecessor-version":[{"id":947,"href":"https:\/\/www.strongd.net\/index.php?rest_route=\/wp\/v2\/posts\/428\/revisions\/947"}],"wp:attachment":[{"href":"https:\/\/www.strongd.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=428"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.strongd.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=428"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.strongd.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=428"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}