mysql中为什么要关闭光标_Python mysql光标.关闭() 数据库关闭()

在我的应用程序中，我正在打开、访问、写入等到不同类和线程中的数据库。我有一个数据库self.run_params["db"]，我正在整个应用程序中使用它进行访问。在

问题1：每次单独访问后我都应该关闭光标吗？在

问题2：我的应用程序一直在运行，并且在不同的点访问数据库，所以我应该在每次访问之后关闭数据库，还是只在应用程序退出时关闭数据库？在import MySQLdb

import warnings

warnings.filterwarnings('ignore')

self.run_params = {}

self.run_params["databaseName"] = "transporterDatabase"

self.run_params["tableName"] = "transporterTable"

## Create databse if not already exist ##

db = MySQLdb.connect(host="localhost",

user="root",

passwd="password")

cur = db.cursor()

cur.execute("CREATE DATABASE IF NOT EXISTS " + self.run_params["databaseName"])

db.close()

## Create table if not already exist ##

self.run_params["db"] = MySQLdb.connect(host="localhost",

user="root",

passwd="password",

db=self.run_params["databaseName"])

cur = self.run_params["db"].cursor()

cur.execute("CREATE TABLE IF NOT EXISTS " + self.run_params["tableName"] + "(jobID INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(jobID), location VARCHAR(5000), mode VARCHAR(50), process VARCHAR(10), status VARCHAR(30), title VARCHAR(500), vendorID VARCHAR(100), provider VARCHAR(100), packageType VARCHAR(50), assetUpdate VARCHAR(5), folderSubmission VARCHAR(5), submitTime VARCHAR(50), priority VARCHAR(5));")

cur.close()

######################

## Use database info ##

cur = self.params["db"].cursor()

cur.execute("SELECT * FROM %s order by %s" % (self.params["tableName"], 'priority'))

for row in cur.fetchall() :

jobID = row[0]

indir1 = row[1]

runningMode = row[2]

process = row[3]

status = row[4]

title = row[5]

vendorID = row[6]

provider = row[7]

packageType = row[8]

assetUpdate = row[9]

folderSubmission = row[10]

cur.close()