用的是QML需要与c++代码做交互。QStringList m_List的数据是从QML里传进来的。
用ON DUPLICATE KEY UPDATE,前半部分是INSERT,如果表内id(主键),则按照id执行后半部分的更新
QSqlQuery query;
QString strselsql = QString("INSERT INTO powerststion"
"(id,product_id,master_id,stationname,shortname,pcap,qtopcap,qbottomcap,voltage) "
"VALUES (%1, %2, %3, '%4', '%5',%6, %7, %8, %9) "
"ON DUPLICATE KEY UPDATE " //重点
"product_id = %2,master_id = %3, stationname = '%4', shortname = '%5', "
"pcap = %6, qtopcap = %7, qbottomcap = %8, voltage = %9")
.arg(m_List.at(0).toInt())
.arg(m_List.at(1).toInt())
.arg(m_List.a