我有一个python程序,它连接到mySql表并在其中插入一些值,但它不起作用。这是我的代码:
doc = minidom.parse("wscanOutput.xml")
tracks = doc.getElementsByTagName("track")
for track in tracks:
title = track.getElementsByTagName("title")[0]
location = track.getElementsByTagName("location")[0]
vlcOption = track.getElementsByTagName("vlc:option")[0]
tit = title.firstChild.data[6: ].replace (" ", "-")
loc = location.firstChild.data[18:27]
sid = vlcOption.firstChild.data[8: ]
dvbID = 0
tuneID = 0
db = MySQLdb.connect("localhost","root","paco","dvbDB")
cursor = db.cursor()
print("INSERT INTO dvbDBTable (dvb_id, tune_id, channel_name, sid, frequency) VALUES (%s" % dvbID + ", %s" % tuneID + ", '%s'" % tit + ", %s" % sid + ", %s)" % loc)
sql = "INSERT INTO dvbDBTable (dvb_id, tune_id, channel_name, sid, frequency) VALUES (%s" % dvbID + ", %s" % tuneID + ", '%s'" % tit + ", %s" % sid + ", %s)" % loc
cursor.execute(sql)
db.close()
下面是我的输出print()
,它显示它工作正常:
但数据库仍然为空意味着curser.execute(sql)
未执行。如何执行这些插入?在
尝试将
conn.commit()
添加到代码中。在或
^{pr2}$set connection's autocommit to True
关于你的
execute
风格的一些建议。在试试这个方法:
相关问题 更多 >
编程相关推荐