Python可以通过各种库和框架与数据库进行交互，例如`sqlite3`、`MySQLdb`、`psycopg2`、`pymongo`等。这些库提供了用于执行SQL查询、插入、更新和删除数据的函数和方法，使得Python程序可以轻松地与数据库进行交互。以下以与MySQL数据库交互为例，介绍常见的操作及代码示例： #### 连接数据库 使用`mysql-connector-python`库来连接MySQL数据库。首先需要安装该库： ```bash pip install mysql-connector-python ``` 连接数据库的代码示例： ```python import mysql.connector # 建立数据库连接 mydb = mysql.connector.connect( host="localhost", user="your_username", password="your_password", database="your_database" ) # 创建游标对象 mycursor = mydb.cursor() ``` #### 执行查询操作 ```python # 执行SQL查询语句 mycursor.execute("SELECT * FROM your_table") # 获取查询结果 results = mycursor.fetchall() # 遍历结果 for row in results: print(row) ``` #### 插入数据 ```python # 插入单条数据 sql = "INSERT INTO your_table (column1, column2) VALUES (%s, %s)" val = ("value1", "value2") mycursor.execute(sql, val) # 插入多条数据 sql = "INSERT INTO your_table (column1, column2) VALUES (%s, %s)" val = [ ("value1", "value2"), ("value3", "value4") ] mycursor.executemany(sql, val) # 提交事务 mydb.commit() print(mycursor.rowcount, "record inserted.") ``` #### 更新数据 ```python # 更新数据 sql = "UPDATE your_table SET column1 = %s WHERE column2 = %s" val = ("new_value", "old_value") mycursor.execute(sql, val) # 提交事务 mydb.commit() print(mycursor.rowcount, "record(s) affected") ``` #### 删除数据 ```python # 删除数据 sql = "DELETE FROM your_table WHERE column1 = %s" val = ("value_to_delete",) mycursor.execute(sql, val) # 提交事务 mydb.commit() print(mycursor.rowcount, "record(s) deleted") ```