Python3操作sqlite3数据库的常规用法

"""
作者：皮蛋编程（https://www.pidancode.com）
创建日期：2022/3/16
修改日期：2022/3/16
功能描述：Python3操作sqlite3数据库的常规用法
"""
from sqlite3 import dbapi2 as sqlite
# 创建数据库:
con = sqlite.connect('pidancode.com.db')
cur = con.cursor()
# 创建表:
cur.execute('create table clients (id INT PRIMARY KEY, name CHAR(60))')
# 插入一行数据:
client = (5, "皮蛋编程")
cur.execute("insert into clients (id, name) values (?, ?)", client)
con.commit()
# 一次插入多行数据:
clients = [(7, "皮蛋编程"),
           (8, "pidancode.com"),
           (9, "Python开发")
           ]
cur.executemany("insert into clients (id, name) values (?, ?)", clients)
con.commit()
cur.close()
con.close()
# 下面的代码对数据库进行连接查询
from sqlite3 import dbapi2 as sqlite
# 连接一个已经存在的数据
con = sqlite.connect('pidancode.com.db')
cur = con.cursor()
# 逐行获取数据
print("Row by row:")
cur.execute('select id, name from clients order by name;')
row = cur.fetchone()
while row:
    print(row)
    row = cur.fetchone()
# 一次获取所有的数据:
print("一次输出所有数据:")
cur.execute('select id, name from clients order by name;')
print(cur.fetchall())
# 关闭数据库连接
cur.close()
con.close()