1.导包
# 连接plc
import snap7
# 连接db点
from snap7 import util
# 连接MySQL
import pymysql
# 获取时间
import time
2.连接MySQL
cnx = pymysql.connect(host='localhost', port=3306, user='root', password='123456', db='qdqm', charset='utf8')
3.创建通讯客户端实例
plcObj = snap7.client.Client()
4.连接到plc
plcObj.connect('192.168.0.6', 0, 2)
5.读取数据
data = plcObj.db_read(9999, 0, 896)
read_data = util.get_int(data, 0)
6.创建游标
cursor = cnx.cursor()
7.获取当前时间
current_time = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime())
8.sql语句
sql = f"INSERT INTO db1 (id,name,value,date) VALUES (1,'张三','{read_data}','{current_time}')
9.执行语句
cursor.execute(sql)
10.提交
cnx.commit()
11.关闭plc连接,关闭数据库连接
plc.disconnect()
cursor.close()
connect.close()