python文件网络

import pymysql
conn=pymysql.connect(host=‘localhost’,port=3306,db=‘bgdgis’,user=‘root’,password=‘123456’)
cur=conn.cursor()
sql=“insert into students(sname,score) values(‘huang’,33)”
cur.execute(sql)
sql2=“select sname,score from students”
sql3=“delete * from students”
sql4=“update students set name=‘sxf’ where id=22”
cur.execute(sql2)
result=cur.fetchall()
for data in result:
print(data)
conn.commit()
cur.close()

import requests
url='http://u.house.ifeng.com/user/login/validate?’
d1={‘mobile’:‘13133814608’,‘pwd’:‘933032shixinfa’}
cookie={‘userid’:‘1562566216762_au61q542851’}
rep=requests.post(url,d1,cookie)
print(rep.json())
print(rep.text)