Chapter one in Linux python read serial memory MySQL database (703N)

Import mysqldb//define driver files for reference databases

Import serial

Import time

Ser = serial. Serial ('/dev/ttyath0 ', 115200, timeout=65)//Read serial

While True:

data = Ser.readline ()

Print repr (data)//output Read

Conn=mysqldb.connect (host= ' 192.168.2.1 ', user= ' root ', passwd= ' root ', db= ' ma '//Connect to Database

Cursor=conn.cursor ()

Sql= "INSERT into data (M_message) values (%s)"//Insert Database

#原创内容

#转载请: http://www.cnblogs.com/xianfangloveyangmei/p/4091914.html

PGG = Data

PGA = (PGG)

n = cursor.execute (SQL,PGA)

Print n

Print PGG

#print (Time.strftime ("%h:%m:%s"))

Chapter one in Linux python read serial memory MySQL database (703N)