mysql加密 decode

from Crypto.Cipher import AES
from Crypto.Util.Padding import pad, unpad
import base64

# 密钥和初始化向量（IV）
key = b'This is a secret key'
iv = b'This is an IV456'

# 加密函数
def encrypt(plaintext):
    cipher = AES.new(key, AES.MODE_CBC, iv)
    padded_text = pad(plaintext.encode('utf-8'), AES.block_size)
    ciphertext = cipher.encrypt(padded_text)
    return base64.b64encode(ciphertext).decode('utf-8')

# 解密函数
def decrypt(ciphertext):
    cipher = AES.new(key, AES.MODE_CBC, iv)
    decoded_text = base64.b64decode(ciphertext)
    decrypted_text = cipher.decrypt(decoded_text)
    return unpad(decrypted_text, AES.block_size).decode('utf-8')

# 示例
plaintext = "Hello, World!"
encrypted_text = encrypt(plaintext)
print(f"Encrypted Text: {encrypted_text}")

decrypted_text = decrypt(encrypted_text)
print(f"Decrypted Text: {decrypted_text}")