qt sqlquery数据的插入和读写

qt的数据库的部分代码如下：

插入部分：

QSqlQuery query(db); QString t1 = QDateTime::currentDateTime().toString(“yyyyMMdd hh:mm:ss”); QString str1 = temps+”_point”; query.prepare (“INSERT INTO “+str1+” ( infoname,info_address,info_rate,info_value,isactivepower,time) VALUES ( :infoname, :info_address, :info_rate, :info_value,:isactivepower,:time);”); query.bindValue(“:infoname”, data.infoname); query.bindValue(“:info_address”, data.info_address); query.bindValue(“:info_rate”, data.info_rate); query.bindValue(“:info_value”,data.info_value); query.bindValue(“:isactivepower”,data.isactivepower); query.bindValue(“:time”, t1); // qDebug()<<“语句”<<query.lastQuery(); query.exec();

读取部分：

QSqlQuery query(db); QString temps= date; temps.remove(QChar(-),Qt::CaseInsensitive); QMap<int,infovalue> infos; infovalue iec; int hour= QTime::currentTime().hour(); int minutes= QTime::currentTime().minute(); int indexflag=hour*60+minutes; query.prepare(“SELECT * FROM “+temps+” where time =:time and type =:type and indexflag <:indexflag order by indexflag;”); query.bindValue(“:time”, date); query.bindValue(“:type”, type); query.bindValue(“:indexflag”, indexflag);

大概如上所示，具体的数据操作由各自的所需进行编写