从数据库中读数据
来源:互联网 发布:mac如何进入安全模式 编辑:程序博客网 时间:2024/04/30 08:19
import pymysqlimport numpy as npdef connectViogidata(ebayno): db = pymysql.connect(host='', user='', passwd='', db='viogidata', port=3306, charset='utf8') cursor = db.cursor() sql = ' select id, ebayno, product_name, price, currency, when_time,shop_name from feedback where ebayno = %s' cursor.execute(sql,(ebayno)) db.commit() cursor.close() db.close() result = cursor.fetchall() return resultdef connectLocal(): db = pymysql.connect(host='localhost', user='root', passwd='', db='test', port=3306, charset='utf8') cursor = db.cursor() sql = ' select ebayno from ebayno ' cursor.execute(sql) db.commit() cursor.close() db.close() result = cursor.fetchall() return resultif __name__ == '__main__': file_object = open("feedback.txt","w") file_object.write(" id, ebayno, product_name, price, currency, when_time,shop_name\n") result = connectLocal() result = list(result) re = [] # id = "401289199654" # idd="232265687646" # feedback = connectViogidata(id) #得到元组数据 # if feedback is not None: # for row in feedback: #去掉外层括号 # file_object.write(str(row[0]) + "," + str(row[1]) + "," + str(row[2]) + "," + str(row[3]) + "," + str( row[4]) + "," + str(row[5]) + "," + str(row[6]) + "\n") # for i in result: ebayno = i[0] feedback = connectViogidata(ebayno) #得到元组数据 if feedback is not None: for row in feedback: # 去掉外层括号 file_object.write(str(row[0]) + "," + str(row[1]) + "," + str(row[2]) + "," + str(row[3]) + "," + str( row[4]) + "," + str(row[5]) +","+str(row[6]) + "\n")
阅读全文
0 0
- 从数据库中读数据
- 从数据库中读数据建立菜单
- WR 从数据库读数据到Excel中
- 从access数据库中读数据建立tree
- 从excel读数据到数据库表中
- 从sql数据库中读数据来创建tree
- 从外部配置文件中读数据库语句查询数据库
- Android数据库代码优化(3) - 从Cursor中读数据
- Spark从数据库读数据操作
- fgets()函数从文件中读数据
- 网页从xml文件中读数据
- storm从kafka中读数据
- 从text文件中读数据
- sql server compact 从数据库中读数据并显示图片
- 从文件读数据
- Qgis从数据库读数据到渲染当前视图
- 从csv中读数据,并写到csv中
- 已解决问题:从Excel中读数据到数据库,本地VS运行都成功,网站发布后不能读取数据
- LeetCode -- 213. House Robber II
- lua教程五
- IDEA14.0.2安装教程
- ERROR 500.jsp
- Android TabHost 二
- 从数据库中读数据
- requireJs用法介绍
- 数据库 树形数据结构数据库的设计
- 杭电acm 1266逆序输出
- CAD文件怎么在线转为pdf文件
- 关于反垃圾
- sort-排序
- https和http
- SpringCloud微服务系列(3): 为已有的Eureka Server增加高可用HA