pymysql存储数据库

import pymysql

try:
    conn = pymysql.connect(
        host='localhost',
        user='your_username',
        password='your_password',
        db='your_database',
        charset='utf8mb4',
        cursorclass=pymysql.cursors.DictCursor
    )
except pymysql.OperationalError as e:
    print(f"Error: {e}")

try:
    with conn.cursor() as cursor:
        sql = "SELECT * FROM your_table"
        cursor.execute(sql)
        result = cursor.fetchall()
except pymysql.ProgrammingError as e:
    print(f"Error: {e}")

try:
    with conn.cursor() as cursor:
        sql1 = "INSERT INTO your_table (id, name) VALUES (1, 'Alice')"
        sql2 = "INSERT INTO your_table (id, name) VALUES (1, 'Bob')"
        cursor.execute(sql1)
        cursor.execute(sql2)
        conn.commit()
except pymysql.IntegrityError as e:
    print(f"Error: {e}")
    conn.rollback()