def store_sql(filepath): db=MySQLdb.connet(host="localhost",user="******",passwd="123",db="testdb") cursor=db.cursor() #类似于操作数据库的指针 cursor.execute("show tables in testdb;") tables=cursor.fetchall() findtables=False for table in tables: if 'code' in table: findtables=True print("table already exits") if not findtables: cursor.excute("CREAT TABLE code( id INT NOT NULL AUTO_INCREMENT, code VARCHAR(10) PRIMARY KEY(id) );" ) f=open(filepath,'rb') for line in f.readlines(): coupon=line.strip() cursor.execute("INSERT INTO code VALUES(%s);",[coupon]) db.commit() cursor.close() db.close() if __name__='__main__': store_sql('Running_result.txt')
#pip install mysql-client #http://www.lfd.uci.edu/~gohlke/pythonlibs/#mysqlclient #实验python 是否可以连接上数据库 #python命令环境下 打印import MySQLdb import MySQLdb try: conn = MySQLdb.connet( host='127.0.0.1', user='******', passwd='', db='news', port=3308, charset='utf8' ) #执行 cursor = conn.cursor() cursor.execute('SELECT * FROM 'news' ORDER BY 'created_at' DESC;') rest = cursor.fetchone() #cursor.fetchall() print(rest) #关闭连接 conn.close() except MySQLdb.Error as e: print('Error: %s' % e)
import serial import time import MySQLdb as mdb arduino = serial.Serial("/dev/ttyUSB1", 9600) data = arduino.readline() pieces = data.split("\t") temperature = pieces[0] humidity = pieces[1] con = mdb.connet('localhost', 'gtr', 'gtrlab', 'gtr_2nd') while True: cursor = con.cursor() cursor = execute("""INSERT INTO ITC VALUES(%s,%s,%s)""", ('', temperature, humidity)) con.commit() cursor.close() time.sleep(5)