show status.py

来自「该程序是一个DDNS实现的演示程序」· Python 代码 · 共 15 行

import MySQLModule
import time
db=MySQLModule.dbtools("172.30.70.126","ddns","root","753159")
conn=db.getconn()
cursor=conn.cursor()
while True:
    cursor.execute("FLUSH Tables")
    sql="select * from ddns_user where u_name = 'abc'"
    cursor.execute(sql)
    res=cursor.fetchone()
    print "Status>>",res[4]
    time.sleep(0.5)