问与答 利用oracle字段进行分布式锁,下面代码可以实现吗有什么问题吗

public class LockTest extends SpringTestBase {
   @Resource
   private CommonMapper commonMapper;

   @Test
   public void lock() {

      new LockThread(commonMapper, "lock1thread").start();
      new LockThread(commonMapper, "lock2thread").start();
      new LockThread(commonMapper, "lock3thread").start();
   }
}

public class LockThread extends Thread {
   private CommonMapper commonMapper;
   private String name;

   public LockThread(CommonMapper commonMapper, String name) {
      this.commonMapper = commonMapper;
      this.name = name;
   }

   @Override
   public void run() {
      super.setName(name);
      Object o = commonMapper.selectObjSql("select t.islock from mylock t where t.id='1' and t.name='test1'");
      int lock = Integer.parseInt(o.toString());
      System.out.println(lock);
      if (lock == 0) {
         System.out.println(super.getName() + "获取到了0 进行枷锁");
         int i = commonMapper.updateSql(" update mylock t set t.islock=1 where t.id='1' and t.name='test1' and t.islock='0' ");
         if (i > 0) {
            System.out.println(super.getName() + "当前线程获取到锁");
            /**
             * 需要解决并的业务代码
             */
            //释放锁
            int unlock = commonMapper.updateSql(" update mylock t set t.islock=0 where t.id='1' and t.name='test1' and t.islock='1' ");
            System.out.println(unlock > 0 ? "释放锁成功" : "释放锁失败");
         } else {
            System.out.println(super.getName() + "当前线程没有获取到锁");
         }
      } else {
         System.out.println(super.getName() + "当前线程没有获取到锁!");
      }

   }
}

测试效果是可以,不知道有没有问题,请大佬赐教.

测试结果:

lock2thread获取到了0 进行枷锁

lock1thread当前线程获取到锁

lock3thread当前线程没有获取到锁

lock2thread当前线程没有获取到锁

释放锁成功

• PHP字段的访问控制
• PHP字段的声明与使用
• PHP 私有字段 private 也可以外部访问
• PHP 获取类 / 对象的属性字段及属性值
• mysql group_concat 将单个字段用逗号连接
• 分布式 ID 生成方案总结