def get_connection():
conn = pythdb.connect(
host = ''
port = ''
user = ''
password = ''
)
return conn
def GetDb(conn)
cursor = conn.cursor()
vendor = ['111111', '222222']
sql = "SELECT ID,TIME FROM AUTOMOTIVE WHERE ID IN (vendor) # 报错
# sql = "SELECT ID,TIME FROM AUTOMOTIVE WHERE ID IN ('111111', '222222') #可以返回值
cursor.execute(sql)
results = cursor.fetchall()
return results
conn = get_connection()
results = GetDb(conn)
for result in results:
print(result)
result
于 2022-08-25 13:01:32 首次发布