同步操作:
建立连接:数据库的地址,账号,密码,数据库的名字,有中文要存入数据库的话要加charset=‘utf8’
conn = pymysql.connect('localhost', 'root', '5201314', 'electric',charset='utf8')
创建游标:
cursor = conn.cursor()
执行更新操作:
cursor.execute("update remainpower set "+str(time.strftime("%Y_%m_%d", time.localtime()))+"="+item['remainPower']+" where roomId="+item['roomId'])
执行插入操作:
cursor.execute("insert into roomdata(architectureId,architectureName,floorId,floorName,roomId,roomName) values (%s,%s,%s,%s,%s,%s)",(item['architectureId'], item['architectureName'], item['floorId'], item['floorName'],item['roomId'],item['roomName']))
执行查询操作:
cursor.execute("select * from roomdata where roomid = "+roomid)
提交,不进行提交无法保存到数据库:
conn.commit()
得到数据:
data = cursor.fetchall()
最后别忘了关闭连接、游标:
cursor.close()
conn.close()