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

org.apache.derbyTesting.system.oe.model.Warehouse

An Order Entry warehouse.

Fields map to definition in TPC-C for the WAREHOUSE table. The Java names of fields do not include the W_ prefix and are in lower case.
The columns that map to an address are extracted out as a Address object with the corresponding Java field address.
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 {id}.

A Warehouse 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.

        rs.next();
        district.setName(rs.getString("D_NAME"));
        district.setAddress(getAddress(rs, "D_STREET_1"));
        reset(pyDistrictInfo);        
        
        Warehouse warehouse = new Warehouse();
        warehouse.setId(w);
        
        // Update WAREHOUSE
        pyWarehouseUpdate.setString(1, amount);
        pyWarehouseUpdate.setShort(2, w);
        pyWarehouseUpdate.executeUpdate();
        reset(pyWarehouseUpdate);
        
        // Get the required information from WAREHOUSE
        pyWarehouseInfo.setShort(1, w);
        rs = pyWarehouseInfo.executeQuery();
        rs.next();
        warehouse.setName(rs.getString("W_NAME"));
        warehouse.setAddress(getAddress(rs, "W_STREET_1"));
        reset(pyWarehouseInfo);
         
        // Insert HISTORY row
        pyHistory.setInt(1, c);
        pyHistory.setShort(2, cd);
        pyHistory.setShort(3, cw);
        pyHistory.setShort(4, d);
        pyHistory.setShort(5, w);
        pyHistory.setString(6, amount);
        StringBuffer hData = new StringBuffer(24);
        hData.append(warehouse.getName());
        hData.append("    ");
        hData.append(district.getName());
        pyHistory.setString(7, hData.toString());
        pyHistory.executeUpdate();
        reset(pyHistory);

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

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