我需要检索最后一个“订单”并将其传递给一个邮件。

import mysql.connector
import smtplib
from email.mime.text import MIMEText
from email.mime.multipart import MIMEMultipart

# 连接到数据库
db = mysql.connector.connect(
    host="your_host",
    user="your_user",
    password="your_password",
    database="your_database"
)

cursor = db.cursor()

# 查询最后一个订单
query = "SELECT * FROM orders ORDER BY order_date DESC LIMIT 1"
cursor.execute(query)
result = cursor.fetchone()

# 关闭数据库连接
cursor.close()
db.close()

# 邮件配置
sender_email = "your_email@example.com"
receiver_email = "recipient_email@example.com"
password = "your_email_password"

message = MIMEMultipart()
message["From"] = sender_email
message["To"] = receiver_email
message["Subject"] = "Latest Order Information"

# 订单信息
order_info = f"Order ID: {result[0]}\nCustomer Name: {result[1]}\nOrder Date: {result[2]}"
message.attach(MIMEText(order_info, "plain"))

# 发送邮件
server = smtplib.SMTP('smtp.gmail.com', 587)
server.starttls()
server.login(sender_email, password)
text = message.as_string()
server.sendmail(sender_email, receiver_email, text)
server.quit()