|
- SqlDatabase db = QSqlDatabase::addDatabase("QODBC");
- db.setHostName("127.0.0.1");
- QString dsn = QString::fromLocal8Bit("DRIVER={SQL SERVER};SERVER=127.0.0.1;DATABASE=xxxxx");
- db.setDatabaseName(dsn);
- db.setUserName("xxxxx");
- db.setPassword("xxxx" );
- db.open();
- ///////////////////////naodu
- QSqlQuery querynd1(db);
- querynd1.exec("select top 1 ID, ReceiveTime,DataValue,SensorCode from [xxxxxs].[dbo].[xxxxx_Table] order by ReceiveTime desc ");
- if(querynd1.next())
- {
- ndid = querynd1.value(0).toInt();
- ndrecvtime= querynd1.value(1).toString();
- nddataValue=querynd1.value(2).toFloat();
- ndsensorCode=querynd1.value(3).toString();
- QString naoduIdsqlCmd=QString ("select ID from [xxxxx].[dbo].[Sensor] where Code='%1' ").arg(ndsensorCode);
- QSqlQuery querySensorId(db);
- querySensorId.exec(naoduIdsqlCmd);
- if(querySensorId.next())
- {
- naoduId=querySensorId.value(0).toInt();
- }
- }
-
- QSqlDatabase mysqldata= QSqlDatabase::addDatabase("QMYSQL");
- mysqldata.setHostName("xxxxxxx");
- mysqldata.setPort(3306);
- mysqldata.setDatabaseName("ixxxxxx");
- mysqldata.setUserName("xxxx");
- mysqldata.setPassword("xxxxxxxx");
- mysqldata.open();
- ///////////////////naodu
- QSqlQuery querynd2(mysqldata);
- QString ndsqlCmd=QString ("INSERT INTO ib_data_wusu "
- "VALUES (NULL,%1,'%2',%3,0,'%4')").arg(naoduId).arg(ndsensorCode).arg(nddataValue).arg(ndrecvtime);
- querynd2.exec(ndsqlCmd);
复制代码 |
|