diff options
Diffstat (limited to 'branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src')
6 files changed, 0 insertions, 320 deletions
diff --git a/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/java/launch/LaunchCatalog.java b/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/java/launch/LaunchCatalog.java deleted file mode 100644 index c46845722c..0000000000 --- a/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/java/launch/LaunchCatalog.java +++ /dev/null @@ -1,34 +0,0 @@ -/* - * Licensed to the Apache Software Foundation (ASF) under one - * or more contributor license agreements. See the NOTICE file - * distributed with this work for additional information - * regarding copyright ownership. The ASF licenses this file - * to you under the Apache License, Version 2.0 (the - * "License"); you may not use this file except in compliance - * with the License. You may obtain a copy of the License at - * - * http://www.apache.org/licenses/LICENSE-2.0 - * - * Unless required by applicable law or agreed to in writing, - * software distributed under the License is distributed on an - * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY - * KIND, either express or implied. See the License for the - * specific language governing permissions and limitations - * under the License. - */ - -package launch; - -import org.apache.tuscany.sca.host.embedded.SCADomain; - -public class LaunchCatalog { - public static void main(String[] args) throws Exception { - System.out.println("Starting ..."); - SCADomain scaDomain = SCADomain.newInstance("store-catalog-database.composite"); - System.out.println("store-catalog-database.composite ready for big business !!!"); - System.in.read(); - System.out.println("Stopping ..."); - scaDomain.close(); - System.out.println(); - } -} diff --git a/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/java/services/Catalog.java b/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/java/services/Catalog.java deleted file mode 100644 index 9f784b0848..0000000000 --- a/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/java/services/Catalog.java +++ /dev/null @@ -1,27 +0,0 @@ -/* - * Licensed to the Apache Software Foundation (ASF) under one - * or more contributor license agreements. See the NOTICE file - * distributed with this work for additional information - * regarding copyright ownership. The ASF licenses this file - * to you under the Apache License, Version 2.0 (the - * "License"); you may not use this file except in compliance - * with the License. You may obtain a copy of the License at - * - * http://www.apache.org/licenses/LICENSE-2.0 - * - * Unless required by applicable law or agreed to in writing, - * software distributed under the License is distributed on an - * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY - * KIND, either express or implied. See the License for the - * specific language governing permissions and limitations - * under the License. - */ - -package services; - -import org.osoa.sca.annotations.Remotable; - -@Remotable -public interface Catalog { - String[] get(); -} diff --git a/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/java/services/CatalogImpl.java b/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/java/services/CatalogImpl.java deleted file mode 100644 index c8b3bbf621..0000000000 --- a/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/java/services/CatalogImpl.java +++ /dev/null @@ -1,120 +0,0 @@ -/* - * Licensed to the Apache Software Foundation (ASF) under one - * or more contributor license agreements. See the NOTICE file - * distributed with this work for additional information - * regarding copyright ownership. The ASF licenses this file - * to you under the Apache License, Version 2.0 (the - * "License"); you may not use this file except in compliance - * with the License. You may obtain a copy of the License at - * - * http://www.apache.org/licenses/LICENSE-2.0 - * - * Unless required by applicable law or agreed to in writing, - * software distributed under the License is distributed on an - * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY - * KIND, either express or implied. See the License for the - * specific language governing permissions and limitations - * under the License. - */ - -package services; - -import java.sql.Connection; -import java.sql.DriverManager; -import java.sql.PreparedStatement; -import java.sql.ResultSet; -import java.sql.SQLException; - -import org.osoa.sca.annotations.Property; -import org.osoa.sca.annotations.Reference; - -public class CatalogImpl implements Catalog { - @Property - public String currencyCode = "USD"; - - @Reference - public CurrencyConverter currencyConverter; - - private String currencySymbol; - - public String[] get() { - - String[] catalogArray = null; - - String itemName; - float itemPrice; - String itemCurrencyCode; - - Connection conn = null; - PreparedStatement pstmt = null; - ResultSet rs = null; - - currencySymbol = currencyConverter.getCurrencySymbol(currencyCode); - - try { - //initialize driver and register it with DriverManager - Class.forName("org.apache.derby.jdbc.EmbeddedDriver"); - - conn = DriverManager.getConnection( - "jdbc:derby:target/store_db", - "", - ""); - - pstmt = conn.prepareStatement("select * from \"Catalog\"", - ResultSet.TYPE_SCROLL_INSENSITIVE, - ResultSet.CONCUR_READ_ONLY); - - rs = pstmt.executeQuery(); - rs.last(); - - catalogArray = new String[rs.getRow()]; - - do { - itemName = rs.getString(2); - itemPrice = rs.getFloat(4); - itemCurrencyCode = rs.getString(3); - - catalogArray[rs.getRow()-1] = new String(itemName+" - "+ - currencySymbol+" "+ - currencyConverter.getConversion(itemCurrencyCode, currencyCode, itemPrice)); - - } while(rs.previous()); - - } catch (SQLException ex) { - ex.printStackTrace(); - }catch (ClassNotFoundException ex) { - ex.printStackTrace(); - } finally { - cleanup(conn,pstmt,rs); - } - - return catalogArray; - } - - private void cleanup(Connection conn, PreparedStatement pstmt, ResultSet rs) { - - if (rs!=null) { - try { - rs.close(); - } catch (SQLException ex) { - ex.printStackTrace(); - } - } - - if (pstmt!=null) { - try { - pstmt.close(); - } catch (SQLException ex) { - ex.printStackTrace(); - } - } - - if (conn!=null) { - try { - conn.close(); - } catch (SQLException ex) { - ex.printStackTrace(); - } - } - } -} diff --git a/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/java/services/CurrencyConverter.java b/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/java/services/CurrencyConverter.java deleted file mode 100644 index 8b0f70907d..0000000000 --- a/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/java/services/CurrencyConverter.java +++ /dev/null @@ -1,29 +0,0 @@ -/* - * Licensed to the Apache Software Foundation (ASF) under one - * or more contributor license agreements. See the NOTICE file - * distributed with this work for additional information - * regarding copyright ownership. The ASF licenses this file - * to you under the Apache License, Version 2.0 (the - * "License"); you may not use this file except in compliance - * with the License. You may obtain a copy of the License at - * - * http://www.apache.org/licenses/LICENSE-2.0 - * - * Unless required by applicable law or agreed to in writing, - * software distributed under the License is distributed on an - * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY - * KIND, either express or implied. See the License for the - * specific language governing permissions and limitations - * under the License. - */ - -package services; - -import org.osoa.sca.annotations.Remotable; - -@Remotable -public interface CurrencyConverter { - public float getConversion(String fromCurrenycCode, String toCurrencyCode, float amount); - - public String getCurrencySymbol(String currencyCode); -} 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(); - } - } - } - } - -} diff --git a/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/resources/store-catalog-database.composite b/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/resources/store-catalog-database.composite deleted file mode 100644 index aea8a6972c..0000000000 --- a/branches/sca-java-1.x/tutorials/store/www-services/catalog-amazon/store-db/src/main/resources/store-catalog-database.composite +++ /dev/null @@ -1,31 +0,0 @@ -<?xml version="1.0" encoding="UTF-8"?> -<!-- - * Licensed to the Apache Software Foundation (ASF) under one - * or more contributor license agreements. See the NOTICE file - * distributed with this work for additional information - * regarding copyright ownership. The ASF licenses this file - * to you under the Apache License, Version 2.0 (the - * "License"); you may not use this file except in compliance - * with the License. You may obtain a copy of the License at - * - * http://www.apache.org/licenses/LICENSE-2.0 - * - * Unless required by applicable law or agreed to in writing, - * software distributed under the License is distributed on an - * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY - * KIND, either express or implied. See the License for the - * specific language governing permissions and limitations - * under the License. ---> -<composite xmlns="http://www.osoa.org/xmlns/sca/1.0" - xmlns:t="http://tuscany.apache.org/xmlns/sca/1.0" - xmlns:s="http://store" - name="store-catalog-database"> - - <component name="Catalog"> - <implementation.java class="services.CatalogImpl"/> - <property name="currencyCode">USD</property> - <reference name="currencyConverter" target="CurrencyConverter"/> - </component> - -</composite> |