python内置的sqlite3模块
创建数据库
import sqlite3
con = sqlite3.connect("I:/db/db1.db") #创建了一个数据库
query = """
CREATE TABLE sales
(customer varchar(20),
product varchar(40),
amount float,
date date);
""" #创建建表的语句
con.execute(query) #执行一条语句
con.commit #每次对数据的修改,都要进行数据的提交
<function Connection.commit>
插入数据
data =[('小刚','book',2.4,'2021-07-20'),
('小明','toy',50,'2021-07-04'),
('小红','pen',23,'2021-04-21')]
statement = "INSERT INTO sales VALUES(?,?,?,?)" #?:占位符
con.executemany(statement,data) #执行多条语句
con.commit
查询数据
cursor = con.execute("SELECT * FROM sales") #将命令的结果赋给一个光标对象
rows = cursor.fetchall() #取出所有的查询结果
row_counter = 0
for row in rows:
print(row)
row_counter += 1
print("number of rows:%d"%(row_counter))
('小刚', 'book', 2.4, '2021-07-20')
('小明', 'toy', 50.0, '2021-07-04')
('小红', 'pen', 23.0, '2021-04-21')
number of rows:3