读取文件，带参数循环查询数据库，并记录结果

import pymssql

'''
读取txt文件，形成列表；
循环查询数据库，并记录结果。
'''


def linkdb(sn):
    # 数据库远程连接
    conn = pymssql.connect(host="127.0.0.1", user="sa",password="password", database="test_02", charset="utf8")

    # 使用cursor()方法获取操作游标
    cursor = conn.cursor()
    # 查询语句
    sql = """
    SELECT distinct [Recode_name]
    FROM [test_02].[dbo].[wangbao_recode]
     where
     RobotCode = %s
     and 
  filename like '202008%'
    """
    try:
        cursor.execute(sql,sn)  # 游标
        result = cursor.fetchall()  # 查询
        # print (result)
    except:
        print("连接数据库报错了！")
    # 关闭数据库连接
    conn.close()
    return result

if __name__ == '__main__':
    sn_1=[]
    # 读取123文件
    with open('123.txt','r') as f:
        for line in f:
            sn_1.append(line.strip('\n').split(',')[0])
    # print (sn_1)
    with open('0.txt','w',encoding='utf-8') as f:
        for sn in sn_1:
            result = linkdb(sn)
            for x in result:
                try:
                    f.write(x[0]+'\t')
                except:
                    print (result)
                    continue
            f.write('\n')