flask连接sqlite
时间: 2023-11-19 20:04:07 浏览: 38
好的,关于flask连接sqlite,你需要先安装flask和sqlite3模块,然后在flask应用中使用sqlite3连接数据库。具体步骤如下:
1. 安装flask和sqlite3模块:
```
pip install flask
pip install sqlite3
```
2. 在flask应用中导入sqlite3模块,并连接数据库:
```
import sqlite3
from flask import Flask
app = Flask(__name__)
# 连接数据库
conn = sqlite3.connect('test.db')
```
3. 创建表格并插入数据:
```
# 创建表格
conn.execute('''CREATE TABLE STUDENT
(ID INT PRIMARY KEY NOT NULL,
NAME TEXT NOT NULL,
AGE INT NOT NULL);''')
# 插入数据
conn.execute("INSERT INTO STUDENT (ID,NAME,AGE) \
VALUES (1, 'Tom', 18)")
conn.execute("INSERT INTO STUDENT (ID,NAME,AGE) \
VALUES (2, 'Jerry', 19)")
# 提交更改
conn.commit()
```
4. 查询数据:
```
cursor = conn.execute("SELECT id, name, age from STUDENT")
for row in cursor:
print("ID = ", row[0])
print("NAME = ", row[1])
print("AGE = ", row[2], "\n")
```
完整代码如下:
```
import sqlite3
from flask import Flask
app = Flask(__name__)
# 连接数据库
conn = sqlite3.connect('test.db')
# 创建表格
conn.execute('''CREATE TABLE STUDENT
(ID INT PRIMARY KEY NOT NULL,
NAME TEXT NOT NULL,
AGE INT NOT NULL);''')
# 插入数据
conn.execute("INSERT INTO STUDENT (ID,NAME,AGE) \
VALUES (1, 'Tom', 18)")
conn.execute("INSERT INTO STUDENT (ID,NAME,AGE) \
VALUES (2, 'Jerry', 19)")
# 提交更改
conn.commit()
# 查询数据
cursor = conn.execute("SELECT id, name, age from STUDENT")
for row in cursor:
print("ID = ", row[0])
print("NAME = ", row[1])
print("AGE = ", row[2], "\n")
# 关闭连接
conn.close()
```