Return a copy of the string with the leading and trailing characters removed. The chars argument is a string specifying the set of characters to be removed. If omitted or None, the chars argument defaults to removing whitespace. 

The most common whitespace characters may be typed via the space bar or the tab key. Depending on context, a line-break generated by the return or enter key may be considered whitespace as well.

!/usr/bin/python

#!Filename = username_indb.py

 

import MySQLdb

try:

    conn=MySQLdb.connect(host = "localhost", user = "root", passwd ="123@qwe",db = "test",port = 3306)

    cur=conn.cursor()

    cur.execute("select username from userinfor")

    result = cur.fetchall()

    cur.close()

    conn.close()

except MySQLdb.Error,e:

    print "MySQLdb error %s :%s" %(e.args[0],e.args[1])

data=[]

#print result

for i in range(0,len(result)):

    data.append(result[i][0])

#print data

 

 

for line in open("C:\Python27\scriptKing\username.txt"):

    if line.strip() in data:

        #tips:'line.strip()' is used to  remove '/n'

        print line,1

    else:

        print line,0