public void receiveShipment(int shipid) {
        try {
            PreparedStatement stmt = connection.prepareStatement("select stock_number, amount from ShippingListed where ship_id = ?");
            stmt.setInt(1, shipid);
            ResultSet rs = stmt.executeQuery();
            DepotItemModel depotItemModel = new DepotItemModel(connection);
            System.out.println("You have received a shipment.");
            
            Scanner scan = new Scanner(System.in);
            int input;
            while (rs.next()) {

                if (depotItemModel.load(rs.getString("stock_number"))) {
                  // System.out.println("old quantity: " + depotItemModel.getQuantity());
                  // 
                    int oldQuantity = depotItemModel.getQuantity();
                    System.out.println("Stock Number: " + rs.getString("stock_number") + "Previous quantity: " + 
                    oldQuantity + "Order Amount: " + rs.getInt("amount") + "New Quantity: " + depotItemModel.getQuantity());
                    
                    System.out.println("Would you like to accept shipment? Enter 1 for yes, 0 for no");
                    input = scan.nextInt();
                    if (input == 1)
                    {
                    depotItemModel.setQuantity(depotItemModel.getQuantity() + depotItemModel.getReplenish());
                    depotItemModel.setReplenish(depotItemModel.getReplenish() - rs.getInt("amount"));
                    
                    depotItemModel.update();
                    }
                }
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }