python3 連線sqlite例項,直接上程式碼吧
import sqlite3 db = 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() #建立表staff cur.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()