读取串口数据存入数据库

import serial
import mysql.connector

# 配置串口参数
ser = serial.Serial(
    port='/dev/ttyUSB0',  # 串口设备
    baudrate=9600,       # 波特率
    timeout=1            # 超时时间
)

# 连接数据库
db = mysql.connector.connect(
    host='localhost',
    user='root',
    password='password',
    database='test_db'
)
cursor = db.cursor()

try:
    while True:
        # 读取串口数据
        data = ser.readline().decode('utf-8').strip()
        if data:
            print(f'Received data: {data}')
            
            # 将数据存入数据库
            sql = "INSERT INTO sensor_data (data) VALUES (%s)"
            cursor.execute(sql, (data,))
            db.commit()
except KeyboardInterrupt:
    print('Exiting...')
finally:
    ser.close()
    cursor.close()
    db.close()