Examples of org.apache.tuscany.das.rdb.Command.executeQuery()

Class org.apache.tuscany.das.rdb.Command

Examples of org.apache.tuscany.das.rdb.Command.executeQuery()

org.apache.tuscany.das.rdb.Command.executeQuery()
Performs the function defined by the command and return the results in the root DataObject @return the root DataObject


            Command select = das.createCommand("SELECT firstName, lastName, loginID, password, id FROM customers where loginID = ?");


            select.setParameter(1, logonID);


            DataObject root = select.executeQuery();
            conn.close();


            Collection customers = root.getList("CustomerProfileData");
            CustomerProfileData customerProfileData = (CustomerProfileData) customers.iterator().next();

View Full Code Here

        try {
            DAS das = DAS.FACTORY.createDAS(createConfigStream(), getConnection());
            Command read = das.getCommand("all customers");


            // select.setDataObjectModel();
            DataObject root = read.executeQuery();


            // Create a new stockPurchase
            DataObject customer = root.createDataObject("customerProfileData");


            // THIS SEEMS TO BE THE ONLY WAY TO DO THIS .. NO WAY TO JUST ADD AN EXISTING CUSTOMER.

View Full Code Here

            DAS das = DAS.FACTORY.createDAS(mapping, conn);


            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"));


            // Get Stocks


            select = das.createCommand("SELECT Symbol, quantity, purchasePrice, purchaseDate, purchaseLotNumber  FROM stocks where id = ?");

View Full Code Here

            select = das.createCommand("SELECT Symbol, quantity, purchasePrice, purchaseDate, purchaseLotNumber  FROM stocks where id = ?");
            select.setParameter(1, customerID);


            // select.addConverter("STOCKS.PURCHASEDATE", DateConverter.class.getName());


            root = select.executeQuery();
            accountReport.getStockSummaries().addAll(root.getList("StockSummary"));


            conn.close();


            return accountReport;

View Full Code Here

            DAS das = DAS.FACTORY.createDAS(createConfigStream(), conn);


            Command select = das.createCommand("SELECT accountNumber, balance FROM accounts where accountNumber = ?");
            select.setParameter(1, account);


            DataObject root = select.executeQuery();
            Collection accounts = root.getList("AccountSummary");
            AccountSummary accountData = (AccountSummary) accounts.iterator().next();
            float newbalance = accountData.getBalance() + ammount;
            accountData.setBalance(newbalance);
            // update department set companyid = ? where department.name = ?

View Full Code Here

        try {
            DAS das = DAS.FACTORY.createDAS(createConfigStream(), getConnection());


            Command read = das.getCommand("stockbylotSelect");
            read.setParameter(1, purchaseLotNumber);// autoboxing :-)
            DataObject root = read.executeQuery();
            List stocks = root.getList("StockSummary");
            if (null != stocks && !stocks.isEmpty()) {
                StockSummary stock = (StockSummary) stocks.get(0);
                int newQuatity = Math.max(stock.getQuantity() - quantity, 0);
                if (newQuatity < 1) {

View Full Code Here

        DAS das = DAS.FACTORY.createDAS(createConfigStream(), conn);
        Command select = das.getCommand("get account");


        select.setParameter(1, wd.getAccountNumber());


        DataObject root = select.executeQuery();


        Collection accounts = root.getList("AccountSummary");
        AccountSummary account = (AccountSummary) accounts.iterator().next();
        float newbalance = account.getBalance() - wd.getAmount();
        account.setBalance(newbalance);

View Full Code Here

            SQLException {


        DAS das = DAS.FACTORY.createDAS(createConfigStream(), createConnection());
        Command read = das.getCommand("all stocks");


        DataObject root = read.executeQuery();


        // Create a new stockPurchase
        DataObject stockPurchase = root.createDataObject("StockSummary");
        stockPurchase.set("id", new Integer(sp.getId()));
        stockPurchase.set("symbol", sp.getStock().getSymbol());

View Full Code Here

        DAS das = DAS.FACTORY.createDAS(mapping, conn);
        Command select = das.createCommand("SELECT firstName, lastName, loginID, password, id FROM customers where loginID = ?");


        select.setParameter(1, logonID);


        DataObject root = select.executeQuery();
        conn.close();


        Collection customers = root.getList("CustomerProfileData");
        CustomerProfileData customerProfileData = (CustomerProfileData) customers.iterator().next();
        System.out.println(customerProfileData);

View Full Code Here

            DAS das = DAS.FACTORY.createDAS(mapping, conn);
            Command select = das.createCommand("SELECT logSeqNo, accountNumber, actionType, amount FROM acctLog where id = ?");


            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 = ?");
            select.setParameter(1, customerID);
            root = select.executeQuery();

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.