mysql数据库图书管理系统

INSERT INTO books (title, author, publisher, publish_date, isbn)
VALUES ('《计算机程序设计基础》', '张三', '人民邮电出版社', '2023-01-01', '978-7-115-50987-4');

import mysql.connector

db_config = {
    'host': 'localhost',
    'user': 'root',
    'password': 'your_password',
    'database': 'library'
}

try:
    conn = mysql.connector.connect(**db_config)
    cursor = conn.cursor()
    
    add_book_query = ("INSERT INTO books "
                      "(title, author, publisher, publish_date, isbn) "
                      "VALUES (%s, %s, %s, %s, %s)")
    book_data = ('《计算机程序设计基础》', '张三', '人民邮电出版社', '2023-01-01', '978-7-115-50987-4')
    
    cursor.execute(add_book_query, book_data)
    conn.commit()
    
    print(cursor.rowcount, "条记录插入成功。")
except mysql.connector.Error as err:
    print("数据库操作失败：", err)
finally:
    if conn.is_connected():
        cursor.close()
        conn.close()