python使用sqlite3的简单代码,pythonsqlite3代码,#Filename: D
文章由Byrx.net分享于2019-03-23 05:03:37
python使用sqlite3的简单代码,pythonsqlite3代码,#Filename: D
#Filename: DBcon.pyimport sqlite3import timeconn=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=0print resprint '-'*60for line in res: for f in line: count=count+1 print count,f, printprint '-'*60print '-'*60print 'There are %d records!' %countc.close()conn.close()
相关内容
- Python使用剪切板代码,python剪切代码,此段代码可以利用
- python ftplib模块制作ftp客户端,pythonftplib,#!/usr/bin/p
- python验证文件是否可读可写,python验证文件可读,# Imp
- 九九乘法表,乘法,# 9*9for i i
- Python有道字典,python有道,None
- python 学习,使用类模拟购物车代码,python购物车,clas
- 配置文件备份,,None
- 五子棋,,from graphic
- 批量下载文件,,#!/usr/bin/e
- python操作mysql数据库的简单示例,pythonmysql数据库,下面
评论关闭