周报6
fetchall()读取SQLite数据
【
05P46.py】
l fetchone()、fetchmany(size=cursor.arraysize)、fetchall()：用来读取数据
l fetchone()读取数据
l import sqlite3
l conn = sqlite3.connect("D:/addressBook.db")
l conn.execute("CREATE TABLE addressList(name , sex , phon , QQ ,
address)")
l cur = conn.cursor() #创建游标
l cur.execute('''INSERT INTO addressList(name , sex , phon , QQ ,
address) VALUES('王小丫' , '女' , '13888997011' , '66735' , '北京市
' )''')
l cur.execute('''INSERT INTO addressList(name, sex, phon, QQ, address)
VALUES('李莉', '女', '15808066055', '675797', '天津市')''')
l cur.execute('''INSERT INTO addressList(name, sex, phon, QQ, address)
VALUES('李星草', '男', '15912108090', '3232099', '昆明市')''')
l conn.commit() #提交事务，把数据写入数据库
l cur.execute('SELECT * FROM addressList')
l li = cur.fetchall() #返回所有查询结果
l for line in li:
l for item in line:
l print(item, end=' ')
l print()
l
conn.close()
数据库操作4
7
47
fetchone()读取SQLite数据
【
05P47.py】
l fetchone()读取数据
l conn = sqlite3.connect("D:\\test.db")
l c = conn.cursor()
l c.execute('''CREATE TABLE stocks(date text, trans text, symbol
text, qty real, price real)''')
l c.execute("""INSERT INTO stocks VALUES ('2006-01-
05','BUY','RHAT',100,35.14)""")
l conn.commit()
l conn.row_factory = sqlite3.Row
l c.execute('SELECT * FROM stocks')
l r = c.fetchone()
#使用fetchone()读取数据
l print(type(r))
l print(tuple(r))
l print(r[2])
l print(r.keys())
l print(r['qty'])
l for field in r:
l
print(field)
