You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
29 lines
1.0 KiB
29 lines
1.0 KiB
# -*— codeing = utf-8 -*-
|
|
# @Time : 2022/2/27 20:34
|
|
# @Author : 吴锦婷
|
|
# @File : main.py
|
|
# @Softwate : PyCharm
|
|
from Selenium爬虫.test import Seleniunspide
|
|
from SpidetMysql.test import sql
|
|
|
|
# 到时候，这里写个窗口输入
|
|
|
|
city_form = {'全国': 100010000, '北京': 101010100, '上海': 101020100, '广州': 101280100, '深圳': 101280600, '杭州': 101210100, '天津': 101030100, '西安': 101110100, '苏州': 101190400, '武汉': 101200100, '厦门': 101230200, '长沙': 101250100, '成都': 101270100, '郑州': 101180100}
|
|
|
|
while 1:
|
|
city = input("请输入查询的城市：")
|
|
job = input("请输入查询的职业：")
|
|
choose = input("确认吗？(y/n)")
|
|
if choose == "y":
|
|
for _ in city_form:
|
|
if city == _:
|
|
city_code = city_form[_]
|
|
break
|
|
job_list = Seleniunspide().citydata(city_code, job) # 到时候得得到对应的字典才行
|
|
sql().create_table(city)
|
|
sql().Insert_datas(city, job_list)
|
|
else:
|
|
print("感谢使用！")
|
|
|
|
|