LOFTER-网易轻博

爬取后的内容是列表形式，如何转化为字符串类型？

解决办法：使用str()方法

b = strTemp.xpath('./div[3]/div[1]/div/div/div[1]/div/ul/li[3]//text()')        agee = str(b) 

注意：数据库中对对应的字段类型要与python中一致

2）python 与 mysql 数据库连接

connection = pymysql.connect(host='localhost',                                     user='root',                                     password='zaizaizai',                                     db='layer',                                     charset='utf8mb4')        try:            # 获取会话指针            with connection.cursor() as cursor:                # 创建SQL语句                sql = "insert into layer(namee,organization,sex,age,nation,edu,leixing,zhengzhi,numberr,first_time,get_time,status,paizhu,sifaju,email) values (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s) "                # 执行SQL语句                cursor.execute(sql, (namee, organization, sex, age, nation, edu, leixing, zhengzhi, numberr, first_time, get_time, status, paizhu, sifaju, email))                # 提交                connection.commit()        finally:            connection.close()