You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@tuscany.apache.org by kw...@apache.org on 2006/07/09 00:57:28 UTC

svn commit: r420214 - in /incubator/tuscany/java/sampleapps/bigbank/account/src/main: java/bigbank/account/services/accountdata/ java/bigbank/account/services/accountdb/ java/bigbank/account/services/accountlogger/ resources/

Author: kwilliams
Date: Sat Jul  8 15:57:27 2006
New Revision: 420214

URL: http://svn.apache.org/viewvc?rev=420214&view=rev
Log:
BBank changes needed after removing named parameters

Modified:
    incubator/tuscany/java/sampleapps/bigbank/account/src/main/java/bigbank/account/services/accountdata/AccountDataServiceDASImpl.java
    incubator/tuscany/java/sampleapps/bigbank/account/src/main/java/bigbank/account/services/accountdb/AccountDBInit.java
    incubator/tuscany/java/sampleapps/bigbank/account/src/main/java/bigbank/account/services/accountlogger/AccountLoggerServiceImpl.java
    incubator/tuscany/java/sampleapps/bigbank/account/src/main/resources/DasAccountConfiguration.xml

Modified: incubator/tuscany/java/sampleapps/bigbank/account/src/main/java/bigbank/account/services/accountdata/AccountDataServiceDASImpl.java
URL: http://svn.apache.org/viewvc/incubator/tuscany/java/sampleapps/bigbank/account/src/main/java/bigbank/account/services/accountdata/AccountDataServiceDASImpl.java?rev=420214&r1=420213&r2=420214&view=diff
==============================================================================
--- incubator/tuscany/java/sampleapps/bigbank/account/src/main/java/bigbank/account/services/accountdata/AccountDataServiceDASImpl.java (original)
+++ incubator/tuscany/java/sampleapps/bigbank/account/src/main/java/bigbank/account/services/accountdata/AccountDataServiceDASImpl.java Sat Jul  8 15:57:27 2006
@@ -67,9 +67,9 @@
             DAS das = DAS.FACTORY.createDAS(mapping, conn);
             
             Command select = das.createCommand(
-                    "SELECT firstName, lastName, loginID, password, id FROM customers where loginID = :loginID");
+                    "SELECT firstName, lastName, loginID, password, id FROM customers where loginID = ?");
                  
-            select.setParameterValue("loginID", logonID);       
+            select.setParameter(1, logonID);       
 
             DataObject root = select.executeQuery();
             conn.close();
@@ -98,9 +98,9 @@
 
         Connection conn = getConnection();
         DAS das = DAS.FACTORY.createDAS(mapping, conn);
-        Command select = das.createCommand("SELECT firstName, lastName, loginID, password, id FROM customers where loginID = :loginID");
+        Command select = das.createCommand("SELECT firstName, lastName, loginID, password, id FROM customers where loginID = ?");
              
-        select.setParameterValue("loginID", logonID);     
+        select.setParameter(1, logonID);     
      
         DataObject root = select.executeQuery();
         conn.close();
@@ -184,8 +184,8 @@
             Connection conn = getConnection();
             DAS das = DAS.FACTORY.createDAS(mapping, conn);
           
-            Command select = das.createCommand("SELECT accountNumber, accountType, balance FROM accounts where id = :id");                 
-            select.setParameterValue("id", customerID);
+            Command select = das.createCommand("SELECT accountNumber, accountType, balance FROM accounts where id = ?");                 
+            select.setParameter(1, customerID);
              
             DataObject root = select.executeQuery();
             accountReport.getAccountSummaries().addAll(root.getList("AccountSummary"));
@@ -193,8 +193,8 @@
             // Get Stocks
 
             select = das.createCommand(
-                    "SELECT Symbol, quantity, purchasePrice, purchaseDate, purchaseLotNumber  FROM stocks where id = :id");           
-            select.setParameterValue("id", customerID);            
+                    "SELECT Symbol, quantity, purchasePrice, purchaseDate, purchaseLotNumber  FROM stocks where id = ?");           
+            select.setParameter(1, customerID);            
 
             // select.addConverter("STOCKS.PURCHASEDATE", DateConverter.class.getName());
 
@@ -223,8 +223,8 @@
         	Connection conn = getConnection();
         	DAS das = DAS.FACTORY.createDAS(createConfigStream(), conn);        
 
