python mysql ping_python取MYSQL数据库里的IP来PING，将结果再写到数据库中，但是第二次再取IP时便出错，取出来是空的...

#_*_coding:utf-8_*_importMySQLdbasmdbimportsysimportosimportthreadingconn=mdb.connect('localhost','root','root','test');withconn:cur=conn.cursor(mdb.cursors.DictCursor)cu...

# _*_ coding:utf-8 _*_

import MySQLdb as mdb

import sys

import os

import threading

conn = mdb.connect('localhost','root','root','test');

with conn:

cur = conn.cursor(mdb.cursors.DictCursor)

cur.execute("SELECT hostIP,id,status_id FROM website_serverhost")

rows = cur.fetchall()

for row in rows:

print "%s %s" % (row["id"],row["hostIP"])

data = os.system("ping -c 1 %s>/dev/null 2>&1" % row["hostIP"])

if data == 0:

print "%s:正常" % row["hostIP"]

cur.execute("INSERT INTO testrecord(hostIP, status) VALUES ('%s',1)"% row["hsotIP"])

else:

print "%s:中断" % ip

附报错信息：

Traceback (most recent call last):

File "pingServerHost.py", line 25, in

cur.execute("INSERT INTO testrecord(hostIP, status) VALUES ('%s',1)"% row["hsotIP"])

KeyError: 'hsotIP'

展开