Python代码大全之读取与更新sqlite数据库

读取数据

import sqlite3
fname='guzhicha'
dbname=fname+'.db'
conn = sqlite3.connect(dbname)
cursor =conn.execute("select mword.ID,tiqu_all_cjk.kDefinition,mword.mkey from mword,tiqu_all_cjk where mword.mkey = tiqu_all_cjk.mkey and tiqu_all_cjk.kDefinition not NULL ")
wlist=[]
upara=[]
for it in cursor:
	mid,kDefinition,mkey=it
	para=(kDefinition,mid)
	upara.append(para)
	wlist.append(it)

更新数据 update para

def update_para(conn, upara):
	cur = conn.cursor()
	for item in upara:
		sql = ''' UPDATE mword
				SET uni_en = ? 
				WHERE id = ?'''
		cur.execute(sql, item)
	conn.commit()
	

update_para(conn, upara)
conn.close()