我是一个帮助翻译文本的助手。
英译中:
英译中:
我刚接触Python,正在尝试将从Arduino串口获取的数据保存到MySQL数据库中,但我只能保存一次,因为我必须再次运行程序才能保存,我尝试使用while循环,但我只能坚持一次保存到数据库,并且不断出现“无法从Arduino获取数据!”的错误信息。
这是我的代码:
import serial
import MySQLdb
dbConn = MySQLdb.connect("localhost","root","sasa","sms") or die ("could not connect to database")
cursor = dbConn.cursor()
device = 'COM3'
try:
print "Trying...",device
arduino = serial.Serial(device, 9600)
except:
print "Failed to connect on",device
try:
data = arduino.readline()
pieces = data.split("\t")
try:
cursor.execute("INSERT INTO industrial (db) VALUES (%s)", (pieces[0]))
dbConn.commit()
cursor.close()
except MySQLdb.IntegrityError:
print "failed to insert data"
finally:
cursor.close()
except:
print "Failed to get data from Arduino!"