#导入数据库
from PyQt5.QtSql import QSqlDatabase, QSqlQuery
建立数据库并打开
db = QSqlDatabase.addDatabase('QSQLITE')
db.setDatabaseName('DataSave.db')
db.open()
若没有DataSave.db这个文件的时候则会在当前目录新建一个DataSave.db文件。
创建表格log,包含time,topic,projectname等属性
self.query = QSqlQuery()
self.query.exec_("create table log(time varchar(1), topic varchar(100), projectname varchar(100)"
", projectver varchar(100), mdeviceid varchar(100), subdeviceid varchar(100)"
",cmdordata varchar(100),codemode varchar(100),payload varchar(500)"
",msgtype varchar(100),devicetype varchar(100),deviceid varchar(100),serviceid varchar(100))")
批量写入各属性的值
self.query.exec_(
"insert into log (time,topic,projectname,projectver,mdeviceid,subdeviceid,cmdordata,c