本文共 1116 字,大约阅读时间需要 3 分钟。
读取mysql 的数据有两种方式
1.MySQLdb模块操作的MYSQL数据库
from urllib import urlopen; conn = MySQLdb.connect(host="127.0.0.1",user="root",passwd="root",charset="utf8"); cur.execute("USE test");#指定数据库 cur.execute("TRUNCATE TABLE cri");#指定数据库中的数据表 content = urllib2.urlopen((".txt"));#读取在线文件或指定路径的文件 idPattern = r"\d{8}\.\d{2}"; pattern = re.compile(idPattern); match = pattern.findall(content.read()); sql = "INSERT INTO cri (CRI) VALUES(%s)"; #cur.execute("SELECT * FROM cri"); class getPltfList(object): def __init__(self): self.db = web.database(dbn='data_name', db = 'table_name', user = 'root', pw= ' ', host = '127.0.0.1') self.db.printing = True#是指打印mysql语句 def ___call__(self): return self.createPltfList() def createPltfList(self): self.pltfList = list(self.db.query('select name, ip from EPISODE_INSTANT_INFO order by id DESC')) if __name__ == '__main__' : pltfList = getPltfList()() for pltf in pltfList: print pltf['name'], pltf['ip'] 转载地址:http://hgini.baihongyu.com/