Automatic dispatching scheme based on database non-waiting lock mechanism

The invention discloses an automatic dispatching scheme based on a database non-waiting lock mechanism, the database non-waiting lock mechanism is adopted to solve the problem of resource scrambling, meanwhile, the problem of resource priority is solved through a user-defined sorting rule, and the database non-waiting lock mechanism comprises an architecture model of the non-waiting lock mechanism and a resource lock table. Comprising the following steps: (1) when a device requests to dispatch working hours, updating the port state of the device to Ready ToLoad; (2) acquiring related resources, and acquiring a lock by using the NAME taking the unique identifier of the resource as the lock; (3) after the lock is obtained, a record is inserted into the COMCONLOCKS; (4) carrying out business processing; (5) updating the port state of the equipment to be ReserveToLoad, which indicates that the dispatching of the equipment is completed; and (6) releasing the lock, and submitting the transaction. The dispatching ef