python3 连接sqlite实例，直接上代码吧
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
|
import sqlite3db = r"D:\pyWork\test.db" #pyWork目录下test.db数据库文件drp_tb_sql = "drop table if exists staff"crt_tb_sql = """create table if not exists staff( id integer primary key autoincrement unique not null, name varchar(100), city varchar(100));"""#连接数据库con = sqlite3.connect(db)cur = con.cursor()#创建表staffcur.execute(drp_tb_sql)cur.execute(crt_tb_sql)#插入记录insert_sql = "insert into staff (name,city) values (?,?)" #?为占位符cur.execute(insert_sql,('Tom','New York'))cur.execute(insert_sql,('Frank','Los Angeles'))cur.execute(insert_sql,('Kate','Chicago'))cur.execute(insert_sql,('Thomas','Houston'))cur.execute(insert_sql,('Sam','Philadelphia'))con.commit()#查询记录select_sql = "select * from staff"cur.execute(select_sql)#返回一个list，list中的对象类型为tuple（元组）date_set = cur.fetchall()for row in date_set: print(row)cur.close()con.close() |
© 版权声明
文章版权归作者所有，未经允许请勿转载。
THE END
暂无评论内容