python sqlite3的常规使用
#Filename: DBcon.py import sqlite3 import time conn=sqlite3.connect(r'D:\Exercise\Python\DB\example.db') c=conn.cursor() c.execute("Create table if not exists stocks (date text, trans text, symbol text, qty real, price real)") flag=raw_input("Do you wanna clean the table?(y/n):") if flag=='y': c.execute("delete from stocks") c.execute("Insert into stocks values('"+time.strftime('%Y-%m-%d %H:%m:%S')+"', 'Buy','Rhatd',1000,23.14)") conn.commit() c.execute('select * from stocks') res=c.fetchall() count=0 print res print '-'*60 for line in res: for f in line: count=count+1 print count,f, print print '-'*60 print '-'*60 print 'There are %d records!' %count c.close() conn.close()