diff options
author | antelder <antelder@13f79535-47bb-0310-9956-ffa450edef68> | 2009-08-08 10:03:33 +0000 |
---|---|---|
committer | antelder <antelder@13f79535-47bb-0310-9956-ffa450edef68> | 2009-08-08 10:03:33 +0000 |
commit | 2691aa6986e852c4dea45a26411335a65538a9be (patch) | |
tree | 5c44071b7577c96e4476ef144cf4cbf930e324bd /branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/java/util/CreateDB.java | |
parent | 8f0d21f91e640f972e4f4203db8b590b664f3b1f (diff) |
Move www-services to sandbox area until the license of the Amazon jars is clarified
git-svn-id: http://svn.us.apache.org/repos/asf/tuscany@802332 13f79535-47bb-0310-9956-ffa450edef68
Diffstat (limited to 'branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/java/util/CreateDB.java')
-rw-r--r-- | branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/java/util/CreateDB.java | 79 |
1 files changed, 0 insertions, 79 deletions
diff --git a/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/java/util/CreateDB.java b/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/java/util/CreateDB.java deleted file mode 100644 index a4dc2e67e6..0000000000 --- a/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/java/util/CreateDB.java +++ /dev/null @@ -1,79 +0,0 @@ -package util; - - -import java.sql.Connection; -import java.sql.DriverManager; -import java.sql.PreparedStatement; -import java.sql.SQLException; - -public class CreateDB { - - public static void main(String[] args) { - System.out.println("Creating database ..."); - - Connection connection = null; - PreparedStatement preparedStatement = null; - - try { - //initialize driver and register it with DriverManager - Class.forName("org.apache.derby.jdbc.EmbeddedDriver"); - - //connect and create the db if not present - connection = DriverManager.getConnection( - "jdbc:derby:target/store_db;create=true", - "", - ""); - - - try { - preparedStatement = connection.prepareStatement("DROP TABLE CATALOG"); - preparedStatement.execute(); - }catch(Exception e) { - //ignore to avoid erros when db is being created from scratch - } - - - preparedStatement = connection.prepareStatement("CREATE TABLE CATALOG(" - + "id NUMERIC(5 , 0) NOT NULL," - + "product_name VARCHAR(30)," - + "currency_code CHAR(3)," - + "price REAL," - + "primary key (id)" - + ")"); - preparedStatement.execute(); - - preparedStatement = connection.prepareStatement("INSERT INTO CATALOG VALUES(0,'Apple', 'USD', 2.99)"); - preparedStatement.execute(); - - preparedStatement = connection.prepareStatement("INSERT INTO CATALOG VALUES(1,'Orange', 'USD', 3.55)"); - preparedStatement.execute(); - - preparedStatement = connection.prepareStatement("INSERT INTO CATALOG VALUES(2,'Pear', 'USD', 1.55)"); - preparedStatement.execute(); - - System.out.println("Done !"); - - } catch (SQLException ex) { - ex.printStackTrace(); - }catch (ClassNotFoundException ex) { - ex.printStackTrace(); - } finally { - if (preparedStatement!=null) { - try { - preparedStatement.close(); - } catch (SQLException ex) { - ex.printStackTrace(); - } - } - - if (connection!=null) { - try { - connection.close(); - } catch (SQLException ex) { - ex.printStackTrace(); - } - } - } - } - -} |