ÊÂÎñ¡¢ÊÂÎñ²¢·¢(Èý)

2015-01-21 11:11:54 ¡¤ ×÷Õß: ¡¤ ä¯ÀÀ: 31
ewBalance < 0 ) throw new Exception("..."); //µÚÈý²½£¬¸üлáÔ±ÕË»§¼Ç¼ update account set balance = newBalance where account_id = ... //µÚËIJ½£¬ÆäËü²Ù×÷ commit
¶ÔÓÚÔö¼Ó²Ù×÷À´½²£¬ÒòΪûÓÐÉÏÏÞÏÞÖÆ£¬ËùÒÔ¿ÉÒÔÖ±½Ó¸üÐÂÔö¼ÓÁ¿¾Í¿ÉÒÔÁË¡£ÓÅ»¯ºóµÄÔö¼Ó²Ù×÷
start transaction
//µÚÒ»²½£¬¸üлáÔ±ÕË»§¼Ç¼
update account set balance = balance + changeAmount where account_id = ...
//µÚ¶þ²½£¬ÆäËü²Ù×÷
commit

¾­¹ýÉÏÃæÁ½¸öÓÅ»¯£¬ËÀËø²»ÔÙ·¢ÉúÁË£¬ÁíÍâ½Ó¿ÚµÄƽ¾ùÏìӦʱ¼äÒ²Óв»Ð¡µÄÌá¸ß¡£