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()