一、商品秒杀-超卖
ApiOperation(value"秒杀实现方式——Lock加锁")
PostMapping("/start/lock")
public Result startLock(long skgId){try{log.info("来时秒杀方式一");final long userId (int)(new Random().nextDouble()*(99999-100001))1…
1.方式1
SELECT object_name(A.resource_associated_entity_id) as TABLENAME, A.request_session_id AS SPID,DB_NAME(B.dbid) AS DBName,B.blocked,B.dbid,B.program_name,B.waitresource,B.lastwaittype,B.loginame,B.hostname,B.login_time,B.last_batch--,B.*
FROM sy…