data:
tes120@qq.com
safdsf@foxmail.com
tes120@qq.com
safdsf@foxmail.com
tes120@qq.com
safdsf@foxmail.com
tes120@qq.com
safdsf@foxmail.com
python:
#!/bin/py
# -*- coding: utf-8 -*-
import MySQLdb
conn = MySQLdb.connect(host='localhost',user='1',passwd='1',charset='utf8')
cursor = conn.cursor()
cursor.execute('use zcwdb');
list = []
f = open("data.txt","r")
for read in f.readlines():
if(read.find("\n")>0):
read=read[0:len(read)-1]
list.append(read);
#print list
#while(w=print f.readline()):
# print w;
sql = "select id from auth_user where email ='%s'";
for l in list:
cursor.execute(sql%l)
results = cursor.fetchall()
print l+"\t",results
#获取数据
#cursor.execute('select * from test')
#results = cursor.fetchall()
#for r in results
# print r
#conn.close()
分享到:
2012-05-24 14:25
浏览 533
评论