多线程update mysql的问题

最新推荐文章于 2024-08-12 12:00:18 发布

車輪の唄

最新推荐文章于 2024-08-12 12:00:18 发布

阅读量3.3k

点赞数 1

分类专栏： hibernate

本文链接：https://blog.csdn.net/asdfsadfasdfsa/article/details/79579854

版权

hibernate 专栏收录该内容

59 篇文章 0 订阅

订阅专栏

@RunWith(SpringRunner.class)
@SpringBootTest(webEnvironment = SpringBootTest.WebEnvironment.RANDOM_PORT)
public class JunitTest {

	@Autowired
	private ProduceOrderRepository p;
	@Autowired
	private ShopCartTest s;
	@Autowired
	private TaskExecutor t;
	
	CountDownLatch status = new CountDownLatch(2);
	
	@Test
	public void test1() {
		t.execute(new InnerThread());
		t.execute(new InnerThread());
		try {
			status.await();
		} catch (InterruptedException e) {
			e.printStackTrace();
		}
	}
	
	class InnerThread implements Runnable {

		@Override
		public void run() {
			s.add();
			status.countDown();
		}
		
	}
}

@Service
public class ShopCartTest {

	@Autowired
	private ShopCartRepository shopcartRepository;
	
	public void add() {
		ShopCartDto  shopCartDto = shopcartRepository.getByUserIdAndSpecId(334l, 266l);
		try {
			TimeUnit.SECONDS.sleep(2);
		} catch (InterruptedException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		shopCartDto.setQuantity(shopCartDto.getQuantity() + 1);
		shopcartRepository.save(shopCartDto);
		System.out.println("%%%%%%%%%%%%%%%");
	}
}

先select, 根据查的结果修改实体, 然后再save, 多线程执行会发生数据异常. 对此改用update语句来修改

即, 以db中原有数值为基础进行修改数据时, 必须利用db直接对原数据update, 不可以在服务端修改数值