Examples of org.apache.derbyTesting.system.oe.model.OrderLine

Package org.apache.derbyTesting.system.oe.model

Examples of org.apache.derbyTesting.system.oe.model.OrderLine

org.apache.derbyTesting.system.oe.model.OrderLine
An Order Entry order line item.
Fields map to definition in TPC-C for the ORDERLINE table. The Java names of fields do not include the OL_ prefix and are in lower case.
All fields have Java bean setters and getters.
Fields that are DECIMAL in the database map to String in Java (rather than BigDecimal) to allow running on J2ME/CDC/Foundation.
Primary key maps to {Order,id}, it is assumed that an OrderLine object exists in the context of an Order object, thus the columns {OL_O_ID, OL_D_ID, OL_W_ID} are not represented in this class.
An OrderLine object may sparsely populated, when returned from a business transaction it is only guaranteed to contain the information required to display the result of that transaction.

        osOrderLineItems.setInt(3, order.getId());
        rs = osOrderLineItems.executeQuery();
        int oli = 0;
        while (rs.next())
        {
            OrderLine ol = new OrderLine();
            ol.setI_id(rs.getInt("OL_I_ID"));
            ol.setSupply_w_id(rs.getShort("OL_SUPPLY_W_ID"));
            ol.setQuantity(rs.getShort("OL_QUANTITY"));
            ol.setAmount(rs.getString("OL_AMOUNT"));
            ol.setDelivery_d( rs.getTimestamp("OL_DELIVERY_D"));
            
            lineItems[oli++] = ol;
        }
        rs.close();
        conn.commit();

View Full Code Here

        osOrderLineItems.setInt(3, order.getId());
        rs = osOrderLineItems.executeQuery();
        int oli = 0;
        while (rs.next())
        {
            OrderLine ol = new OrderLine();
            ol.setI_id(rs.getInt("OL_I_ID"));
            ol.setSupply_w_id(rs.getShort("OL_SUPPLY_W_ID"));
            ol.setQuantity(rs.getShort("OL_QUANTITY"));
            ol.setAmount(rs.getString("OL_AMOUNT"));
            ol.setDelivery_d( rs.getTimestamp("OL_DELIVERY_D"));
            
            lineItems[oli++] = ol;
        }
        rs.close();
        conn.commit();

View Full Code Here

        osOrderLineItems.setInt(3, order.getId());
        rs = osOrderLineItems.executeQuery();
        int oli = 0;
        while (rs.next())
        {
            OrderLine ol = new OrderLine();
            ol.setI_id(rs.getInt("OL_I_ID"));
            ol.setSupply_w_id(rs.getShort("OL_SUPPLY_W_ID"));
            ol.setQuantity(rs.getShort("OL_QUANTITY"));
            ol.setAmount(rs.getString("OL_AMOUNT"));
            ol.setDelivery_d( rs.getTimestamp("OL_DELIVERY_D"));
            
            lineItems[oli++] = ol;
        }
        rs.close();
        conn.commit();

View Full Code Here

TOP

Related Classes of org.apache.derbyTesting.system.oe.model.OrderLine

org.apache.derbyTesting.system.oe.direct.Standard

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.