Mysql 悲观锁 乐观锁的实现

悲观锁

select * from tableName   for update 

 直到update才解锁

乐观锁 

增加version字段 更新是对比版本

update account set version  = version+1 ,deposit= deposit-#{deposit} where  #{version}=version AND id = #{id}

public void buyShop(Integer id) {
    Account account=  accountMapper.selectbyIds(1);
    int x = accountMapper.updateNum(account.getVersion(),10,1);
    if(x>0){
        System.out.println("成功 "+account.getDeposit());
    }
}