Python调用接口识别手机号码归属地

AustinGJ

已于 2022-02-15 10:53:19 修改

阅读量1k

点赞数

文章标签： python mysql

于 2022-02-15 10:36:32 首次发布

本文链接：https://blog.csdn.net/hiver_de_ete/article/details/122938086

版权

接口：http://cx.shouji.360.cn/phonearea.php?number=xxx 白PIAO的接口谁会拒绝呢？

下面是代码：

import pymysql as db
import requests as req
import json

conn = db.connect(host='127.0.0.1', user='root', passwd='123', db='test', charset='utf8')
cursor = conn.cursor()

sql = "select * from abc where area is null"
cursor.execute(sql)

data = cursor.fetchmany(1000)
for i in data:
    res = req.get("http://cx.shouji.360.cn/phonearea.php?number=" + i[2])
    res.encoding = "utf-8"
    str_res = str(res.text)
    js = json.loads(str_res)
    province = js.get('data').get('province')
    city = js.get('data').get('city')
    area = province+city
    update_sql = "update abc set area = " + "'" + area + "'" + " where cellphone = " + "'" + i[2] + "'"
    cursor.execute(update_sql)
    conn.commit()
    print("号码:%s的地区为:%s,数据库更新成功!" % (i[2], area))

为啥更新一次commit一次呢？我就遇到了IDE宕机，和Mysql事务锁战斗了半天