程序中未定义连接错误
亲爱的大家,
在SQL DB中的单个表中记录数据时遇到问题。我们做不到这件事。当我们在raspberry pi中运行python代码时,我们得到以下错误消息。
计划:
选择 | 换行 | 行号
- import serial
- import time
- import MySQLdb as mdb
- arduino = serial.Serial("/dev/ttyACM0")
- arduino.baudrate=9600
- data = arduino.readline()
- time.sleep(1)
- data = arduino.readline()
- pieces = data.split("\t")
- temperature = pieces[0]
- humidity = pieces[1]
- con = mdb.connect('localhost', 'root', '12345678', 'testdb');
- with con:
- cursor = connection.cursor(prepared=True)
- sql_insert_query = """ INSERT INTO TempDB (temperature, humidity) VALUES (?,?)"""
- insert_tuple = (temperature, humidity)
- cursor.execute(sql_insert_query, insert_tuple)
- connection.commit()
错误消息
回溯(最近一次呼叫):
文件"./intertDB.py",第20行,in
Cursor=Connection.Cursor(已准备好=True)
NameError:未定义名称'Connection'