javaweb-How to prevent multi-users at the same time snapping up the same goods, to prevent high concurrency while the same commodity, Daniel gave you accumulated knowledge it? Ask

Javawebphpupdatejava

Recently in the snapping system, but the headache is that in multi-user high concurrency situation often inventory problems. troubleshooting, at the same time multi-user orders cause the query and insert is not synchronized, and the query with the insertion and the time difference in the case of high concurrency caused inventory problems (my project is probably this, first for update to find the Product information table, put into the global table array, when the user debit balance successful, The Update commodity Information table subtracts the number of orders that the user has. MySQL database, query the product information table is locked, but more and more information table data when the query has a time lag, resulting in high concurrency when querying the product information table into the variable array, in the implementation of the time lag, other users in the next order, resulting in inventory problems. Now ask questions, the same product at the same time to prevent multi-user snapping, that is, in the same second in the case of high concurrency can only be a single user orders, the current idea is queued, blocking the queue. But the concrete realization idea is how or whether the Daniel has the better method, and realizes the thought is how, has the case the best. The implementation language is PHP. Ask you to solve the solution

