import sqlite3
conn = sqlite3.connect('test.db')
print ("数据库打开成功")
c = conn.cursor()
#c.execute("create table book(id INTEGER PRIMARY KEY,name char(250),price int)")
c.execute("insert into book(name,price) values('我的前半生',100),('我的后半生',200)")
#c.execute("CREATE TABLE COMPANY(ID INT PRIMARY KEY NOT NULL,NAME TEXT,AGE INT,ADDRESS CHAR(50),SALARY REAL);")
#print ("数据表创建成功")
cursor=c.execute("select * from book where price=100")
for row in cursor:
print(row)
conn.commit()
conn.close()
Python sqlite3的使用方法