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

   
   
   
import MySQLdb
class 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"))
   
   

说明：