CharlieTian's recent timeline updates CharlieTian's recent timeline updates | CharlieTianV2EX member #68776, joined on 2014-07-23 21:31:07 +08:00 |
 | Per CharlieTian's settings, the topics list is hidden |
Deals info, including closed deals, is not hidden
CharlieTian's recent replies
Mar 16 Replied to a topic by YunFun 推广 [中转] Opus-4-6 thinking 上线，限时免费开蹬！回帖参与狂送 20 刀！ |
来自站点：bestaigate.top ，我的 id 是:7883
Aug 19, 2025 Replied to a topic by Bullish 剧集 一句话证明你看过《凡人修仙传》 |
摸了摸下巴 摸了摸下巴 摸了摸下巴
Dec 19, 2024 Replied to a topic by zhangsimon 推广 分享下副业经历，顺便抽个奖 |
支持下
Jan 11, 2023 Replied to a topic by gejun123456 分享创造 [抽奖送码] Intellij MybatisCodeHelperPro 插件更新 3.1.5 版本，更好的 Mybatis 动态 sql 支持，评论送激活码 |
支持
Dec 29, 2018 Replied to a topic by CSGO 问与答 hiformance 跑路了？ |
@CharlieTian paypal 已经全额退款到信用卡
Dec 28, 2018 Replied to a topic by CSGO 问与答 hiformance 跑路了？ |
不要慌,paypal 退款了,一个月内到帐.
Nov 30, 2018 Replied to a topic by tnt666666 程序员 spring boot 有生成代码的脚手架吗？ |
Jhipster
Mar 14, 2018 Replied to a topic by ghostgril 职场话题 都说金三银四，但是对于跳槽我现在还没有好的准备，该不该走呢 |
不要怕这怕那的，没有好的项目就找一个好的公司，没有好的公司就找一个好的领导，没有好的领导就自己干
Jan 5, 2018 Replied to a topic by Iamdoudou Python Python 报错“local variable ‘id’ referebced before assigment” |
```
def process_contenturl(url,picture,price,desc):#处理具体商品链接内容
a=requests.get(url)
change=etree.HTML(a.content)
l=change.xpath('//div[@id="attributes"]/ul/li/text()')
stock=change.xpath('//*[@id="J_SpanStock"]/tet()')#获取商品库存
for i in range(len(l)):
l[i]=l[i].replace(u'\xa0', '')
if u"上市年份季节" in l[i]:
saleseason=(l[i])[7:]#上市年份季节
elif u"材质成分" in l[i] :
material=(l[i])[5:]#材质成分
elif u"货号" in l[i]:
id=(l[i])[3:]#货号
elif u"适用性别" in l[i]:
gender=(l[i])[5:]#适用性别
else:
remarks="".join(l)#无关紧要的备注
sql="INSERT INTO UNIQLO(id,price,stock,salseason,material,gender,remarks,picture,desc) VALUE (%s,%s,%s,%s,%s,%s,%s,%s,%s)"%(id,price,stock,material,gender,remarks,picture,desc)
print sql
```
想想 id 什么时候才会被定义
def process_contenturl(url,picture,price,desc):#处理具体商品链接内容
a=requests.get(url)
change=etree.HTML(a.content)
l=change.xpath('//div[@id="attributes"]/ul/li/text()')
stock=change.xpath('//*[@id="J_SpanStock"]/tet()')#获取商品库存
for i in range(len(l)):
l[i]=l[i].replace(u'\xa0', '')
if u"上市年份季节" in l[i]:
saleseason=(l[i])[7:]#上市年份季节
elif u"材质成分" in l[i] :
material=(l[i])[5:]#材质成分
elif u"货号" in l[i]:
id=(l[i])[3:]#货号
elif u"适用性别" in l[i]:
gender=(l[i])[5:]#适用性别
else:
remarks="".join(l)#无关紧要的备注
sql="INSERT INTO UNIQLO(id,price,stock,salseason,material,gender,remarks,picture,desc) VALUE (%s,%s,%s,%s,%s,%s,%s,%s,%s)"%(id,price,stock,material,gender,remarks,picture,desc)
print sql
```
想想 id 什么时候才会被定义
Select Language