我有以下代碼:import pymysql.cursorsclass MylocalSQL: def __init__(self): pass def get_max_report_date(self): connection = pymysql.connect(host=..., charset='utf8mb4', cursorclass=pymysql.cursors.DictCursor) try: with connection.cursor() as cursor: # Read a single record sql = "SELECT value from tab limit 1 " cursor.execute(sql) result = cursor.fetchone() print(result) finally: connection.close()if __name__ == '__main__': mysql = MylocalSQL() mysql.get_max_report_date()我想改變print(result)成return 這樣我可以這樣做:value = mysql.get_max_report_date()但是,如果我將 in 更改print(result)為return result,則將不會執行 finally 塊。有沒有更好的方法來管理連接和處理錯誤,同時能夠從查詢中返回值?
添加回答
舉報
0/150
提交
取消