将pythin数据插入sqlite中
时间: 2024-05-15 17:15:20 浏览: 13
以下是将Python数据插入SQLite的一种方法:
1. 导入SQLite库
```python
import sqlite3
```
2. 连接到SQLite数据库
```python
conn = sqlite3.connect('database.db')
```
3. 创建一个游标对象
```python
cursor = conn.cursor()
```
4. 编写SQL语句
```python
sql = "INSERT INTO table_name (column1, column2, column3) VALUES (?, ?, ?)"
```
5. 执行SQL语句
```python
data = ("value1", "value2", "value3")
cursor.execute(sql, data)
```
6. 提交更改
```python
conn.commit()
```
完整代码示例:
```python
import sqlite3
# 连接到SQLite数据库
conn = sqlite3.connect('database.db')
# 创建一个游标对象
cursor = conn.cursor()
# 编写SQL语句
sql = "INSERT INTO table_name (column1, column2, column3) VALUES (?, ?, ?)"
# 执行SQL语句
data = ("value1", "value2", "value3")
cursor.execute(sql, data)
# 提交更改
conn.commit()
# 关闭连接
conn.close()
```