#_*_coding:gb18030_*_
try:
cn = sqlite3.connect('sqlite.db')
f = open('E:/jquery/数据库test/data/data.txt','r')
cn.text_factory = str
cur = cn.cursor()
for line in f:
s = line.split('|')
cur.execute('insert into userinfoss values(?,?,?,?)',(s[0],s[1],s[2],s[3]))
except Exception,e:
print e
cn.commit()
cur.close()
cn.close()
insert into userinfoss values(?,?,?,?)',(s[0].decode('gbk').encode(utf-8'),s[1].decode('gbk').encode(utf-8'),s[2].decode('gbk').encode(utf-8'),s[3].decode('gbk').encode(utf-8'))
作者: linzkkk 时间: 2014-12-05 14:14
还有一个问题,我像下面这样从dos输入中文来查就不行了
name = str(raw_input('要查找的人>'))
if name == '0':break
cur.execute('select * from userinfoss where a1 = ?' , (name.decode('gbk').encode('utf-8')))
这样提示:
cur.execute('select * from userinfoss where a1 = ?' , (name.decode('gbk').encode('utf-8')))
sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 9 supplied.