Python调用SQLite(结构化查询语言):
import sqlite3
conn = sqlite3.connect('db\\addressbook.db') # 连接对象
cusor = conn.cursor() # 游标
sql = 'select * from LinkMan' # SQL语言
result = cusor.execute(sql)
for row in result:
print(row) # 读出
## 添加一项 'Marry','1359','1993'
sql = "insert into LinkMan values ('Marry','1359','1993')"
cusor.execute(sql)
conn.commit() # 向SQL提交操作
# conn.close()
## 修改一项 'Peter','1359','1993'
sql = "UPDATE LinkMan SET Mobile='1399' WHERE Name='Peter'"
cusor.execute(sql)
conn.commit() # 向SQL提交操作
## 删除一项
sql = "DELETE FROM LinkMan WHERE rowid=5"
cusor.execute(sql)
conn.commit() # 向SQL提交操作