PYTHON远程操作数据库
上一篇 /
下一篇 2010-12-24 12:05:49
/ 个人分类:自动化测试
安装之前需要先将mysqlldb安装上
函数形式为:
#encoding=utf-8
import sys
import MySQLdb
def connect_mysql(host,port,user,passwd,db,sql):
# con=MySQLdb.connect(host="10.255.254.208",port=3306, user= "writeuser",passwd="ddbackend",db= "ProductPage",charset='utf8')
con=MySQLdb.connect(host=host,port=port,user=user,passwd=passwd,db=db,charset='utf8')
cursor = con.cursor()
cursor.execute(sql)
rows = cursor.fetchall()
v=rows[0]
s=len(v)
print s
for i in range(s-1):
print v[i] ##以元组的形式存储
例如:
connect_mysql("10.255.254.208",3306,"username","passwd","ProductPage","select * from Products_Core where Product_ID=76009")
收藏
举报
TAG: