test_sqlite.py 测试代码:
import os, sys
import sqlite3
if len( sys.argv ) ==2:
p1 = sys.argv[1]
else:
print 'usage: test_sqlite3.py code '
sys.exit(1)
db = sqlite3.connect("./test.db")
cur = db.cursor()
cur.execute("select code,cname from table where code=? ",(p1,))
result = cur.fetchall()
for tup in result:
for t in tup:
print t.encode('cp936'),
print
#
cur.close()
db.close()