C++ QSqlQuery::addBindValue方法代码示例

//插入一行记录
bool DBModule::insertLine( const QString &title, const QString &artist, const QString &time, const QString &filePath )
{
	QSqlQuery query;
	query.prepare("insert into musicList values(?, ?, ?, ?)");
	query.addBindValue(title);
	query.addBindValue(artist);
	query.addBindValue(time);
	query.addBindValue(filePath);
	return query.exec();
}

bool Storage::saveFriends(QJsonArray data)
{
    QDateTime time;
    QString now = time.toLocalTime().toString();

    QSqlQuery query;

    query.exec("drop table friend");

    query.exec("create table friend (id INTEGER primary key autoincrement, "
               "userid varchar(30), realname varchar(30), username varchar(30), email varchar(30),"
               "image varchar(100), lastchat text, lastchattime varchar(20), lastseen varchar(30), updated varchar(30), created varchar(30))");

    qDebug() << query.lastError().databaseText();

    foreach (QJsonValue value, data) {
        QJsonObject dataObject = value.toObject();
        query.prepare("INSERT INTO friend (userid, realname, username, email, image, lastchat, lastchattime, lastseen, updated, created) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
        query.addBindValue(dataObject.value("_id"));
        query.addBindValue(dataObject.value("name"));
        query.addBindValue(dataObject.value("username"));
        query.addBindValue(dataObject.value("email"));
        query.addBindValue("");
        query.addBindValue(dataObject.value("username"));
        query.addBindValue("");
        query.addBindValue(now);
        query.addBindValue(now);
        query.addBindValue(now);
        qDebug() << query.lastError().databaseText();
        query.exec();
        qDebug() << query.lastError().databaseText();

    }

void secondDiagnostics::on_buttonBox_accepted()
{
    QSqlQuery query;
    query.prepare("insert into diagnosis(fk_customer, fk_doctor, type, dateD, timeD) values(?, ?, 1, ?, ?)");
    query.addBindValue(custID);
    query.addBindValue(docID);
    query.addBindValue(ui->dateEdit->date());
    query.addBindValue(ui->timeEdit->time());
    query.exec();
    this->deleteLater();
}

void Tag::addToMedia(int mediaId)
{
    QSqlQuery query;
    query.prepare("INSERT INTO " TABLE_MediaTags " (" KEY_MediaTags_MediaId ", " KEY_MediaTags_TagId ") VALUES(?, ?)");
    query.addBindValue(QVariant(mediaId));
    query.addBindValue(QVariant(Id));
    if(!query.exec())
    {
        QLOG_ERROR() << "Failed to add MediaTag record: " + query.lastError().text();
    }
}

 bool EditableSqlModel::setL(int Id, const QString &str, int l)
 {
    QSqlQuery query;
    if(l == 1)
        query.prepare("update dict set  l1 = ? where id = ?");
    else
        query.prepare("update dict set  l2 = ? where id = ?");
    query.addBindValue(str);
    query.addBindValue(Id);
    return query.exec();
 }

bool Warning::addWarning(){

    QSqlQuery query;
      query.prepare("insert into Warning(bid,wtype,wmsg,wtime)""values(?,?,?,?)");
      query.addBindValue(this->bid);
      query.addBindValue(this->wtype);
      query.addBindValue(this->wmsg);
      query.addBindValue(this->wtime.toString("yyyy-MM-dd hh:mm:ss"));
       return query.exec();

}

//把学生主观题答案插入主观题答案表
void DBManager::insertSubAnswers(int fpaperid,QString studentid)
{

    QSqlQuery query;
    query.prepare("insert into subanswers(fpaperid,studentid)" "values(?,?)");
    query.addBindValue(fpaperid);
    query.addBindValue(studentid);
    query.exec();
    qDebug() << "insertSubAnswers] " << query.lastError();

}

bool book::reverse(int vipID, QDateTime bookTime, int bookRow)
{
	QSqlQuery sql;
	if (!isValid(vipID) || rowIsOccupied(bookRow, bookTime))//等VIP好了以后测试
		return false;
	sql.prepare("INSERT INTO book_record VALUES (NULL, ?, ?, ?);");
	sql.addBindValue(vipID);
	sql.addBindValue(bookTime.toString("yyyy-MM-dd h:m:s"));
	sql.addBindValue(bookRow);
	return sql.exec();
}

bool CanceledOrder::add(Model::CanceledOrder canceledOrder)
{
    DatabaseManager mgr;
    QSqlQuery query;

    query.prepare("INSERT INTO order_canceled(order_id, cancel_time) VALUES(?,?)");
    query.addBindValue(canceledOrder.order().id());
    query.addBindValue(QDateTime::currentDateTime());

    return query.exec();
}

QSqlQuery DatabaseManager::insertSpriteRecord(const SpriteModel& spriteModel) {
    QSqlQuery query;
    query.prepare("INSERT Into Sprite (SPRITE_TYPE_ID, X, Y) VALUES(?,?,?)");
    query.addBindValue(spriteModel.getSpriteTypeId());
    query.addBindValue(spriteModel.getX());
    query.addBindValue(spriteModel.getY());
    query.exec();
    QSqlQuery query2;
    query2.prepare("SELECT * FROM Sprite ORDER BY SPRITE_ID DESC");
    query2.exec();
    return query2;
}

Database::MarkParameters Database::getValuesFromDatabase(int id_question)
{
    QSqlQuery query;
    query.prepare("SELECT ef, counter, date, interval "
                  "FROM marks "
                  "WHERE id_user = ? AND id_question = ?");
    query.addBindValue(currentUserId_);
    query.addBindValue(id_question);
    query.exec();
    query.next();
    return MarkParameters(query.value(0).toDouble(), query.value(1).toInt(), query.value(2).toLongLong(), query.value(3).toInt());
}

bool DataBase::is_white(int id_game, QString &id_player){
    cout << "is_white()" <<endl;
    QSqlQuery query;
    query.prepare(QString("SELECT * FROM games WHERE id = ? AND player_1 = ?;"));
    query.addBindValue(id_game);
    query.addBindValue(id_player);
    if(!query.exec()){
        cout << query.lastError().text().toStdString() << endl;
        return false;
    }
    return query.next();
}

bool SnippetModel::addEntry(QString title, QString tags, QString language, QString code)
{
    QSqlQuery query;
    query.prepare("INSERT INTO SNIPPETS(id, title, tags, language, code) values(NULL, ?, ? ,?,?)");
    query.addBindValue(title);
    query.addBindValue(tags);
    query.addBindValue(language);
    query.addBindValue(code);

    if(query.exec()) return true;
    return false;
}

void FormGestioneFerie::on_pbAggiungiPermesso_clicked()
{
    for(QDate a=ui->dePermessiDal->date(); a.operator <=( ui->dePermessiAl->date());a= a.addDays(1) )
   {

    qDebug() << "Permesso per "+ui->cbMatricola->currentText()+" per il giorno "+a.toString("dd/MM/yyyy");


    QSqlQuery query;
    query.prepare("INSERT INTO assenze (ID, matricola, causa, data)" "VALUES (?, ?, ?, ?)");
   // query.addBindValue( ui->cbMatricola->currentText()+"_"+ui->dePermessiDal->date().toString("dd/MM/yyyy"));
    query.addBindValue( ui->cbMatricola->currentText()+"_"+a.toString("dd/MM/yyyy"));
    query.addBindValue( ui->cbMatricola->currentText());
    query.addBindValue( ui->cbTipoPermesso->currentText());
   // query.addBindValue( ui->dePermessiDal->date().toString("dd/MM/yyyy"));
    query.addBindValue( a.toString("dd/MM/yyyy"));
    if(query.exec())
    {
        QMessageBox msgBox;
        msgBox.setText("Inserzione nel database.");
        msgBox.setInformativeText(QString("Permesso per il giorno %1 inserito correttamente.").arg(a.toString("dd/MM/yyyy")));
        msgBox.setStandardButtons(QMessageBox::Ok );
        msgBox.setIcon(QMessageBox::Information);
        msgBox.exec();
    }
    else
    {
        QMessageBox msgBox;
        msgBox.setText("Inserzione nel database.");
        msgBox.setInformativeText(QString("Permesso per il giorno %1 NON inserito nel database. Probabilmente è gia stato inserito un permesso per lo stesso giorno.").arg(a.toString("dd/MM/yyyy")));
        msgBox.setStandardButtons(QMessageBox::Ok );
        msgBox.setIcon(QMessageBox::Critical);
        msgBox.exec();
    }

    QSqlTableModel *model = new QSqlTableModel(this, this->db);
    model->setTable("assenze");
    model->setEditStrategy(QSqlTableModel::OnFieldChange);
    model->select();
    model->setFilter(QString("Matricola=\"%1\"").arg(ui->cbMatricola->currentText()));

    model->sort(2,Qt::AscendingOrder);
      model->setHeaderData(1, Qt::Horizontal, tr("MATRICOLA"));
      model->setHeaderData(2, Qt::Horizontal, tr("DATA"));
      model->setHeaderData(3, Qt::Horizontal, tr("CAUSA"));
      ui->tvPermessi->setModel(model);
      ui->tvPermessi->hideColumn(0);
      ui->tvPermessi->resizeColumnsToContents();
      ui->tvPermessi->resizeRowsToContents();
      ui->tvPermessi->selectRow(0);

  }
}

void Database::writeShieldHis()
{

    QSqlDatabase::database().transaction();
    QDateTime datetime = QDateTime::currentDateTime();
    QSqlQuery query;
    query.setForwardOnly(true);

    query.prepare("INSERT INTO shieldhis( time,unitid,type)"
                  "VALUES ( ?, ?,?)");

    query.addBindValue(datetime);
    query.addBindValue(0x01000000);
    query.addBindValue(0x00FFFF00);

    bool bSuccess = query.exec();
    if (!bSuccess)
    {
        QSqlError lastError = query.lastError();
        qDebug() << lastError.driverText()
                 <<QString(QObject::tr("in datebase : insert soundandalarmdevice into the shieldhis error"));
    }

//    QDateTime dt = QDateTime::currentDateTime();

//    /*Before the opening of each transaction，adding this code to improve the speed*/
//    QSqlDatabase::database().transaction();
//    QSqlQuery query;
//    query.prepare("INSERT INTO shieldhis( time,unitid,type)"
//                  "VALUES ( ?, ?,?)");

//    int host = 1;
//    int iobr = 1;
//    int loop = 1;


//    for (int i = 0;i<100; i++)
//    {
//        query.addBindValue(dt);
//        query.addBindValue((host<<24) | (iobr<<16) | (loop<<8) | (i+1));
//        query.addBindValue(0x000000FF);
//        bool bSuccess = query.exec();
//        if (!bSuccess)
//        {
//            QSqlError lastError = query.lastError();
//            qDebug() << lastError.driverText()
//                     <<QString(QObject::tr("insert shieldhis error"));
//        }
//    }
    /*Close the transaction*/
    QSqlDatabase::database().commit();
}