{"id":429,"date":"2007-10-28T00:00:00","date_gmt":"2007-10-27T16:00:00","guid":{"rendered":"http:\/\/www.strongd.net\/?p=429"},"modified":"2011-07-15T09:57:11","modified_gmt":"2011-07-15T01:57:11","slug":"derby-jdbc-connection","status":"publish","type":"post","link":"https:\/\/www.strongd.net\/?p=429","title":{"rendered":"Derby JDBC Connection"},"content":{"rendered":"

import <\/STRONG><\/FONT>java.sql.Connection;<\/FONT>
import <\/B><\/FONT>java.sql.DriverManager;<\/FONT>
import <\/B><\/FONT>java.sql.ResultSet;<\/FONT>
import <\/B><\/FONT>java.sql.SQLException;<\/FONT>
import <\/B><\/FONT>java.sql.Statement;<\/FONT>
<\/FONT>
import <\/B><\/FONT>java.util.Properties;<\/FONT>
<\/FONT>
public class <\/B><\/FONT>MainClass <\/FONT>{<\/FONT>
   <\/FONT>public static <\/B><\/FONT>void <\/B><\/FONT>main<\/FONT>(<\/FONT>String<\/FONT>[] <\/FONT>args<\/FONT>)<\/FONT>
   <\/FONT>{<\/FONT>
      <\/FONT>try <\/B><\/FONT>{<\/FONT>
         <\/FONT>String driver = <\/FONT>“org.apache.derby.jdbc.EmbeddedDriver”<\/FONT>;<\/FONT>
<\/FONT>
         <\/FONT>Class<\/B><\/FONT>.forName<\/FONT>(<\/FONT>driver<\/FONT>)<\/FONT>.newInstance<\/FONT>()<\/FONT>;<\/FONT>
         <\/FONT>Connection conn = <\/FONT>null<\/B><\/FONT>;<\/FONT>
         <\/FONT>conn = DriverManager.getConnection<\/FONT>(<\/FONT>“jdbc:derby:DerbyTestDB”<\/FONT>)<\/FONT>;<\/FONT>
         <\/FONT>Statement s = conn.createStatement<\/FONT>()<\/FONT>;<\/FONT>
         <\/FONT>ResultSet rs = s.executeQuery<\/FONT>(<\/FONT>“SELECT city, state, zipcode FROM zipcodes”<\/FONT>)<\/FONT>;<\/FONT>
<\/FONT>
         <\/FONT>while<\/B><\/FONT>(<\/FONT>rs.next<\/FONT>()) {<\/FONT>
            <\/FONT>System.out.println<\/FONT>(<\/FONT>“City   : “<\/FONT>+ rs.getString<\/FONT>(<\/FONT>1<\/FONT>))<\/FONT>;<\/FONT>
            <\/FONT>System.out.println<\/FONT>(<\/FONT>“State  : “<\/FONT>+ rs.getString<\/FONT>(<\/FONT>2<\/FONT>))<\/FONT>;<\/FONT>
            <\/FONT>System.out.println<\/FONT>(<\/FONT>“Zipcode: “<\/FONT>+ rs.getString<\/FONT>(<\/FONT>3<\/FONT>))<\/FONT>;<\/FONT>
            <\/FONT>System.out.println<\/FONT>()<\/FONT>;<\/FONT>
         <\/FONT>}<\/FONT>
<\/FONT>
         <\/FONT>rs.close<\/FONT>()<\/FONT>;<\/FONT>
         <\/FONT>s.close<\/FONT>()<\/FONT>;<\/FONT>
         <\/FONT>conn.close<\/FONT>()<\/FONT>;<\/FONT>
      <\/FONT>} <\/FONT>catch<\/B><\/FONT>(<\/FONT>Exception e<\/FONT>) {<\/FONT>
         <\/FONT>System.out.println<\/FONT>(<\/FONT>“Exception: “<\/FONT>+ e<\/FONT>)<\/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.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.Properties;public class MainClass {   public static void main(String[] args)   {      try {         String driver = “org.apache.derby.jdbc.EmbeddedDriver”;         Class.forName(driver).newInstance();         Connection conn = null;         conn = DriverManager.getConnection(“jdbc:derby:DerbyTestDB”);         Statement s = conn.createStatement();         ResultSet rs = s.executeQuery(“SELECT city, state, zipcode FROM zipcodes”);         while(rs.next()) {            System.out.println(“City   : “+ rs.getString(1));            System.out.println(“State  : “+ rs.getString(2));            System.out.println(“Zipcode: “+ rs.getString(3));            System.out.println();         }         rs.close();         s.close();         conn.close();      } catch(Exception e) {         System.out.println(“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-429","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\/429","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=429"}],"version-history":[{"count":1,"href":"https:\/\/www.strongd.net\/index.php?rest_route=\/wp\/v2\/posts\/429\/revisions"}],"predecessor-version":[{"id":948,"href":"https:\/\/www.strongd.net\/index.php?rest_route=\/wp\/v2\/posts\/429\/revisions\/948"}],"wp:attachment":[{"href":"https:\/\/www.strongd.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=429"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.strongd.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=429"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.strongd.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=429"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}