只用mysql实现银行转账_基于mysql数据库银行转账功能实现

import pymysql

class TransferMoney(object):

# 构造方法

def __init__(self, conn):

self.conn = conn

self.cur = conn.cursor()

def transfer(self, source_id, target_id, money):

# 1). 判断两个银行卡号是否存在?

# 2). 判断source_id是否有足够的钱？

# 3). source_id扣钱

# 4). target_id加钱

if not self.check_account_avaialbe(source_id):

raise Exception("账户不存在")

if not self.check_account_avaialbe(target_id):

raise Exception("账户不存在")

if self.has_enough_money(source_id, money):

try:

self.reduce_money(source_id, money)

self.add_money(target_id, money)

except Exception as e:

print("转账失败:", e)

self.conn.rollback()

else:

self.conn.commit()

print("%s给%s转账%s金额成功" % (source_id, target_id, money))

def check_account_avaialbe(self, acc_id