Python MySQL：简易银行账户操作（存取款转账）

#coding=utf-8

import MySQLdb

class NewAccount(object):
    def __init__(self,conn):
        self.conn=conn
    def New_Account(self,number,passwd,money):
        cursor = self.conn.cursor()
        
        sql_insert = "insert into account(AccNumber,AccPasswd,AccMoney) values(%s,%s,%s)" % (number,passwd,money)
        try:
            
            cursor.execute(sql_insert)
            self.conn.commit()
            print "创建新账户成功"
        except Exception as e:
            self.conn.rollback()
            print "创建新账户失败"
            raise e
        finally:
            cursor.close()


class SaveMoney(object):
    def __init__(self,conn):
        self.conn = conn
    def Save_Money(self,number,money):
        cursor = self.conn.cursor()
        sql_save = "update account set AccMoney=AccMoney+%s where AccNumber=%s"% (money,number)  

        try:
            cursor.execute(sql_save)
            self.conn.commit()
            print "存款成功"  
            
            if cursor.rowcount !=1:
                raise Exception("账号%s存款失败"%number) 
        finally:
            cursor.close()
         
class DrawMoney(object):
    def __init__(self,conn):
        self.conn = conn
    def Draw_Money(self,number,money):
        cursor = self.conn.cursor()
        sql_draw = "update account set AccMoney=AccMoney-%s where AccNumber=%s"% (money,number)  
        try:
            cursor.execute(sql_draw)
            self.conn.commit()
            print "取款成功"  
            
            if cursor.rowcount !=1:
                raise Exception("账号%s取款失败"%number) 
        finally:
            cursor.close()
    
         
class TransferMoney(object):
    def __init__(self,conn):
        self.conn = conn