python的sqlite操作

glcui

#a demo for coding python with sqlite3
import sqlite3
#如果在某些版本中，需要添加以下代码，才能操作成功；
#from _sqlite3 import *
conn=sqlite3.connect("e:\python.db")
print(type(conn))
#conn.text_factory=str
#query
cur=conn.execute("select * from python_config_2")
rs=cur.fetchall()
print(type(rs))
for _li in rs:
print(_li)
cur.close()
#insert into
conn.execute("insert into python_config_2 values(3,'python_version','3.3.1','python版本为3.3.1')")
conn.commit()
#insert into db with utf-8 encoding
"""_str='python版本为3.3.1'.encode('gbk').decode('utf-8','ignore')
_str="insert into python_config_2 values(3,'python_version','3.3.1','"+_str+"')"
conn.execute(_str)
conn.commit()
"""