Python连接SQLite3数据库示例
import sqlite3
# 打开数据库连接
conn = sqlite3.connect('D:/office_software/sqlite/data/test.db')
print("---数据库连接成功---")
conn.execute('''
CREATE TABLE product(
name text,
code text
);
''')
conn.commit
print("---数据表创建成功---")
conn.execute('''
INSERT INTO product VALUES('笔记本','110221IJ1');
''')
conn.execute('''
INSERT INTO product VALUES('魔芋爽','110231IJ1');
''')
conn.execute('''
INSERT INTO product VALUES('蓝牙耳机','110241IJ1');
''')
conn.execute('''
INSERT INTO product VALUES('茶杯','110251IJ1');
''')
conn.execute('''
INSERT INTO product VALUES('显示器','110261IJ1');
''')
conn.commit()
print("---数据写入成功---")
players = conn.execute("SELECT * FROM product ORDER BY code DESC;")
print(players) # 连接器
for player in players:
print(player)
print("---数据查询成功---")
conn.close()
注意:
- 一次执行执行一条命令,否则回报错:
sqlite3.Warning: You can only execute one statement at a time.- 数据库不论存在或不存在,都可以返回连接成功,存在了连接数据库,不存在则新建数据库;
- 执行命令很简单就使用execute方法即可,增删改查!;
- 执行完数据库记录的操作之后记得commit提交;
- 最后使用完记得关闭close连接;
- python内置有sqlite3的包,直接引用即可;