开始
doadmin.Database().__init__()
班级
class Database(object):
connection = None
cursor = None
def get_c(self):
return self.cursor
def __init__(self):
if Database.connection is None:
try:
Database.connection = mysql.connector.connect(host="stuff", user="stuff", password="stuff",
database="stuff", port=stuff)
Database.cursor = Database.connection.cursor()
except Exception as error:
print("Error: Connection not established {}".format(error))
else:
print("Connection established")
self.connection = Database.connection
self.cursor = Database.cursor
要求
cursor1 = Database().get_c()
cursor1.execute("SELECT * FROM posts")
posts = list(cursor1)