Inventory-driven optical cable order distribution method based on SQL (Structured Query Language) database

The invention discloses an inventory-driven optical cable order allocation method based on an SQL database. The method comprises the following steps: ordering orders according to priorities; accessing an SQL database, and calling inventory information; an inventory driving optical cable order distribution algorithm is applied, inventory information is matched according to order requirements, and matching conditions comprise product information, optical cable single length, printing information and pairwise length pairing; if inventory matching succeeds, the orders are allocated to inventory factories, corresponding optical cable tray numbers are matched, otherwise, the production capacity of the factories is evaluated, and the factories are selected through a roulette selection method; connecting an SQL database by using an SQL language, and updating inventory information in real time; and repeating the above operations until all order distribution is completed. Through the above mode, the order intelligent d