select * from user where username='zhangsna' for update 行锁
select * from user where username in ('zhangsna','lisi') for update 页锁
select * from user for update 表锁
select * from user where username='zhangsna' lock in shore mode 读锁(共享锁)
select * from user where username='zhangsna' for update 写锁(排他锁)
基于数据库乐观锁
update goods set amount=amount-#{buys} where id=#{id} and amount-#{buys}>=0