擅长:python、mysql、java
<p>是的,把它放进一个for循环。你知道吗</p>
<pre><code>ip_list = [ip_i, ip_n, ip_c, ip_b]
result_list = []
for ip in ip_list:
try:
cur.execute("select IP_ADD,VENDOR,DVC_ROLE,CIRCLE,SSA,REGION from DVC_SUMMARY_DATA where IP_ADD in (%s);" % ip)
except Exception as e:
print("error while fetching details " + str(e))
result_list.append(cur.fetchall())
</code></pre>
<p>我猜是的当前fetchall()不会生成错误,如果它生成错误或您不希望它运行,则可以将它放入try one中。你知道吗</p>
<p>所以我会把它改成这样,以跟踪哪些产生了错误</p>
<pre><code>ip_list = [ip_i, ip_n, ip_c, ip_b]
result_list = []
for ip in ip_list:
try:
cur.execute("select IP_ADD,VENDOR,DVC_ROLE,CIRCLE,SSA,REGION from DVC_SUMMARY_DATA where IP_ADD in (%s);" % ip)
result_list.append(cur.fetchall())
except Exception as e:
print("error while fetching details " + str(e))
result_list.append("ERROR")
</code></pre>