擅长:python、mysql、java
<p>在循环内移动光标初始化</p>
<pre><code>while True:
try:
curs=db.cursor()
curs.execute("""INSERT INTO table_sensor_log(time, koordinatx, koordinaty, koordinatz)
values(%s,%s,%s,%s)""",(time_sensor,x[i],y[i],z[i]))
db.commit()
curs.close()
except:
print "Error"
db.rollback()
time.sleep(1)
</code></pre>