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