def deal_editMac():
osname = ""
osid = ""
# print(Osyate.start_response())
form_data = cgi.FieldStorage(encoding="gbk")
conn = connect("set_os.ini")
cur = conn.cursor()
mid = form_data.getvalue("spid", None)
mac1 = form_data.getvalue("mac1", None)
mac2 = form_data.getvalue("mac2", None)
submitinfo = form_data.getvalue("submit")
deltinfo = "删除"
updinfo = "修改"
if (mid and mac1 and mac2) is not None:
spid = int(mid.split("&").pop(0))
devid = int(mid.split("&").pop(1))
deltMes = """delete from u_devices where id=%s""" % devid
updMes = """update u_devices set mac_l='%s', mac_u= '%s' where id=%s""" % (mac1, mac2, devid)
if submitinfo == deltinfo:
print("deddd")
cur.execute(deltMes)
conn.commit()
if submitinfo == updinfo:
cur.execute(updMes)
conn.commit()
editMac()
def get_response():
osname =''
spid=''
pickosmac=''
mac1=''
mac2=''
#print(Osyate.start_response())
form_data = cgi.FieldStorage()
if form_data:
osname = form_data.getvalue('osname')
spid = form_data.getvalue('spid')
pickosmac = form_data.getvalue('pickosmac')
mac1 = form_data.getvalue('mac1')
mac2 = form_data.getvalue('mac2')
conn = connect('set_os.ini')
cursor = conn.cursor()
if pickosmac is not None and pickosmac != '' and ((mac1 is not None and mac1 != '' ) or (mac2 is not None and mac2 != '')):
cursor.execute('''insert into u_devices (mac_l,mac_u,sp_id) values('%s','%s',%s)''' % (mac1,mac2,pickosmac))
conn.commit()
editMac()
#!/usr/bin/env python #coding:utf-8 from rice import editMac editMac()
