获取mysql连接
conn=pymysql.connect(host="localhost",user="uroot",password="000000",port=3306,database='BeiKei')
cursor=conn.cursor()
sql='INSERT INTO zufang(housetitle,housetype,price) values(%s,%s,%s)'
for x in range(1,3):
doc=pq(bw.page_source)
房子主题
housetitle=doc('.twoline').text()
print(housetitle)
户型信息
housetype=doc('.content__list--item--des').text()
print(housetype)
价格
price=doc('.content__list--item-price').text()
print(price)
try:
cursor.execute(sql, (housetitle, housetype, price))
conn.commit()
except:
conn.rollback()
conn.close()
怎么写这个循环才能将数据写入数据库