pycharm连接sqlite3数据库代码,详细代码实现
时间: 2024-05-05 11:16:39 浏览: 10
以下是在PyCharm中连接SQLite3数据库的详细代码实现:
1. 导入所需模块:
```
import sqlite3
```
2. 创建连接对象并打开数据库:
```
# 连接到数据库文件
conn = sqlite3.connect('test.db')
```
3. 创建游标对象:
```
# 创建游标
cursor = conn.cursor()
```
4. 创建数据表:
```
# 创建数据表
cursor.execute('''CREATE TABLE students
(id INT PRIMARY KEY NOT NULL,
name TEXT NOT NULL,
age INT NOT NULL);''')
```
5. 插入数据:
```
# 插入数据
cursor.execute("INSERT INTO students (id, name, age) \
VALUES (1, 'Tom', 20)")
```
6. 提交事务:
```
# 提交事务
conn.commit()
```
7. 查询数据:
```
# 查询数据
cursor.execute("SELECT id, name, age from students")
for row in cursor:
print("ID = ", row[0])
print("NAME = ", row[1])
print("AGE = ", row[2], "\n")
```
8. 关闭游标和连接:
```
# 关闭游标和连接
cursor.close()
conn.close()
```
完整代码如下:
```
import sqlite3
# 连接到数据库文件
conn = sqlite3.connect('test.db')
# 创建游标
cursor = conn.cursor()
# 创建数据表
cursor.execute('''CREATE TABLE students
(id INT PRIMARY KEY NOT NULL,
name TEXT NOT NULL,
age INT NOT NULL);''')
# 插入数据
cursor.execute("INSERT INTO students (id, name, age) \
VALUES (1, 'Tom', 20)")
# 提交事务
conn.commit()
# 查询数据
cursor.execute("SELECT id, name, age from students")
for row in cursor:
print("ID = ", row[0])
print("NAME = ", row[1])
print("AGE = ", row[2], "\n")
# 关闭游标和连接
cursor.close()
conn.close()
```