Python scraper如何添加mysql插入

Question

我的代码有什么问题？我想将 %s 添加到我的 mysql 数据库。

 titlux = tree.xpath('//*[@id="offer-title"]/h1/text()')
 pretx = tree.xpath('//*[@id="offer-price-stock"]/div[3]/span/@content')

 print "%s," % titlux 
 print "%s," % pretx
 print "\n"
 conn = ..............

 x = conn.cursor()

 try:
    x.execute ("""INSERT INTO produse (titlu, pret) VALUES (%s, %s)""")
    conn.commit()
 except:
    conn.rollback()

 conn.close()

Answer 1

您在 SQL 插入中缺少替换变量和一些引号。将其更改为:

x.execute ("""INSERT INTO produse (titlu, pret) VALUES ("%s", "%s")""" % (titlux[0], pretx[0]))