-            Command select = das.createCommand("SELECT accountNumber, balance FROM accounts where accountNumber = :accountNumber");         
-            select.setParameterValue("accountNumber", account);
+            Command select = das.createCommand("SELECT accountNumber, balance FROM accounts where accountNumber = ?");         
+            select.setParameter(1, account);
                       
             DataObject root = select.executeQuery();
             Collection accounts = root.getList("AccountSummary");
@@ -234,8 +234,8 @@
             // update department set companyid = ? where department.name = ?
             
             Command update = das.getCommand("update balance");           
-            update.setParameterValue("BALANCE", new Float(newbalance));
-            update.setParameterValue("ACCOUNTNUMBER", account);
+            update.setParameter(1, new Float(newbalance));
+            update.setParameter(2, account);
             update.execute();
             conn.close();
             return newbalance;
@@ -250,7 +250,7 @@
             DAS das = DAS.FACTORY.createDAS(createConfigStream(), getConnection());          
 
             Command read = das.getCommand("stockbylotSelect");          
-            read.setParameterValue("PURCHASELOTNUMBER", purchaseLotNumber);// autoboxing :-)
+            read.setParameter(1, purchaseLotNumber);// autoboxing :-)
             DataObject root =  read.executeQuery();
             List stocks = root.getList("StockSummary");
             if (null != stocks && !stocks.isEmpty()) {
@@ -259,15 +259,15 @@
                 if (newQuatity < 1) {
 
                     Command delete = das.createCommand("DELETE FROM STOCKS WHERE PURCHASELOTNUMBER = ?");
-                    delete.setParameterValue(1, purchaseLotNumber);                   
+                    delete.setParameter(1, purchaseLotNumber);                   
                     delete.execute();
 
                 } else {
 
                     Command update = das.getCommand("stockbylot");
 
-                    update.setParameterValue("QUANTITY", newQuatity);
-                    update.setParameterValue("PURCHASELOTNUMBER", purchaseLotNumber);
+                    update.setParameter(1, newQuatity);
+                    update.setParameter(2, purchaseLotNumber);
                     update.execute();
 
                     stock.setQuantity(newQuatity);
@@ -287,11 +287,11 @@
         	DAS das = DAS.FACTORY.createDAS(getConnection());
             Command insert = das
                     .createCommand("insert into stocks (id, symbol, quantity, purchasePrice, purchaseDate) values (?,?,?,?,?)");
-            insert.setParameterValue(1, new Integer(id));
-            insert.setParameterValue(2, stock.getSymbol());
-            insert.setParameterValue(3, stock.getQuantity());
-            insert.setParameterValue(4, stock.getPurchasePrice());
-            insert.setParameterValue(5, DateConverter.INSTANCE.getColumnValue(stock.getPurchaseDate()));
+            insert.setParameter(1, new Integer(id));
+            insert.setParameter(2, stock.getSymbol());
+            insert.setParameter(3, stock.getQuantity());
+            insert.setParameter(4, stock.getPurchasePrice());
+            insert.setParameter(5, DateConverter.INSTANCE.getColumnValue(stock.getPurchaseDate()));
         
             insert.execute();
 

Modified: incubator/tuscany/java/sampleapps/bigbank/account/src/main/java/bigbank/account/services/accountdb/AccountDBInit.java
URL: http://svn.apache.org/viewvc/incubator/tuscany/java/sampleapps/bigbank/account/src/main/java/bigbank/account/services/accountdb/AccountDBInit.java?rev=420214&r1=420213&r2=420214&view=diff
==============================================================================
--- incubator/tuscany/java/sampleapps/bigbank/account/src/main/java/bigbank/account/services/accountdb/AccountDBInit.java (original)
+++ incubator/tuscany/java/sampleapps/bigbank/account/src/main/java/bigbank/account/services/accountdb/AccountDBInit.java Sat Jul  8 15:57:27 2006
@@ -311,9 +311,9 @@
         InputStream mapping = createConfigStream();
         Connection conn = createConnection();
         DAS das = DAS.FACTORY.createDAS(mapping, conn);
-        Command select = das.createCommand("SELECT firstName, lastName, loginID, password, id FROM customers where loginID = :loginID");
+        Command select = das.createCommand("SELECT firstName, lastName, loginID, password, id FROM customers where loginID = ?");
               
-        select.setParameterValue("loginID", logonID); 
+        select.setParameter(1, logonID); 
 
         DataObject root = select.executeQuery();
         conn.close();
@@ -390,9 +390,9 @@
 
     	Connection conn = createConnection();
     	DAS das = DAS.FACTORY.createDAS(createConfigStream(), conn);
-        Command select = das.createCommand("SELECT accountNumber, balance FROM accounts where accountNumber = :accountNumber");
+        Command select = das.createCommand("SELECT accountNumber, balance FROM accounts where accountNumber = ?");
               
-        select.setParameterValue("accountNumber", wd.getAccountNumber()); 
+        select.setParameter(1, wd.getAccountNumber()); 
 
         DataObject root = select.executeQuery();
 
@@ -404,8 +404,8 @@
 
        
         Command update = das.getCommand("update balance");
-        update.setParameterValue("BALANCE", new Float(newbalance));
-        update.setParameterValue("ACCOUNTNUMBER", wd.getAccountNumber());
+        update.setParameter(1, new Float(newbalance));
+        update.setParameter(2, wd.getAccountNumber());
 
         update.execute();
         conn.close();

Modified: incubator/tuscany/java/sampleapps/bigbank/account/src/main/java/bigbank/account/services/accountlogger/AccountLoggerServiceImpl.java
URL: http://svn.apache.org/viewvc/incubator/tuscany/java/sampleapps/bigbank/account/src/main/java/bigbank/account/services/accountlogger/AccountLoggerServiceImpl.java?rev=420214&r1=420213&r2=420214&view=diff
==============================================================================
--- incubator/tuscany/java/sampleapps/bigbank/account/src/main/java/bigbank/account/services/accountlogger/AccountLoggerServiceImpl.java (original)
+++ incubator/tuscany/java/sampleapps/bigbank/account/src/main/java/bigbank/account/services/accountlogger/AccountLoggerServiceImpl.java Sat Jul  8 15:57:27 2006
@@ -53,10 +53,10 @@
     public void logDeposit(int id, String account, float amount) throws RemoteException {
         DAS das = DAS.FACTORY.createDAS(getConnection());
         Command insert = das.createCommand("insert into acctLog (id, accountNumber, actionType, amount) values (?,?,?,?)");
-        insert.setParameterValue(1, new Integer(id));
-        insert.setParameterValue(2, account);
-        insert.setParameterValue(3, ACCT_ACTION_TYPE_DEPOSIT);
-        insert.setParameterValue(4, new Float(amount));
+        insert.setParameter(1, new Integer(id));
+        insert.setParameter(2, account);
+        insert.setParameter(3, ACCT_ACTION_TYPE_DEPOSIT);
+        insert.setParameter(4, new Float(amount));
      
         insert.execute();
 /*
@@ -67,10 +67,10 @@
     public void logWithdrawal(int id, String account, float amount) throws RemoteException {
         DAS das = DAS.FACTORY.createDAS(getConnection());
         Command insert = das.createCommand("insert into acctLog (id, accountNumber, actionType, amount) values (?,?,?,?)");
-        insert.setParameterValue(1, new Integer(id));
-        insert.setParameterValue(2, account);
-        insert.setParameterValue(3, ACCT_ACTION_TYPE_WITHDRAW);
-        insert.setParameterValue(4, new Float(amount));
+        insert.setParameter(1, new Integer(id));
+        insert.setParameter(2, account);
+        insert.setParameter(3, ACCT_ACTION_TYPE_WITHDRAW);
+        insert.setParameter(4, new Float(amount));
     
         insert.execute();
         /*
@@ -81,11 +81,11 @@
     public void logPurchaseStock(int id, StockSummary stock) throws RemoteException {
         DAS das = DAS.FACTORY.createDAS(getConnection());
         Command insert = das.createCommand("insert into stockLog (id, Symbol, quantity, actionType, purchaseLotNumber) values (?,?,?,?,?)");
-        insert.setParameterValue(1, new Integer(id));
-        insert.setParameterValue(2, stock.getSymbol());
-        insert.setParameterValue(3, new Integer(stock.getQuantity()));
-        insert.setParameterValue(4, STOCK_ACTION_TYPE_PURCHASE);
-        insert.setParameterValue(5, new Integer(stock.getPurchaseLotNumber()));
+        insert.setParameter(1, new Integer(id));
+        insert.setParameter(2, stock.getSymbol());
+        insert.setParameter(3, new Integer(stock.getQuantity()));
+        insert.setParameter(4, STOCK_ACTION_TYPE_PURCHASE);
+        insert.setParameter(5, new Integer(stock.getPurchaseLotNumber()));
        
         insert.execute();
         /*
@@ -99,11 +99,11 @@
         String symbol = ((stock.getSymbol()!=null)?stock.getSymbol():"null");
         DAS das = DAS.FACTORY.createDAS(getConnection());
         Command insert = das.createCommand("insert into stockLog (id, Symbol, quantity, actionType, purchaseLotNumber) values (?,?,?,?,?)");
-        insert.setParameterValue(1, new Integer(id));
-        insert.setParameterValue(2, symbol);
-        insert.setParameterValue(3, new Integer(quantity));
-        insert.setParameterValue(4, STOCK_ACTION_TYPE_SELL);
-        insert.setParameterValue(5, new Integer(stock.getPurchaseLotNumber()));
+        insert.setParameter(1, new Integer(id));
+        insert.setParameter(2, symbol);
+        insert.setParameter(3, new Integer(quantity));
+        insert.setParameter(4, STOCK_ACTION_TYPE_SELL);
+        insert.setParameter(5, new Integer(stock.getPurchaseLotNumber()));
       
         insert.execute();
         /*
@@ -178,16 +178,16 @@
 
             Connection conn = getConnection();
             DAS das = DAS.FACTORY.createDAS(mapping, conn);
-            Command select = das.createCommand("SELECT logSeqNo, accountNumber, actionType, amount FROM acctLog where id = :id");
+            Command select = das.createCommand("SELECT logSeqNo, accountNumber, actionType, amount FROM acctLog where id = ?");
                       
-            select.setParameterValue("id", customerID);
+            select.setParameter(1, customerID);
         
             DataObject root = select.executeQuery();
             accountLog.getAccountLogEntries().addAll(root.getList("AccountLogEntry"));
 
             select = das.createCommand(
-                    "SELECT logSeqNo, Symbol, quantity, actionType, purchaseLotNumber  FROM stockLog where id = :id");          
-            select.setParameterValue("id", customerID);       
+                    "SELECT logSeqNo, Symbol, quantity, actionType, purchaseLotNumber  FROM stockLog where id = ?");          
+            select.setParameter(1, customerID);       
             root =  select.executeQuery();
             accountLog.getStockLogEntries().addAll(root.getList("StockLogEntry"));
 

Modified: incubator/tuscany/java/sampleapps/bigbank/account/src/main/resources/DasAccountConfiguration.xml
URL: http://svn.apache.org/viewvc/incubator/tuscany/java/sampleapps/bigbank/account/src/main/resources/DasAccountConfiguration.xml?rev=420214&r1=420213&r2=420214&view=diff
==============================================================================
--- incubator/tuscany/java/sampleapps/bigbank/account/src/main/resources/DasAccountConfiguration.xml (original)
+++ incubator/tuscany/java/sampleapps/bigbank/account/src/main/resources/DasAccountConfiguration.xml Sat Jul  8 15:57:27 2006
@@ -66,21 +66,17 @@
 
 	
   <Command name="update balance"
-        SQL="update ACCOUNTS set BALANCE = :BALANCE where ACCOUNTNUMBER = :ACCOUNTNUMBER"
+        SQL="update ACCOUNTS set BALANCE = ? where ACCOUNTNUMBER = ?"
         kind="Update">
-        <Parameter name=":BALANCE"/>
-        <Parameter name=":ACCOUNTNUMBER"/>
    </Command>
     
     
     <Command name="all stocks" SQL="select * from stocks"  kind="Select"/>
     <Command name="all customers" SQL="select  from CUSTOMERS"  kind="Select"/>
-    <Command name="stockbylotSelect" SQL="select quantity  from STOCKS  WHERE purchaseLotNumber = :PURCHASELOTNUMBER"  kind="Select" >
+    <Command name="stockbylotSelect" SQL="select quantity  from STOCKS  WHERE purchaseLotNumber = ?"  kind="Select" >
     	<Parameter name=":PURCHASELOTNUMBER"/>
     </Command>
-    <Command name="stockbylot" SQL="update STOCKS set quantity = :QUANTITY WHERE purchaseLotNumber = :PURCHASELOTNUMBER"  kind="Update" >
-        <Parameter name=":QUANTITY"/>
-        <Parameter name=":PURCHASELOTNUMBER"/>
+    <Command name="stockbylot" SQL="update STOCKS set quantity = ? WHERE purchaseLotNumber = ?"  kind="Update" >
     </Command>
 	
 </Config>



---------------------------------------------------------------------
To unsubscribe, e-mail: tuscany-commits-unsubscribe@ws.apache.org
For additional commands, e-mail: tuscany-commits-help@ws.apache.org