Table of Contents
1. 数据库文件管理工具
SQLiteManager
建表、添加记录,并保持数据库文件到本地电脑,我的路径:
E:\python\python project\SQLITE\mydatabase.sqlite
2. 编码测试数据库
2.1 流程
2.2 代码
import sqlite3
#连接数据库
conn = sqlite3.connect("E:\python\python project\SQLITE\mydatabase.db")
#创建数据库表
conn.execute("create table if not exists address (id integer primary key autoincrement, name varchar(128), address varchar(128))")
#插入数据
conn.execute("insert into address(name, address) values ('chenliang1', 'shenzen')")
conn.execute("insert into address(name, address) values ('chenliang2', 'shenzen')")
#提交数据
conn.commit()
#获取游标对象
cur = conn.cursor()
#使用游标查询所有数据
cur.execute("select * from address")
#获取所有结果
res = cur.fetchall()
#打印所有结果
print("address:", res)
#按照元组的形式输出数据
for line in res:
for f in line:
print(f)
print()
#关闭游标
cur.close()
#关闭连接
conn.close()
2.3 结果
C:\Python\Python38\python.exe "E:/python/python project/hello world.py"
address: [(1, 'chenliang1', 'shenzen'), (2, 'chenliang2', 'shenzen'), (3, 'chenliang1', 'shenzen'), (4, 'chenliang2', 'shenzen')]
1
chenliang1
shenzen
2
chenliang2
shenzen
3
chenliang1
shenzen
4
chenliang2
shenzen