由传感器传入、树莓派修改MySQL数据

第一版

import MySQLdbimport RPi.GPIO as GPIOGPIO.setmode(GPIO.BOARD)GPIO.setwarnings(False)GPIO.setup(12,GPIO.IN)#sql connectdb = MySQLdb.connect("localhost","root","998426","test" )cursor = db.cursor()sql = """insert into user(name) values("w")"""while(1):    if GPIO.input(12) == True:        try:           cursor.execute(sql)           db.commit()        except:           db.rollback()db.close()

第二版

from time import sleepimport MySQLdbimport RPi.GPIO as GPIOGPIO.setmode(GPIO.BOARD)GPIO.setwarnings(False)GPIO.setup(12,GPIO.IN,pull_up_down=GPIO.PUD_DOWN) #sql connectdb = MySQLdb.connect("localhost","root","998426","test" )cursor = db.cursor()sql = """insert into user() values()"""while(1):    if GPIO.input(12) == True:        cursor.execute(sql)        db.commit()        sleep(5)db.close()