Pyhon--Sqlite 建表和查询

import sqlite3def convert(value):    if value.startswith('~'):        return value.strip('~')    if not value:        value = '0'    return int(value)conn=sqlite3.connect('test.db')curs = conn.cursor()#第一次创建使用#curs.execute('''#CREATE TABLE mytable(#    id   int,#    name  char(50),#    age  int#)  ''')insert ='INSERT INTO mytable VALUES(?,?,?)'for line in open('ABBREV.txt'):    fields = line.split('#')    vals = [convert(f) for f in fields[:3]]    curs.execute(insert,vals)conn.commit()query = 'SELECT * FROM mytable ' curs.execute(query)names = [f[0] for f in curs.description]print namesfor row in curs.fetchall():    for pair in zip(names,row):        print '%s:%s' % pair    printconn.close()

附件:ABBREV.txt内容

3#~wahaha~#45
2#~gege~#23
1#~didi~#78