def deal_editUrl():
conn = connect('set_os.ini')
cur = conn.cursor()
form_data = cgi.FieldStorage(encoding='gbk')
mixid = form_data.getvalue('spid',None)
ip = form_data.getvalue('ip',None)
port = form_data.getvalue('port',None)
submitValue = form_data.getvalue('submit',None)
editinfo = '修改'
deltinfo = '删除'
if (mixid and ip and port and submitValue) is not None:
spid = int(mixid.split('&').pop(0))
hurlid = int(mixid.split('&').pop(1))
delMes = '''delete from u_hurl where id=%s''' % hurlid
updMes = '''update u_hurl set ip='%s',port=%s where id=%s''' % (ip,port,hurlid)
if submitValue == editinfo:
cur.execute(updMes)
conn.commit()
if submitValue == deltinfo:
cur.execute(delMes)
conn.commit()
editUrl()
def get_response():
spid = ""
ip = ""
port = ""
# print(Osyate.start_response())
form_data = cgi.FieldStorage()
if form_data:
spid = form_data.getvalue("spid")
ip = form_data.getvalue("ip")
port = form_data.getvalue("port")
conn = connect("set_os.ini")
cursor = conn.cursor()
if spid is not None and spid != "" and spid is not None and spid != "" and ip is not None and ip != "":
cursor.execute("""insert into u_hurl (spid,ip,port,statusid) values(%s,'%s',%s,%s)""" % (spid, ip, port, 1))
conn.commit()
conn.close()
editUrl()
#!/usr/bin/env python #coding:UTF-8 from rice import editUrl editUrl()