mysql 悲观锁

SET AUTOCOMMIT=0;

BEGIN WORK;

try{

SELECT quantity FROM products WHERE id=3 FOR UPDATE; 

UPDATE products SET quantity = '1' WHERE id=3 ; COMMIT WORK;

Commit

}catch{

Rollback

}

http://www.cnblogs.com/chenwenbiao/archive/2012/06/06/2537508.html