C++ (Cpp) DataBase::connectionOpen Exemples

Exemple #1

Fichier : evictionwindow.cpp Projet : hmlON/HotelAdministrator

void EvictionWindow::on_showAllBtn_clicked()
{
    DataBase db;
    db.connectionOpen();

    QSqlQuery query;
    query.prepare("select * from clients");
    query.exec();

    QSqlQueryModel * model = new QSqlQueryModel();
    model->setQuery(query);
    model->QSqlQueryModel::setHeaderData(0, Qt::Horizontal, "ID");
    model->QSqlQueryModel::setHeaderData(1, Qt::Horizontal, "Имя");
    model->QSqlQueryModel::setHeaderData(2, Qt::Horizontal, "Фамилия");
    model->QSqlQueryModel::setHeaderData(3, Qt::Horizontal, "Паспорт");
    model->QSqlQueryModel::setHeaderData(4, Qt::Horizontal, "Количество дней");
    model->QSqlQueryModel::setHeaderData(5, Qt::Horizontal, "Дата посления");
    model->QSqlQueryModel::setHeaderData(6, Qt::Horizontal, "№ комнаты");
    model->QSqlQueryModel::setHeaderData(7, Qt::Horizontal, "Тип комнаты");
    ui->tableView->setModel(model);
    ui->tableView->resizeColumnToContents(4);
    ui->tableView->resizeColumnToContents(5);

    db.connectionClose();
}

Exemple #2

Fichier : evictionwindow.cpp Projet : hmlON/HotelAdministrator

void EvictionWindow::on_deleteBtn_clicked()
{
    bool ok;
    int id = ui->deleteEdit->text().toInt(&ok);
    if(ok){
        DataBase db;
        db.connectionOpen();

        QSqlQuery query;
        query.prepare("delete from clients where id='"+QString::number(id)+"'");
        if(query.exec())
        {
            QMessageBox::information(this, "Успех!", "Клиент успешно удален!");
        } else {
            QMessageBox::warning(this, "Ошибка!", query.lastError().text());
        }

        db.connectionClose();
        this->close();
    }
}

Exemple #3

Fichier : evictionwindow.cpp Projet : hmlON/HotelAdministrator

void EvictionWindow::on_searchBtn_clicked()
{
    DataBase db;
    db.connectionOpen();

    QSqlQuery query;
    QString searchText = ui->searchEdit->text();
    if(searchText == ""){
        query.prepare("select * from clients");
    } else if(ui->searchType->currentText() == "Номеру комнаты") {
        query.prepare("select * from clients where roomNumber=" + searchText);
    } else if(ui->searchType->currentText() == "Имени") {
        query.prepare("select * from clients where firstName like '%" + searchText + "%'");
    } else if(ui->searchType->currentText() == "Фамилии") {
        query.prepare("select * from clients where lastName like '%" + searchText + "%'");
    } else if(ui->searchType->currentText() == "Паспорту") {
        query.prepare("select * from clients where passport like '%" + searchText + "%'");
    }
    query.exec();

    QSqlQueryModel * model = new QSqlQueryModel();
    model->setQuery(query);
    model->QSqlQueryModel::setHeaderData(0, Qt::Horizontal, "ID");
    model->QSqlQueryModel::setHeaderData(1, Qt::Horizontal, "Имя");
    model->QSqlQueryModel::setHeaderData(2, Qt::Horizontal, "Фамилия");
    model->QSqlQueryModel::setHeaderData(3, Qt::Horizontal, "Паспорт");
    model->QSqlQueryModel::setHeaderData(4, Qt::Horizontal, "Количество дней");
    model->QSqlQueryModel::setHeaderData(5, Qt::Horizontal, "Дата посления");
    model->QSqlQueryModel::setHeaderData(6, Qt::Horizontal, "№ комнаты");
    model->QSqlQueryModel::setHeaderData(7, Qt::Horizontal, "Тип комнаты");
    ui->tableView->setModel(model);
    ui->tableView->resizeColumnToContents(4);
    ui->tableView->resizeColumnToContents(5);

    db.connectionClose();
}