本文共 2519 字，大约阅读时间需要 8 分钟。

   
   
   
import MySQLdbclass MysqlApi(object):    def __init__(self):        pass    def information(self):        return "this is a python way to use mysqldb api!"    def look_database_version(self):        conn = MySQLdb.connect(host='localhost', user='root', passwd='123456', port=3306)        cursor = conn.cursor()        cursor.execute("SELECT VERSION()")        data = cursor.fetchall()        version = data[0][0]        cursor.close()        conn.close()        return version    def look_database(self):        conn = MySQLdb.connect(host='localhost', user='root', passwd='123456', port=3306)        cursor = conn.cursor()        cursor.execute("SHOW DATABASES")        databases = []        for result in cursor.fetchall():            databases.append(result[0])        cursor.close()        conn.close()        return databases    def create_database(self, dbname):        conn = MySQLdb.connect(host='localhost', user='root', passwd='123456', port=3306)        cursor = conn.cursor()        try:            cursor.execute(f"CREATE DATABASE {dbname}")            return f"Database {dbname} created successfully"        except Exception as e:            return f"Error creating database: {str(e)}"        finally:            cursor.close()            conn.close()    def delete_database(self, dbname):        try:            conn = MySQLdb.connect(host='localhost', user='root', passwd='123456', port=3306)            cursor = conn.cursor()            cursor.execute(f"DROP DATABASE {dbname}")            cursor.close()            conn.close()            return f"Database {dbname} deleted successfully"        except Exception as e:            return f"Error deleting database: {str(e)}"    def rename_database(self, old_db, new_db):        try:            conn = MySQLdb.connect(host='localhost', user='root', passwd='123456', port=3306)            cursor = conn.cursor()            cursor.execute(f"RENAME DATABASE {old_db} TO {new_db}")            cursor.close()            conn.close()            return f"Database {old_db} renamed to {new_db} successfully"        except Exception as e:            return f"Error renaming database: {str(e)}"api = MysqlApi()print(api.information())print(api.look_database_version())print(api.look_database())print(api.create_database("testdb"))print(api.delete_database("testdb"))print(api.rename_database("test","newtest"))
   
   

说明：